A Study On Multidimensional Analysis System Of Oil And Gas Production Report

Exploration and Production Company(E&P)is one of the professional corporations of PetroChina,which is mainly responsible for the exploration,development and production of oil and gas.In the process of oil and gas production,a large number of oil and gas production data accumulated.How to analyze the data better and mine information hidden in the data,is one of most import information work in Exploration and Production Company.Based on the business requirements of PetroChina Exploration and Production,this thesis studies and implements an multidimensional analysis system of oil and gas production report,which is to support the production management and analysis decision of PetroChina Exploration & Production Company.Firstly,this thesis researches the related data warehouse and data mining technologies,and then uses UML unified modeling language to implement the system needs analysis,summary design,detailed design.Secondly use the data warehouse modeling method to achieve the construction of oil and gas production report data warehouse,that is by data ETL process on SQL Server SSIS component platform.The data source is oil and gas production data which is related to the oil and gas production report.Thirdly the OLAP analysis method is used to realize the multidimensional analysis of the data,which includes Slice,Dice,and so on.Finally,it creates data mining model,and displays the data mining results on different data mining algorithms in the Excel.Based on the above study,the user can quickly and easily query and analyze the oil and gas production report data,which has satisfied with the business requirement for oil and gas production report,and enhanced the analysis ability of oil and gas production report data,and provided support for the decision makers.