Design And Implementation Of Unified Data Interchange Platform Based On ETL

In the information development of CCB, the increment of OLTP systems, the standard for the general design requirement of DW becomes higher and higher. The common model of DW can't meet the demands any more. Therefore the design and implementation of UDI is proposed.The main research of the thesis is the implementation of batch data interchange function based on ETL (extraction, transform and load). UDI has two main characteristics. First, by the separation of source systems and target systems, the platform provides data exchange among the systems to avoid point to point communication. Second, the data process of source systems is consolidated by platform based on the systems' common requirements. The data extraction is implementated from the simple data exchange to the more complicated view of business logic.First the background of the development of DW and occurrence of UDI are described in this thesis. Then the positioning, objective and design principle are discussed. And the general design of the system through the component of component diagram, activity diagram and deployment diagram is discussed also. The requirements of associated external system of UDI based on the nature of this system and their relationship with UDI are described Last the design and implementation of each functions of UDI is explained. In the design, I emphasize the implementation of new DW model. And I establish the control and specification of data process flow in the internal of UDI. The preconcerted target is attained...