The Open Petroleum Engineering Journal

2012, 5 : 124-129
Published online 2012 December 28. DOI: 10.2174/1874834101205010124
Publisher ID: TOPEJ-5-124

Data Warehouse Design and Optimization for Drilling Engineering

Ning Jing , Honghai Fan , Yinghu Zhai and Tianyu Liu
China University of Petroleum, Fuxue Road 18, Changping District, Beijing, China.

ABSTRACT

With the development of petroleum informatization and increase of drilling data, data storage, analysis and integration is attached to the key planning process. Therefore, a solution is needed which combines the data integration, management, analysis and decision support. Data warehouse is one of the hot topics in computer technology application, which has solved the problem of data using after the application of information system. This paper puts forward the data warehouse design proposal in drilling engineering. The data warehouse project with drilling engineering is narrated, such as system structure, the design realization, the data demonstration and security policy. The authors also present a method of drilling data integration based on ontology. The data warehouse system which has the well drilling project specialized domain characteristics is developed by using data warehouse and communication technology. This system can provide effective decision support analysis for decision-makers in different levels and departments.

Keywords:

Drilling Engineering, Data Warehouse, Ontology.