面向钻井工程的数据仓库解决方案研究

随着钻井工程信息数据的海量增加，各级部门都建立了钻井数据库。由于各个部门和系统在业务与数据关联上缺少总体规划和设计协调，这些数据库从某种程度上形成了一个个的“信息孤岛”，所以迫切需要一种集数据集成、管理、分析、辅助决策为一体的数据仓库解决方案，为数据的共享和综合性研究应用提供支持。文章通过对钻井工程数据的分析和信息技术的调研，提出了面向钻井工程的数据仓库解决方案，即一种基于本体论的钻井数据集成方法，在一定程度上解决了钻井数据多源异构的问题。钻井数据仓库的研究和开发，为不同层次和部门的工程管理及技术人员的决策分析提供了强大的数据库支撑，为实现信息化、科学化决策打下了基础。

Research on Data Warehouse Solutions for Drilling Engineering

With the increase of data information in drilling engineering, departments of all levels have built own drilling databases. Nevertheless, the databases from various departments become isolated information islands, as the lack of overall plan and design coordination in the operation and data association,. Therefore, a solution must be put forward which combines the data integration, management, analysis and decision support. This plan can provide technical support for data-sharing and comprehensive application and research. Through analysis of data in drilling engineering and study of information technology, the authors put forward a data warehouse solution for drilling engineering. Also this paper develops a method of drilling data integration based on ontology, which solves the problem of heterogeneous data to some extent. The research and development of drilling data warehouse provide powerful database support for decision-makers in different levels and departments, which lay foundations of informational and scientific decision.