油田开发数据仓库的建立  

The Foundation of Oil Field Development Data Warehouse

作　　者：罗广华[1] 熊华平[1] 

机构地区：[1]大庆油田有限责任公司勘探开发研究院,黑龙江大庆163712

出　　处：《大庆石油地质与开发》2002年第2期34-35,38,共3页Petroleum Geology & Oilfield Development in Daqing

基　　金：中国石油天然气股份有限公司"九五"攻关项目

摘　　要：以大庆油田开发数据仓库的建立为实例 ,结合Oracle相关数据仓库开发工具 ,介绍了数据仓库设计的基本思路 ,描述了数据仓库建模、数据的抽取与转换以及数据展示的实现技术。油田开发数据仓库面向油田开发指标分析、剩余油分布与潜力预测两个主题 ,通过采用多维建模技术创建了 4个数据维表、 8个事实表、 7个外部表 ,实现了 10个采油厂的数据加载。油田开发数据仓库的建立 。This paper takes the construction of Daqing Oil Field Development Data Warehouse(DOFDDW) as an example to illustrate the method and procedure of designing the data warehouse, and gives new technique and method for data warehouse modeling and data extract transformations between the source model and target model. The data warehouse is designed for analyzing indexes of oil field development and prediction of distribution of the remaining oil. It includes fact tables, dimension tables and other tables,and most of development data has been loaded into it. Multidimensional statistic and analysis model of DOFDDW are set up in this paper, and which can support data general search, statistics, collect and analysis of DOFDDW on the base of dimension. It provides support for the application system on data information.

关 键 词：油田开发 数据仓库 多维建模 数据展示 建模工具 剩余油 

分 类 号：TE319[石油与天然气工程—油气田开发工程]