Heterogeneous database synchronization system and synchronization method based on domestic environment

Abstract

The invention provides a heterogeneous database synchronization system based on a domestic environment. The system comprises an initialization module, a port monitoring module, a task management module, an acquisition and extraction module, a file writing module and the like. Personalized setting is performed through reading and writing. The method comprises setting of a read-write mode, a frequency, a rate and the like. Data reading objects can be selected in batches, the system is automatically matched with a table structure of a heterogeneous data source, tables needing to be synchronized at a production end are selected through a task management module and a collection and extraction module, transmission configuration is completed, the tables at the production end are synchronously mapped to a target end through a file writing module and a channel transmission module, and configuration of the target end is completed. According to the method, mainstream databases at home and abroadare supported, meanwhile, data exchange under isolation of internal and external networks of a user is met, the functions of capturing database logs in real time, filtering mapping configured by the user and the like are achieved, and non-domestic database sql statements are converted into finally generated sql statements needed by a target end.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a heterogeneous database synchronization system and synchronization method based on a domestic environment. Background technique [0002] The current Internet is developing rapidly, the number of users is increasing, and the pressure of large-scale network applications is increasing. The processing capacity of a single machine is limited, and there will always be a maximum value, which is inevitable in a distributed environment. [0003] Since the system is constantly expanding and built in different periods, heterogeneous databases are likely to appear. It is impossible for heterogeneous databases to share data, otherwise "information islands" will appear. Therefore, how to flexibly, effectively and economically deal with the information sharing and data synchronization of these heterogeneous databases has become a research direction that has attracted much attention. [0004...

AI Technical Summary

Problems solved by technology

[0005] The technical problem solved by the present invention is to provide a heterogeneous database synchronization system and synchronization method based on the domestic environment, to solve the problem in the above background technology that the reliability of data synchronization between heterogeneous databases is low. Capable of capturing database logs in real time, converting non-domestic database sql statements into sql statements required by the target end according to user-configured filter mapping and other functions

Images