Design And Implementation Of CNOOC Data Warehouse ETL Tool

The development of computer and the network technology made the enterprise to accumulate the massive data resources under each kind of application system, they constituted enterprise’s precious wealth. Today, more and more enterprises are constructing the Data Warehouse to meet its strategic decision needs, and must integration the data possibly be come different software and hardware platform, data model and even in the geography distributes, in the management autonomous and in the pattern the isomerism data source. Therefore, provides one kind of ETL tool is the extremely beneficial work, Using the ETL tool extract data from isomerism data source service and transformation, loads it to the warehouse, its main effect is cleaning, standardization and compiles each kind of service data, provided the high grade data for data warehouse.This thesis analyzed the domestic and foreign ETL tool research situation, also analyzed the present mainstream ETL tool structure, the characteristic, data conversion, data cleaning and the metadata. Base on CNOOC Data Warehouse System, proposed one kind of more general ETL tool frame design model and realize this ETL system.In the realization aspect, utilized the inherit and polymorphism characteristics of object-oriented language, utilized design pattern, made the ETL tool construction clear, well extension and flexibility.