石油钻井信息系统中多维分析的设计

DESIGNING MULTI-DIMENSIONAL ANALYSIS IN OIL WELLS INFORMATION SYSTEM

近年来,石油资源开发的技术难度、投资额度和风险程度日益增高。如何正确地处理和有效使用石油钻井数据,快速生成针对不同石油钻井分析需求主题的信息,已经成为棘手的问题。结合川东钻探公司的实际情况,提出了基于关系数据库的数据仓库和多维分析模型。模型以石油钻井分析需求为导向,从数据仓库的结构、数据组织及多维分析的基本概念和分析动作等方面着手,创建了适用于川东钻探公司的石油钻井生产信息多维分析系统,实现了正确地处理和有效地使用历史数据,快速地生成了针对不同石油钻井需求主题的信息,为用户提供多角度、快速、直观的视图及预测,为企业经营者及时发现生产中的问题,调整组织新的生产措施,提供了辅助决策依据。

Technical difficulty,investment amount and risk level on development of oil and gas resources are increasing in recent years. How to deal with and utilise the oil wells information correctly and effectively,and how to rapidly generate the information aiming at different demand themes on oil wells analysis have become the knotty issue.Based on actual situation at Eastern Sichuan Drilling Company,this paper presents the data warehouse of oil wells based on relational database and the multi-dimensional analysis model.Taking the demand of oil well analysis as the guide,and commencing from the aspects of the structure of data warehouse,data organisation and the basic concept of multi-dimensional analysis as well as the action of analysis,the model created the multi-dimensional analysis system for oil well production information suitable for the Company,realised the correct processing and effective use of historical data,and quickly generated the information for different oil wells demand themes.It provides multi-perspective,fast and intuitive view and predictions,and helps the businessmen to timely discover the problems in production,to adjust and organise new production countermeasures by providing assistant decision basis.