Method for managing metadata of virtual data warehouse of electric power information system group

Abstract

The invention discloses a method for managing metadata of a virtual data warehouse of an electric power information system group. The method comprises the following steps of: a) managing an object data service of a public electric power information system, and managing the public data service attribute provided by a public object for query; b) managing the mapping relationship between a public data service and a private multi-dimension data service of each heterogeneous database, wherein the established mapping relationship of the public data service and the private multi-dimension data service of each heterogeneous database is finished through the incidence relation from the public data service attribute to each heterogeneous source table column; and c) managing a public data service interface and a maintenance interface, and managing a set of open standard interface (API) function library for providing external data services. The public data service interface comprises a unified retrieve definition interface and a unified data query service interface. By using the method, private data services provided by each power information system are integrated, and the public data services provided for a third party are summarized. The method can be conveniently applied to integration work of the electric power information group.

Description

technical field [0001] The present invention relates to database integration technology for electric power information systems, and particularly relates to a metadata management method for constructing a virtual data warehouse in a power information system group. The virtual data warehouse metadata management system constructed by this method integrates each electric power information system The private data services provided are integrated and summarized into public data services open to third parties, so as to provide a unified public data service platform for power companies. Background technique [0002] The information system of the new generation of power enterprises needs to consider the requirements of safe operation and commercial operation in the power market environment. The basis of its application is to construct a public data platform, which integrates real-time dispatching system, electric energy metering system, relay protection, safety automatic device and i...

AI Technical Summary

Problems solved by technology

[0009] The object of the present invention is: in order to solve the problem that the existing models, services and data interfaces cannot be summarized and unified when multiple databases are integrated in the existing electric power information system group, a metadata for constructing a virtual data warehouse in the electric power information system group is proposed The management method uses the metadata management system of the virtual warehouse to centrally manage the models, services and data interfaces of each power information system, and summarizes a set of public models, services and data interfaces that can be opened to third parties to solve the problem of power consumption. Integrated Management of Multidimensional Data in Information System Group

Images