Research On Data Warehouse And Visualization Analysis Of Mine Geological Drilling

With the rapid development of computer network technology and time, the continuousmining enterprises data show the timeliness and spatiality, mass and multidimensional nature,large difference of different data sources and formats is becoming more and more obvious. So itis necessary to organization and integration management of these data, mining useful information,and lay a foundation for building digital mine.The data warehouse technology application in mine industry, is a new dynamic in recentyears. This paper in the data warehouse technology to build digital mines, on the basis of thesignificance of this paper expounds the connotation and characteristics of mine data warehouse,puts forward for digital mine framework of data warehouse and the multidimensional data model.Geological information database is roadway model design, solid model building, the foundationof the block model building and calculation of reserves, directly affect the whole mine miningdesign, production, production and business operation and decision-making information. In thispaper, a geological information data mining enterprises as the background, discusses thegeological drilling information as the theme of the construction of the data warehouse.Combining OWB (Oracle Warehouse Builder), Visual Studio, and mining software SURPAC,realized the establishment of geological data Warehouse and the mine3d visualization ofinformation. The main research contents are as follows:First of all, the paper analyzes the various heterogeneous data sources of the mine,combining with the characteristics of SURPAC software at the same time, in order to kinds ofdrilling information integration of heterogeneous data sources together, study of mine geologicalborehole data warehouse model and design. Put forward the demand analysis of mine geologydrilling information data warehouse, to the mine geological drilling information data as the theme,implements the mine geological borehole data warehouse concept model, logic model andphysical model design.Secondly, to realize mine geological borehole data warehouse based on the OWB. For themining enterprises EXCEL document data, through the programming language design hasrealized the EXCEL document data source data extraction module. Based on OWB defines thesource and target module, created the tables, dimensions, cubic and mapping, and finally bydeploying table and map, a successful implementation in the construction of mine geologicalborehole data warehouse. Finally, based on the geological data warehouse and drilling SURPAC software, to realizethe3d visualization of mine information. Implements the mine xi’ao concave geological anddrilling data of180segments information state of three-dimensional spatial distribution, ore bodymodel, grade model is constructed, and the statistics and analysis of the basic geological reservesestimation is analyzed.Research shows that by using data warehouse technology and mining software SURPAC,can effectively solve the problem of the organization and management of the mining enterpriseheterogeneous data, at the same time can be stored data visualization analysis research, and theestablished model is reliable, can be used for the mining design, promote the work of digitalmine.