Research On Enterprise Metadata Integration Based On CWM

With the increasing demands of information technologies in daily work, more and more enterprises construct their own information systems in recent years. However, because different business entities have different operation models and organization structures, a large amount of heterogeneous data sources are formed, which are commonly called"Information island". The interconnections between enterprises require solving the problems of data exchange, data integration and departmental cooperation. Therefore how to effectively solve the problem of data integration under heterogeneous data environment has significant practical meaning.Recently, the widely application of metadata has brought new power to data integration. The metadata integration is effective path of data integration. CWM is a common standard for metadata which is proposed by OMG. We develop a metadata integration management system called as WMMS, which base on CWM specification. In WMMS, the exchanging metadata is base on CWM, so manufacture's metadata must be transformed into CWM metadata by software adapter in order to interact.Aiming at the problems mentioned above, the thesis presents the conception of enterprise metadata integration based on the overview of development, and then addressed the importance of metadata integration. Then we present several solutions of metadata integration , research the policy of metadata management and introduce a CWM-based metadata integration system.Meta-store, the central component of WMMS, is a cheap solution to store CWM metadata. This paper designs the meta-store. Meta-store is based on relational database. By the way of mapping from the objective concepts to relational table, the metadata stored in meta-store is accord with CWM specification.The design of software adapter is emphases of this paper. The adapter is aim at RDBMS. The function of the adapter is transforming RDBMS metadata into CWM metadata. RDBMS metadata is extracted by extractive tool , and the transformed metadata is stored in meta-store. The paper provides a detailed design of the adapter, and implemented by the example of Oracle.