Research And Implementation Of Commercial Bank Metadata Warehouse Based On CWM

Data Warehouse (DW) is the new information management technology evolved from database. It is prevailing in Enterprise Information Integration, Data Mining and Enterprise Decision Making and so on. The metadata standard of software development tools that are used for building the DW is different among these tools. Therefore the tools aren't able to collaborate with each other effectively. They have to be involved in the complicated mapping between metadata. In order to unify metadata management strategies of the vendors of DW and smooth metadata interchange, Object Management Organization (OMG) brought forward the Common Warehouse Metamodel (CWM) based the specification of UML, MOF and XMI.Firstly this dissertation in a systematic way presents an introduction of the structure of CWM. The packages and the associations among packages are analyzed in detail. With the comprehensive analysis of the requirement of almost all the information system and the study of metadata solutions in history, a Metadata Warehouse strategy based on CWM is adopted.Secondly, a CWM based Metadata Warehouse (MDW) is designed and implemented on the viewpoint of the whole life-cycle of metadata. MDW constitutes of six components, namely source layer, integration layer, repository, marts, management layer and delivery layer. This dissertation details the design and implementation of such six components especially for the metadata repository. Metadata repository is the core component of MDW and built on the basis of three-tier architecture consisting of M1, M2 and M3. Such three-tier architecture has both a high expansibility and adaptability. It is in leading place at home in the field of study and implementation of Metadata and can be mentioned with the big tools of Metadata outside China in the future.Finally, how to design the meta-model and manage the metadata of the four domains of data dictionary, data transformation, data quality and business application based on CWM is described. The status and insufficient is also indicated in this dissertation.The commercial bank the author working for is focusing on three-tier DB/ODS/DW architecture. It is different from the traditional two-tier DB/DW architecture. The author hopes to seek the solutions beyond DW. This research and implementation make the Metadata stride forward one step greatly.