Title: A real-time event-driven database productivity and maintenance planning tool for continuous surface mining operations
Authors: Zach Agioutantis; Stamatini Delmadorou; Nikos Steiakakis; Chrysanthos Steiakakis; Stergios Papaterpos
Addresses: Department of Mining Engineering, University of Kentucky, 230 Mining and Minerals Resources Bldg., 504 Rose St., Lexington KY 40506-0107, USA ' Geosysta Ltd., Kountouriotou 7, Melissia, 15127 Athens, Greece ' Geosysta Ltd., Kountouriotou 7, Melissia, 15127 Athens, Greece ' Geosysta Ltd., Kountouriotou 7, Melissia, 15127 Athens, Greece ' Public Power Corporation, Athens, Greece
Abstract: This paper presents a data management application driven by real-time events, which has been developed as a productivity and maintenance planning software application to be used in the surface lignite mines in Northern Greece. The mines operate using a continuous mining system comprised of multiple bucket wheel excavators, belt conveyors, spreaders and stackers. There is a control centre for each mine, comprising of aspect servers, OPC servers and a SCADA system which interfaces with PLCs at each equipment unit in the field. The overall data management infrastructure is installed on the main network system and draws data from the OPC servers at each mine. In order to collect the data, the application is developed using event driven functionality as well as data polls. Data can then be modified by the control tower personnel. The application generates reports on a daily basis for production monitoring, productivity, equipment performance and utilisation as well as various maintenance tasks. The system has been in operation at the surface lignite mines in northern Greece since 2011 and has been embraced by mine personnel for decision making and planning.
Keywords: supervisory control and data acquisition; SCADA; OPC; programmable logic controller; PLC; database; continuous mining system; productivity; maintenance; belt conveyors.
International Journal of Mining and Mineral Engineering, 2019 Vol.10 No.2/3/4, pp.177 - 188
Received: 27 Dec 2018
Accepted: 29 Mar 2019
Published online: 10 Jan 2020 *