Study on Methods of Building Data Warehouse for Multi-Mine Group Companies

Abstract

In the light of the qualities of grouped companies with multi-mine, we presented a proposal for implementing scientific management referred to as center-distributed data warehouse or hybrid data warehouse that local data warehouse is built for each mine enterprise to satisfy the major production management and decision-making while global one extracts information from them. Applying the objected oriented theory, firstly, we divide basic detail data into six aggregated classes of entities, including engineering information, geological information, mineral resources, other equipment and material information, safety and environment information and financial information management. Then, in the view of difficulties and complexity of building data warehouse, it is significant to create data marts for monitoring department-level transaction data with robust labor-division feature. For avoiding appearance of information silo, distributed data warehouses are primarily built and the subsequent extracted data to construct dependent data marts due to business requirements of various departments. Furthermore, we establish the bridges among these distributed data warehouses to achieve data communication, and finally fulfill the entire plan of data warehouse for multi-mine grouped companies.