Method for synchronizing data between gatekeeper isolated databases

Abstract

The invention discloses a method for synchronizing data between gatekeeper isolated databases, which comprises the following steps that: enabling the databases to monitor the data change of a data table and record the data change into a monitoring intermediate table or a data export table; based on the job scheduling and storage process, analyzing the data of the monitoring intermediate table into SQL statements, synchronizing the SQL statements into a data export table, and converting the data in the data export table into a first export file; storing the first export file to another system through isolated data exchange; and enabling the other system to convert the first exported file into an SQL statement based on job scheduling or manual operation, import the SQL statement and record import information, so that data synchronization is realized. According to the method for synchronizing the data between the gatekeeper isolated databases, the safety and reliability of the data are guaranteed, the method is adaptive to the relational databases in the market, import and export information is tracked, abnormal import is modified and executed again, and data deadlock caused by import of a large number of problematic SQL is avoided.

Description

technical field [0001] The invention relates to the field of databases, in particular to a method for synchronizing data between databases isolated by network gatekeepers. Background technique [0002] For product manufacturers that use key technologies, since the production data in the production process involves high-level commercial secrets or even state secrets, the intelligent manufacturing system is generally split into two independent systems, the private network and the industrial control network, through the network gateway. dimension. Among them, the private network manufacturing system is mainly responsible for the entry of confidential personnel information, secret-related production basic data and other secret-related workshop production data; the industrial control network manufacturing system is mainly responsible for the entry of official product production line production data and the internal business process flow data of the industrial control network ent...

AI Technical Summary

Problems solved by technology

[0004] Using EXCEL data import, there are many interrelated business data in the manufacturing system, and the data synchronization directly through EXCEL has low fault tolerance, and it is easy to fail to realize business flow in the intelligent manufacturing system due to incomplete data import related to business documents.

Moreover, the import of EXCEL requires a large number of EXCEL export templates, and the export volume of EXCEL for large databases is large. At the same time, when importing, database deadlocks are likely to occur, which will lead to problems such as reduced efficiency of the intelligent manufacturing system.

[0005] Database import, there are many database products on the market. Two intelligent manufacturing systems isolated from each other by the same manufacturer through a network gateway may use different database management systems. Database import needs to convert the exported database files according to different databases, and the conversion operation is troublesome. and prone to data loss

There are also independent business processes in different intelligent manufacturing systems isolated by the gatekeeper. If you directly use the database to import, it is easy to overwrite the data generated by the respective business processes of the manufacturing system and cause data loss.

Images