Research And Implementation Of Metadata Management Prototype Tool Based On CWM

By more than ten years' development, remarkable achievements have been acquired in the technology of Data Warehouse, including both its theories and practice. However, most metadata models (or metamodels) on which tools of Data Warehouse coming from different vendors are based are proprietary. If these tools were to be integrated, it would be involved in the complicated mapping between metadata. In order to unify metadata management strategies of the vendors of Data Warehouse, OMG brings forward CWM (Common Warehouse Metamodel).With the comprehensive analysis of the requirement of all current information systems integration and consideration of essential elements of a metadata management strategy and sound research of some metadata management solutions in existence, a warehouse metadata management solution (WMMS) is proposed in this paper. This solution integrates metadata repositories and modeling tool which are based on CWM, and furthermore it ingeniously utilizes various common specifications and services provided by the OMG MDA. Consequently its aim is to effectively manage metadata in local and distributed environment and to support the rapid porting and integration of all kinds of information systems.In this paper, the primary research tasks consist of modeling tool of WMMS and CWM-based metadata repositories and software adapters.First of all, the framework of software adapters of WMMS is put forward and designed. These software adapters understand the common metamodel and the internal implementation metamodel of the product on the other hand. Therefore, they eliminate or significantly reduce the cost and complexities associated with the traditional metadata integration architectures based on metadata bridges.Secondly, a relative "low-cost" metadata store that can be used to store CWM-encoded metadata is designed, and the SQL script is presented to describe the structure of the metadata store. This metadata store, built on top of a commonly available relational database management system (Microsoft SQL Sever RDBMS), still preserves the object-oriented underpinnings of CWM that are essential to successful metadata to interchange within the foundational framework of UML and MOF. The CWM Metastore offers a sufficient level of data management functionality, and provides persistent storage for (as well as allowing for concurrent, transacted access to) the complex metadata found in data warehousing environments.Finally, modeling tool of WMMS is designed and implemented in detail. The consanguineous relationship between CWM and UML , which is intentional to be built by architects of CWM, is taken into account, so the Rational Rose is reconstructed based on REI to support CWM modeling and to be modeling tool of WMMS. The basic function and modules of modeling tool and a series of model-verifying mechanisms aiming at the syntax and semantic of CWM is expatiated. At last, some metadata of enterprises is visibly modeled by taking advantage of the accomplished modeling tool.