摘要
在钻井工程信息化中,还没有出现直观的、便于现场使用的数据挖掘或深层数据分析软件,而数据透视技术能够实现快速的交叉汇总,通过一系列简单操作来表达用户的统计需要,形成在各种条件下的数据分析表格。介绍了钻井工程数据的结构特点、多层面的统计需求及数据透视技术的概念。阐述了多维数据透视技术的实现过程。在钻井工程数据处理过程中的应用表明,数据透视技术可为钻井设计和施工提供数据参考,为油田区块的特征分析提供数据支持,为集团公司的决策提供数据依据。
So far there has not appeared the data mining or deep-level data analysis software which is straightforward and convenient for the on-the-spot application in the information of drilling engineering.But the data pivot-table technology can achieve the quick alternate summary of data,express the user's statistic needs through a series of simple operations and form the tables of data analysis under different conditions.The structural features of drilling engineering data,multi-level statistic requirements and the concept of the data pivot-table technology were introduced in this paper.The achievement process of the multi-dimensional data pivot-table technology was expounded.The application in processing drilling engineering data indicates that the data pivot-table technology can provide data reference for drilling design and operation,provide data support for the characteristic analysis of oilfield blocks and provide data basis for corporations' decision-making.
出处
《石油机械》
北大核心
2010年第12期38-41,95-96,共4页
China Petroleum Machinery
基金
国家科技重大专项“大型油气田及煤层气开发”之课题21-6“钻井工程设计和工艺软件”(2008ZX05021-006)
关键词
钻井工程
信息化
数据透视技术
钻井数据库
数据挖掘
drilling engineering,information,data pivot-table technology,drilling database,data mining
