The Design And Application Of ETL Process Based On CWM

Data Information is one of the most important resources for enterprises. It's the basis of scientific management and making right decisions.The traditional information system for transaction processing can only contribute to producing data information,but not to analyzing them.Data warehouse system is developed from the traditional information system,aiming at helping users to make the best use of the data information for making decisions.Among several components of the DW,the performance of ETL is the key factor of the successfully implementing the DW system.Developing ETL system is also the most time-consuming and work consuming part of the whole development of the DW.However, there are some problems at the process of developing ETL system.One of the most typical problems is the confusing management of metadata.As for this problem, we propose a new idea for developing ETL system basing the ETL's development on the CWM (common warehouse metamodel).Firstly,we analyze the function of metadata in the DW system,especially in the ETL process,and confirm the commander's rote of metadata in the ETL.Secondly,we talk about the contents of CWM and the abroad support of CWM for ETL.Then,we propose our idea of designing the ETL process to design the ETL process on the basis of the CWM.Further more,we give the design of other pats of the ETL system.At last,we talk about the realization of ETL system and the application of ETL in the Commercial Bank Risk and Monitor System.