SWS Academic Research eLibraryEarth & Planetary Sciences

Scholarly record

DATA WAREHOUSE AS AN INFORMATICS TOOL SUPPORTING A STUDY ON THE EFFECTIVENESS OF USING MINING MACHINES

Jaroslaw Brodny, Magdalena Tutak

First published: 2017-06-20https://doi.org/10.5593/sgem2017/21/s07.031View metrics

Abstract

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.

Publication Impact Profile

PlumX
  • Citations
  • Scopus - Citation Indexes: 1
  • Captures
  • Mendeley - Readers: 7
PLUMX see details

Publication details

Title
DATA WAREHOUSE AS AN INFORMATICS TOOL SUPPORTING A STUDY ON THE EFFECTIVENESS OF USING MINING MACHINES
Authors
Jaroslaw Brodny, Magdalena Tutak
Proceedings
SGEM International Multidisciplinary Scientific GeoConference EXPO Proceedings; 17th International Multidisciplinary Scientific GeoConference SGEM2017, Informatics, Geoinformatics and Remote Sensing
Publisher
STEF92 Technology
Year
2017
Pages
239-246
SWS Citekey
Brodny20177239246
ISSN
1314-2704
ISBN
978-619-7408-01-0
Language
en
Publication type
Conference Paper
Keywords
data warehousemining machineseffectivenessmodel OEE
References0
0references registered for this publication

Structured references will appear here after the reference import pass. The count is preserved now so the scholarly record is not incomplete.

View or Download full articleAccess options
Full paper accessChoose SWS login, librarian support, or instant article download.

SWS access login

Login as SWS Scientific Committee

Authors and approved SWS contributors will read and export their own linked papers after identity matching by SWS profile, email and SGEM GlobalID.

For librarian assistance: [email protected]

Purchase Instant Access

48-hour online accessComing soon
Online-only accessComing soon
Download the full article in PDF formatEUR 35
  • Article can be downloaded after successful payment.
  • Article may be used according to SWS library access terms.
  • Article cannot be redistributed.
Get full paper

Back to publication list