Research On Metadata Management And Application In BI System

Business intelligence (BI) technologies in witch data warehouse as the core have become an increasing attention to the industry, many BI system has been put into use, has brought huge benefits. However, because major developers using different data warehouse metadata standards and management strategy, making data storage between the data integration and sharing is very difficult, which triggered the people of meta-data management and application of research. With the data warehouse data quality issues more attention, more so that people realize that the meta-data management and application of importance. The issue in China Pacific Insurance Company (CPIC) building enterprise data warehouse (EDW) project against the background of the BI system in the meta-data management and application of research.Metadata management is not a purely technical problem, because many of metadata management content to rely on management systems, processes, and other artificial aids to complete participation. Meta-data management technology and metadata management strategies are successful integration of meta-data will need to focus on the content of the study. The research of the BI system of meta-data management technology and metadata management strategy, through the CPIC building EDW second phase of the project in the use of file servers to achieve metadata management manual, part of the practice of meta-data management technology and metadata management strategy .Meta-data users, including technology users and business users. Metadata through the application of BI systems from design and development to operation and maintenance of the entire life cycle, this issue from business users and technical users point of view to study in the BI system development and operation and maintenance in the course of several important scenes of the metadata. And through the development of a simple metadata-driven data mapping tool for understanding metadata for data integration tools of the importance of the development.As BI system involving a large number of business systems integration, we need a unified metadata standards to support various subsystems to achieve the effective integration of metadata. Public warehouse model (CWM) is the object management organizations (OMG) by a common data warehouse metadata standard, has been the major tool manufacturers for their support. This issue also focus on the architecture of CWM norms and standards based on a preliminary CWM meta data warehousing application development.This Paper first describe theoretical research of meta-data management and application, and project-based process of the application of practice on the three main components: The first part of the meta-data management and application of theoretical research. First introduced the basic concepts of metadata, on the BI system Metadata management strategy and the main content of the major meta-data management technology, focused on standardizing the basic contents of CWM and then from business users and technical users were on the point of view BI in the system development and operation and maintenance in the course of several important scenes of the meta-data, focusing on the application of metadata to solve the problem of data warehouse data quality, data integration and Assencial solution as an example of the metadata-driven data integration solution Programme.The second part of the meta-data management and application process from the planning and implementation aspects of the practice. First on the CPIC construction projects to MetaStage EDW as a meta-data management tools to establish federal system of metadata metadata planning, some of the previous practice of meta-data management strategy and meta-data management technology and then build on the CPIC EDW Project Second phase of the document servers using metadata management of the implementation of the manual. The third part of the meta-data management and application software design and development aspects of the practice. First of all accounts a simple metadata-driven data mapping tool for the development process, to illustrate the metadata for data integration tools developed important part, and then introduced the CWM standard architecture, and based on a preliminary CWM standard metadata Warehousing application development;...