Multisource data real-time database data generation method applicable to scheduling and transformer substation integrated system

Abstract

The invention discloses a multisource data real-time database data generation method applicable to a scheduling and transformer substation integrated system. The method comprises the following steps of 1) starting a real-time database generation process, and reading configuration information; 2) determining data sources according to the configuration information, and respectively extracting structural information (such as tables, fields and indexes), model data information and real-time data information which are needed for generating a real-time database; 3) performing integrality and consistence verification on the extracted tables, fields, index structures, model data and real-time data; 4) calling a real-time database generate interface to generate a real-time database according to the verified structure information, model data and real-time data. By virtue of the method, the structure information, the model data and the real-time data which are needed for generating the real-time database can be acquired from multiple data sources such as a relational database, other homomorphic real-time databases and documents, so that data generation of the real-time database is realized, the method is reliable and efficient, is convenient to expand, and can meet application demands in different scenes.

Description

technical field [0001] The invention relates to a method for generating multi-source data real-time database data, in particular to a multi-source data real-time database data generation method suitable for dispatching and substation integration systems, and belongs to the field of real-time database technology application. Background technique [0002] Real-time database data generation refers to extracting the data structure and related data required to generate a real-time database to the local system, generating real-time database entities, and mapping them into memory. In the integrated system of dispatching and substation, there are both main station system and substation system, the system environment is complex, and the monitoring objects and collected data are varied and in different forms. The operating environment, network bandwidth, and device performance of each subsystem are also very different. The traditional real-time library generation method based on the r...

AI Technical Summary

Problems solved by technology

The operating environment, network bandwidth, and device performance of each subsystem are also very different. The traditional real-time library generation method based on the relational library occupies a lot of resources and takes a long time. It has high requirements on machine performance and network environment. Runs inefficiently on narrower, less hardware-configured systems

Images