基于众包的钻井物料数据仓库ETL系统研究

Research on crowdsourcing based drilling material DW ETL process system

随着商业智能的发展,现代化石油钻井企业开始越来越重视数据的作用,如何将企业多年信息化建设的成果更有效地利用起来成为当前企业信息化建设的一个重要内容。数据仓库建设的过程中最重要的过程就是ETL过程。ETL过程经常需要耗费大量的人力、物力、财力。但是效率依然十分低下,为了解决这个问题,本文提出采用网络众包的方法将传统数据仓库ETL过程与众包的方式结合,构建基于众包的钻井物料数据仓库ETL系统,有效提高石油企业数据仓库建设的效率。

With the development of business intelligence,modern oil drilling companies have begun to pay more and more attention to the role of data. How to make effective use of the results of many years of enterprise information construction has become an important part of current enterprise information construction. More and more data warehouses have been established. The most important design in the data warehouse construction is the ETL process. The ETL process often requires a lot of manpower,material and financial resources. However,the efficiency is still very low. In order to solve this problem,this paper proposes a method of using network crowdsourcing,which is combined with the traditional data warehouse ETL process,and builds a crowdsourced drilling material data warehouse ETL system to effectively improve the data warehouse of oil companies.