The Analysis In Coal Mine Historical Data Based On Data Warehouse

Coal is our national basic energy resource concerning the nation's economic lifelines. Moreover, due to its complicated geological conditions, our coal mine is the one with grievous disaster and frequently-occurring accident causing heavy casualty. Now, most coal mines are equipped with gas monitoring system, which stores a large number of older data. To use these data effectively, this paper quotes the data warehouse and multi-dimensional analysis techniques in data analysis, which can analyse, conclude and summarize the older data of coal mine from different angle and position, and thus greatly improving the efficiency and depth of data analysis, and finding law of the development of accident, so as to forecast accurately the accident at its extreme earlier period, and to provide appropriate information and decision basis for ground monitoring of coal mine, so ensuring safety in production of coal mine.Integrating data warehouse, OLAP and data mining, this paper first gives relevant conception of data warehouse, joint-computer analysis disposal and data mining, then details the achievement of analysis system of older data based on data warehouse of coal mine.The structure of this system is mainly made up of the following three sections:(1)Change and clean the data input into data base by sensor and set up data warehouse.Use OLAP service device to visit data directly from data warehouse and analyse data in multi-dimensional form by taking various actions such as cutting into slices and blocks or turning, so as to make user observe the data in data warehouse from different angles and aspects, thereby making a through understanding of latent information on data of data warehouse and finding out trend model hidden in the data.Use data mining tool to mine data in data base and data warehouse then draw rules.