摘要:Drilling material data warehouse is an important platform for assisting drilling engineering decision support and data analysis. The construction of high-efficiency and high-quality enterprise-level data warehouse puts high requirements on data quality. The operation targets of oil and gas drilling engineering are buried underground, and there are difficulties in data obtaining. This causes many uncertain data in the oil and gas drilling business database. At the same time, the business database in one area is quite different from those of other areas due to geographical environmental impacts ,so the database selection and integration strategy is uncertain . In order to solve these uncertain problem, this paper proposes building a drilling materials data warehouse ETL system based on crowd-sourcing, and improve the data quality of the data warehouse, thereby improving the efficiency of data warehouse construction.