Method and device for synchronizing data of I region and IV region of power monitoring system

Abstract

The invention discloses a data synchronization method and device for an I area and an IV area of a power monitoring system, and the method comprises the steps: configuring isolation devices of the I area and the IV area, and opening a data port for the transmission of a data transmission file; obtaining a data file in the I-area database through the I-area shell script file, conducting data processing on the data file, and obtaining a data transmission file, wherein the data file comprises a data change record of the I-area database; transmitting the data transmission file to the IV area through the data port; and reading the data transmission file through the IV region shell script file to obtain a data file, and synchronizing the data file to a database of the IV region. The data file containing the data change record in the I-region database is obtained in real time through the I-region shell script file and transmitted to the IV region through the data ports of the I-region and IV-region isolation devices for data synchronization, so that the real-time requirement problem of data synchronization is solved, the real-time performance of system data synchronization is improved, and the system requirement is met.

Description

technical field [0001] The invention relates to the technical field of power system data transmission, in particular to a method and device for synchronizing data in areas I and IV of a power monitoring system. Background technique [0002] At present, the security protection of the monitoring system follows the provisions of GB / T 36572 "Guidelines for Network Security Protection of Electric Power Monitoring System", and is divided into areas I, II, and IV. Zones I and II adopt firewalls horizontally, and Zones I and IV adopt forward and reverse isolation devices for partitioning. After the isolation of I and IV areas, data synchronization has become an urgent problem to be solved. This paper provides a method for data synchronization of I and IV areas through the isolation device. [0003] The previous solution to the data synchronization of the isolation device was to save the data in the database table to be synchronized as a txt file in the transmission folder of the is...

AI Technical Summary

Problems solved by technology

The above technology has the following disadvantages: First, it only supports relational databases. In the past, the synchronization requirements were aimed at different relational databases. Therefore, the program only reads certain tables in relational databases. In order to solve the sql of different relational databases, Sentence differences, save the data in the database table as txt custom format, and then the receiver program reassembles the sql statement according to the sql format of the database and writes it into the receiver database; the second is that real-time synchronization cannot be achieved, and the new generation of monitoring system Real-time synchronization of data in areas I and IV is required. The previous solution was to write a timing function in the program to read and write once a day, which could not meet the latest real-time data synchronization requirements.

The third is that it cannot be managed. Since reading and writing are directly controlled by the program, the service management cannot be performed through the operating system. If modification is required, code modification is required, which is not conducive to adapting to the modification needs of different scenarios.

Images