Exploring and Designing of Data Warehouse in Coal

Design of multi-dimensional data is required for data warehouse and it is important for establishing a coal mining data warehouse and then individual study and planning of coal industry data warehouse. Characteristics of the coal mining companies, the database is built on coal plants. Based on the system requirements for storing data in carbon minerals, the star structures are accepted in the data warehouse of the Coal Enterprise. Finally, OLAP technology and data warehouse are studied in a coal mine.