The application of spatial data warehouse technology in the National Petroleum Resources Database

This paper uses the data warehouse technology to do spatial data warehouse modeling and development for the National Petroleum Resources Database, complete multi-dimensional data storage and integrated cluster processing with Cube, achieve information extraction and decision-making advice with the multidimensional analysis and OLAP analysis tools. Through elaborating and analyzing the key problems such as the meta-data design, ETL processes and coding standards, Made use of data warehouse technology to solve massive, heterogeneous, time-varying effective means of data-processing problems, put forward the effective ways to solve massive, heterogeneous, time-varying by use of data warehouse technology, build the comprehensive utilization of petroleum resources information management platform.