Heterogeneous database synchronization method based on security isolation gatekeeper system

Abstract

The invention discloses a heterogeneous database synchronization method based on a security isolation gatekeeper system, and provides a synchronization method for a database table structure and data between any two databases in the security isolation gatekeeper system in a network isolation environment. A non-secret-involved external network database is remotely connected through an ODBC; change data are extracted and uploaded to a server, then field type conversion is conducted through a JSON assembly, then the change data are packaged into a file, the data are sent to an inner end through asecurity isolation gateway isolation network card, the data are converted to SQL statements used by target data through an inner end JSON analysis assembly, and source number synchronization to a target database is completed.

Description

technical field [0001] The present invention relates to the technical field of data processing, in particular to a method for synchronizing heterogeneous databases based on a security isolation gatekeeper system Background technique [0002] With the continuous development of computer technology in recent years, the environment faced by enterprises is becoming more and more complex. Their information systems often use multiple platforms and systems, which requires that enterprise solutions have extensive compatibility and can support different platforms, data formats and multiple connections. Way. In addition, under the background of different business needs, the use and extraction of data, and data replication between non-classified external networks and classified intranets have become more and more frequent. How to realize data replication in this network isolation environment has become increasingly difficult. more and more urgent. [0003] The publish / subscribe model ...

AI Technical Summary

Problems solved by technology

[0003] The publish / subscribe model is adopted in major mainstream database products, and the master-slave replication function realizes data synchronization, but does not provide the heterogeneous database table structure and data synchronization function

In addition, although the existing heterogeneous database synchronization tools on the market can realize the synchronization of the database structure, every time an additional subsystem or external system is added, the tool itself must be modified around the synchronization function. Not only is the workload huge, but the code The maintainability of the

Moreover, these synchronization tools have very little consideration for security, and additional ports need to be opened on the computers participating in the synchronization, which limits their application on the Internet.

Images