基于大数据环境的海洋石油钻完井数据分析系统建构

Construction of offshore oil drilling and completion data analysis system based on big data environment

基于海洋石油钻完井大数据系统,对其数据分析系统进行技术革新优化并构建新式大数据系统。在大数据层次模型的基础上,保持硬件层、解释层架构不变的情况下,通过对数据层和治理层进行优化,使钻完井数据库与钻井平台其他相关数据库之间实现基于API的数据逻辑连接,实现更大范围的数据融合。该模型使用后的上述四大IDC资源需求量显著降低,在使用后数据库规模缩小17.56%的前提下,其查询量提升5.59倍,可用查询规模提升11.67倍,导致数据查询放大比从使用前的2.194提升到使用后的31.063。此时数据的可挖掘价值大幅度提升,未来可以在应用层开发更加丰富的数据应用,以实现钻完井数据的充分利用。

Based on the big data system of offshore oil drilling and completion,the technical innovation and optimization of its data analysis system is carried out and a new big data system is constructed.On the basis of big data hierarchy model and keeping the architecture of hardware layer and interpretation layer unchanged,the data layer and governance layer are optimized to realize data logical connection based on API between drilling and completion database and other related databases of drilling platform,so as to realize data fusion in a wider range.After the model is used,the above four IDC resource requirements are significantly reduced.On the premise of reducing the database size by 17.56%,the query volume is increased by 5.59 times,and the available query scale is increased by 11.67 times,resulting in the data query amplification ratio increased from 2.194 before use to 31.063 after use.At this time,the mining value of the data is greatly improved,and more abundant data applications can be developed in the application layer in the future to realize the full utilization of drilling and completion data.