The Core Library Research Of Oil And Gas Recourse Based On Data Warehouse

In order to meet the needs of oil and gas resources further informationintegration and comprehensive application, The study proposed to establish a corelibrary based on the national petroleum resources database, extract the valuable datafrom the special subject of oil and gas resources in the database, help withthe statistics, analysis and data mining. The study according to the aboverequirements, based on the data warehouse technology, design and build the corelibrary resources of oil and gas, and manage the data warehouse withmultidimensional data analysis, extract the hidden information from data.This paper studies the characteristics, advantages and system structure of datawarehouse, in view of the current situation of oil and gas resource database,carries onthe analysis of demand, design the system structure of the core database of oil and gasresources. In the ETL process, the questions to be solved in the data extraction,conversion and loading process, finally use the SQL Server SSIS package designand achieve the deployment of ETL process; Building the model of data warehouse bythe multidimensional data model, using the SQL Server SSAS to realize the designand deployment of multidimensional data; with the help of OLAP, realizemultidimensional analysis operations on oil and gas resources cube query, multi angleanalysis of data, including drilling, slicing,data rotation, MDX script languagequery, finally illustrates the analysis results of oil and gas resources in the cube.Based on the above studies, meet the requirements for analysis andquery demand of oil-gas resources, realize query from the multiple perspectives ofthe data,achieve the implied valuable information, help the users with analysis andapplication.