Design And Implement The ETL System Oriented Data Warehouse And Data Integration

As information technology developed, the information asset contributed more and more power to the core competition ability of the modern enterprises. Accordingly, it became more and more important for the CIOs to efficiently deal with data which was generated from the daily operating -- in order to support their employers in the decision-making process. Since Doctor E.F.Codd put forward "relational database" model in the year 1970, RD has become a main stream in the data management area. However, this quick-responding business management system has an inherent flow when they facing the thematic-driven data analysis application. Therefore, it would benefit the enterprise's information management by constructing an operational data store (ODS) upon the existing relational database, which could also become a significant technology instrument in the decision-making-supporting process.This thesis bases on the CCB ODS project which I took part in recently. Started with the instruction to ODS concept and actualizing technology, and deeply discussed the realizing mechanism of the key steps of ETL technology (extracting-transforming-loading). The article in particular introduced the ETL construction and application disposing scheme of CCB ODS system. Further more, as an important part of my job, I emphasized how to transfer data from the existing business platform to the ODS system. That is, using ETL technology to transfer the data from each branch banks in Shandong Province, into the new CCB ODS system, such as the middle-business data, IC card system data, medical insurance system data and accumulation fund data.The research made good attempt on how to build an ODS system upon the existing business system, and successfully solved the data conformation problem between management database and business database, which made it possible to achieve the over-region data integration. In that way, we can ensure the data's time efficiency and veracity, practise the consolidated operation mode, and serve the decision-making process better than ever.