Metadata management system with bidirectional interactive characteristics and implementation method thereof

Abstract

The invention discloses a metadata management system with bidirectional interactive characteristics and an implementation method thereof. A metadata data extraction device extracts the metadata of all subsystems of an EDW to a metadata runtime library device, and a universal relational metadata model stores the metadata; a conventional bridge extracts the metadata of the relational metadata model to a metadata knowledge base device of an object metadata model to form analysis results for inquiry by a user; a database view supplies the needed metadata information to other subsystems. The invention uses a bidirectional metadata management system framework, can support the metadata extracted from other subsystems of the EDW to be stored into the metadata management system, and meanwhile, supports providing the needed metadata information to other subsystems of the EDW, solves the running management problem of the metadata and the EDW, reduces the management difficulty of the EDW, guarantees the accuracy of the metadata and causes the subsystems to efficiently communicate and stably run.

Description

technical field [0001] The invention relates to the technical field of metadata management, in particular to a metadata management system with two-way interactive features and an implementation method thereof. Background technique [0002] The establishment of a metadata management system has become an indispensable part of the construction of an enterprise-level data warehouse (hereinafter referred to as EDW) in the current industry. The metadata management system must become a unified knowledge base that concentrates all the management and operation information of EDW, so as to provide enough information for the development, operation and management of huge EDW, improve the production efficiency of EDW, and ensure the stable operation of EDW. Therefore, it is required that the information in the metadata database of the metadata management system must be integrated, accurate and historical. However, for the current EDWs with metadata management systems, there is a big arc...

AI Technical Summary

Problems solved by technology

[0004] 1) The metadata database of the metadata management system has gradually evolved into a metadata query tool, which cannot play the role of master control as the core knowledge base of the data warehouse;

[0005] 2) Metadata information will not flow from the access interface to other subsystems, so the timely update of metadata cannot be promoted, and it is difficult to fundamentally ensure the accuracy of metadata;

[0006] 3) The metadata database of the metadata management system does not provide the required information at runtime, and each subsystem needs to maintain its own set of metadata to support its own operation, resulting in redundancy of metadata;

[0007] 4) The metadata database of the metadata management system cannot guarantee the accuracy of its content, so it cannot become the core component of the EDW runtime, resulting in the need for direct information interaction between related systems, which greatly increases the communication between subsystems cost, difficult to manage

Images