The application of spatial data warehouse technology in the National Petroleum Resources Database
Ying Li, Yang Wang, Chen Ya-fu, Feng Li-zhou · 2010
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.