基于多级数据仓库的钻井信息管理与应用系统

APPLICATION OF MULTI-TIER DATA WAREHOUSE IN OIL AND GAS DRILLING IMFORMATION MANAGEMENT

张冰 张宁生 刘茜 刘志宏

Zhang Bing Zhang Ningsheng Liu Xi Liu Zhihong

西安石油大学, 陕西西安 710065 华北石油管理局钻井一公司, 河北廊坊 065007

油气钻井是一项系统工程,其作业点分散、信息量大、数据复杂。运用数据仓库技术对油气钻井信息进行综合管理与应用,可为石油企业决策层提供有效的技术支持。但是数据仓库的建立需要投入大量的人力、财力和时间,在短期内难以满足企业运作时对多层次决策支持的实际需要。因此,在现有数据仓库技术的基础上,采用多级数据仓库的结构模型开发油气钻井信息综合管理与应用系统。介绍了该系统的总体结构模型,并用具体实例说明了多级数据仓库的实现过程和有效性。用多级数据仓库的结构模型设计和实现油气钻井信息管理,不仅提高了系统开发的效率、降低了开发成本,而且还满足了企业生产和经营过程中不同层次的信息处理需要。

Oil and gas drilling is a system engineering cooperating with multidisciplinary professional technologies, and it features dispersed working locations, huge information volume and complex data. Data Warehouse (DW) is a good solution for drilling information management and application, and can provide the decision makers of petroleum enterprises with effective technical support. However, DW construction demands vast capital, human resource and time, while it can’t accomplish information processing of different levels in short-term. Therefore, a model of multi-tier data warehouse is adopted to develop a Drilling Information Comprehensive Management and Application System based on current technology of data warehouse. The structure model of the system is presented in this paper and its validity is proved by using an example. Thus the efficiency of system development is improved and lots of cost and time is saved, and at the same time, the needs of information processing in different levels are also accomplished.

10.3969/j.issn.1000-7393.2004.04.003