Design of ETL System for Cementing Data Warehouse

In recent years,with computer technology and advances in database technology,cementing the industry large amounts of data distributed and heterogeneous storage is gaining momentum.Effective way to integrate the use of data to guide decision-making has become a concern to policy makers..ETL system for data integration provides a satisfying solution.It can complete many tasks,such as data extraction,cleaning,transforming and loading etc,meet the needs of heterogeneous data source integration and also realize to update data.The article designs ETL system for drilling data warehouse which is based on a metadata ETL architecture,and focus on metadata management module and heterogeneous data conversion module.