| The subsidence area of coal mine is the area covered by the overlying rock mass caused by coal mining.With the change of time,the range of the region is changed with the initial mining area,and the area is smaller.With the expanding of the mining area,the scope of the subsidence area is expanding,and the surrounding environment is affected.Our country from the beginning of the last century,a lot of risk monitoring the mining subsidence areas,the accumulation of a large number of valuable data,in-depth excavation of these large,complex data hidden behind the value of information,analysis and summary of their depression area,space and time evolution,and the technology of scientific management and Research on their depression area,the application of modern computer with reality is of great significance to guide the construction of mines.Taking the settlement of the risk as the research object,based on Oracle database technology platform,through the analysis of the adventure zone four-dimensional data definition,data characteristics,study the 4D geological body(spatial and temporal)information storage method,combined with ArcGIS visualization technology,to take in four dimensional storage area for data visualization,coal mining area mining subsidence and geological disasters early warning,to provide data support to promote the sustainable development of coal enterprises.The research work done in this paper is as follows:1 combined with the domestic and foreign related references,the research status of spatial data storage,spatial moving object model and mine information storage are summarized.2 defines the concept and scope of their depression,to explore his spatio-temporal semantics subsidence of four-dimensional data,based on Oracle,discusses the data storage model,and the GIS and the database structure system is studied.3 the data characteristics of the different evolution stages of the caving area are analyzed,and the characteristics of the mining information storage model aresummarized.The dimensionality reduction principle,will take in space information using hierarchical block processing,select the appropriate storage size,independent data table to store the establishment of attribute information,to take the subsidence time dimension data and spatial information related to time associated with the reduction of dimensionality,and the data is stored separately time-varying characteristics do not have the spatial data and the attribute data,reduced data redundancy,finally through the spatial and attribute data to establish the related index of real-time query specific time.4 combined with the engineering example,based on Oracle database platform,will take the subsidence of four-dimensional data storage information into ArcGIS software,using ArcGIS visualization technology,the data visualization at different time points,get to take the dynamic change of strata subsidence,subsidence of four-dimensional data visualization implementation risk. |