HOME
Full Articles List
Search by Author
Title: DATA WAREHOUSE AS AN INFORMATICS TOOL SUPPORTING A STUDY ON THE EFFECTIVENESS OF USING MINING MACHINES
BibTex 
Open this article in the author's DB |
|
DATA WAREHOUSE AS AN INFORMATICS TOOL SUPPORTING A STUDY ON THE EFFECTIVENESS OF USING MINING MACHINES
|
|
|
|
|
|
|
|
||
|
|
|
|
|
|
1314-2704
|
|
|
|
||
|
|
English
|
|
|
|
17
|
|
|
|
21
|
|
|
|
|
|
|
|
||
|
|
A very important factor, which has a great influence on the financial situation of mining enterprises extracting coal, is an effective use of machines. To determine the level of the use of the machines, it is necessary to reliably evaluate their work. The credibility of such evaluation mainly depends on the quality and the amount of obtained data about the parameters of the machines? work. To synchronize, archive and analytically process the data, it is essential to use appropriate informatics tools. The article presents an example of using such a tool which, in this case, is a data warehouse. The developed data warehouse used for the analysis is supplied with the data about the parameters of the chosen machines? work. This data makes it possible to determine the effectiveness of the studied machines in the area of availability, performance and quality of the product which, in this case, is the excavated coal. The paper discusses the construction and structure of the data warehouse and presents the results of the analysis of a longwall shearer?s and a longwall crusher?s work. The developed and applied computational algorithms make it possible to easily and quickly analyze the data. Despite the fact that the presented data warehouse is dedicated to the mining sector, it is a universal solution. The applied solutions can be used to analyze the effectiveness of the machines in other industries as well.
|
|
|
|
conference
|
|
|
|
||
|
|
||
|
|
17th International Multidisciplinary Scientific GeoConference SGEM 2017
|
|
|
|
17th International Multidisciplinary Scientific GeoConference SGEM 2017, 29 June - 5 July, 2017
|
|
|
|
Proceedings Paper
|
|
|
|
STEF92 Technology
|
|
|
|
International Multidisciplinary Scientific GeoConference-SGEM
|
|
|
|
Bulgarian Acad Sci; Acad Sci Czech Republ; Latvian Acad Sci; Polish Acad Sci; Russian Acad Sci; Serbian Acad Sci & Arts; Slovak Acad Sci; Natl Acad Sci Ukraine; Natl Acad Sci Armenia; Sci Council Japan; World Acad Sci; European Acad Sci, Arts & Letters; Ac
|
|
|
|
239-246
|
|
|
|
29 June - 5 July, 2017
|
|
|
|
website
|
|
|
|
cdrom
|
|
|
|
2959
|
|
|
|
data warehouse; mining machines; effectiveness; model OEE
|
|
Download PDF