The Research Of Mine Workers Positioning System Based On Spatial Data Warehouse Technology

Coal mine safety system is an important guarantee of enterprise's safety production. Personnel positioning system is an important component in the system of coal mine safety part.The article will present a more advanced technology-Spatial Data Warehouse technology and apply to the mine personnel location systems. Faced with some technology special difficulties, especially in spatial data extraction, transformation, loading process in the presence of multi-source spatial heterogeneity, as well as online analytical processing stage in the analysis time is too long so there is problem, a detailed study. In summing up and learn from existing spatial data extraction, transformation, and loading the research basis, we propose a new method: use of space technology to assist in solving the metadata of spatial data extraction, transformation, loading face in the process complex and diverse problems. Subsequently, the paper also for building OLAP cube technology, spatial data cube and the selectivity of traditional data cube materialization technology to do a thorough research, and propose a cube-based encoding method for constructing a suitable summary of the data cube data structure, so as to achieve speed up the response to online analytical processing stage to reduce the time-line analysis of the purpose.Spatial data warehouse by two key technologies for mine personnel and Location System and the application of the theory laid the basis for the full, although the technology aspects of information technology in coal mining enterprises, involved only a small step, but for a wide range of spatial data warehouse technology provides a new route, and the work of coal mining enterprise managers provide a convenient, but also information management of mine safety has great practicality.