Underground Mine Multi-source Heterogeneous Temporal Data Model

Currently, most of mine information system can only statically display stratum structure and Mineral Engineering, deposit distribution, mine laying situation. This approach can only reflect the time information in the underground mining process.However, with the exploration or exploitation of the production demand increasingly sophisticated, accurate, flexible. Time element in such systems has become increasingly important.Join in temporal information can develop long-term production plans for the system, to reproduce the production process of mining and mine safety monitoring and management of data and provide important reference. Usually,it’s necessary to consider the state of an object in space over a period of time changes, also need consider the exploration or exploitation of the production process in real-time information processing timely. This requires temporal data model to strengthen the research and application of this technology to the underground mine, namely the establishment of underground mines temporal data model. This requires strengthening the research of spatio-temporal data model. And applying this technology in the underground mine which is the establishment of underground mines temporal data model.This thesis studied and proposed spatio-temporal data model for underground mines multi-source heterogeneous data. First, combined in reading the literature and field research, sorting and analysis the underground ore production process in-depth. Including underground mines, mining production workflow analysis and object data analysis features. On the basis of data analysis, underground mine multi-source heterogeneous data classification, including data orebody, shaft engineering data, and module division to rationalize its data storage structure. Second, each base state with amendments model based on in-depth analysis and comparison, then proposed underground mine complex data base state with amendments model. The model history and cached data type is the same but with different storage methods. This method greatly reduces memory usage and improves query speed temporal data. Finally, analysis the underground mine multi-source heterogeneous temporal database. Introduced and designed the conceptual model, logical and physical models, build underground mine temporal database. And provide a unified storage methods for store multiple heterogeneous data sources.This paper use oracle spatial temporal data to store and provide spatiotemporal query, by validation and comparison, this design meets the requirements of unified data storage and data query efficiency is significantly improved. It provides the basis for dynamic display of temporal data.