钻井工程信息化的数据透视技术

在钻井工程信息化中,还没有出现直观的、便于现场使用的数据挖掘或深层数据分析软件,而数据透视技术能够实现快速的交叉汇总,通过一系列简单操作来表达用户的统计需要,形成在各种条件下的数据分析表格。介绍了钻井工程数据的结构特点、多层面的统计需求及数据透视技术的概念。阐述了多维数据透视技术的实现过程。在钻井工程数据处理过程中的应用表明,数据透视技术可为钻井设计和施工提供数据参考,为油田区块的特征分析提供数据支持,为集团公司的决策提供数据依据。

The data pivot-table technology for drilling engineering information

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.