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

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

Application of Multi - Tier Data Warehouse in Oil and Gas Drilling Information Management

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.