Mining machinery integrated database for mine operations on bituminous deposits

Tuzla Coal Basin in Bosnia and Herzegovina is the largest coal area in the State. Regional mining industry sensed the need for mining machinery database development in order to achieve easier planning purposes and equipment selection for open cast mines in Tuzla Coal Basin. Several databases for mining machinery used on the bituminous deposits, i.e. on brown coal and lignite mines, were developed at the Faculty of Mining, Geology and Civil Engineering, Tuzla. System Development Method was used as the approach to the database development, generating relational structure of database. First database was established for trucks and was presented as simple table, drawn and filled on the paper sheet. In the next phase, data were stored in spreadsheet type software (Quattro Pro and Excel). Lately developed database is Bucket Wheel Excavator database designed in MS Access. Two concepts, spreadsheet and Access, were integrated into one large database, enabling manipulation of hundreds of data at one place. Required adaptations of existing database in MS Access, enables Access to be used as an integration resource. Database is designed to reserve free memory for input data for mining equipment not considered so far, such as spreaders, crushers, belt conveyors, tripper cars, etc. New, integrated database, at this stage, can be imported to any type of commercial or individual software where needed. Mining machinery integrated database for open cast mine operations is under going testing in a State company, Coal Mines Tuzla. Keywords: Tuzla Coal Basin, machinery database, SDM, relational database