Bidirectional synchronization system and method for internal and external network data of ORACLE database

Abstract

The invention discloses a bidirectional synchronization system and method for the internal and external network data of an ORACLE database. The system comprises a change data capture module and a dataextraction module, wherein the change data capture module obtains change data through the flashback query function of the ORACLE; and the data extraction module is used for extracting changed data and updating the changed data to a corresponding internal and external network database when new data is in the presence. Compared with the prior art, the bidirectional synchronization system and methodfor the internal and external network data of the ORACLE database solves the problems that the database requires mutually independent internal and external networks and internal and external networkdata needs to be kept consistent on an aspect of business since an application needs to have accessibility in the internal and external network can be solved.

Description

technical field [0001] The invention relates to the field of database data synchronization, in particular to a highly practical system and method for bidirectionally synchronizing ORACLE database internal and external network data. Background technique [0002] Many business systems need to be deployed in the intranet environment, but part of the business needs to be accessed through the Internet. For security reasons, in most cases, the application program and database system are deployed separately on the internal and external networks, and then the business is guaranteed through data exchange. on the consistency. [0003] There are currently many data exchange products that can achieve the above purpose; these products mainly realize functions in the following ways in terms of change data capture: [0004] Use batch program to poll regularly. [0005] Use database triggers to monitor changing data. [0006] Obtain change data based on database log analysis. [0007] T...

AI Technical Summary

Problems solved by technology

[0007] The above methods have their own advantages and disadvantages. For example, the implementation of the first two methods is more complicated and more intrusive to the business database. Although the third method has little impact on the performance of the business system and has strong real-time performance, it requires the database system to have log management system, and provides the commands or tools needed to analyze log files. In addition, different database systems have different log management mechanisms, which is not conducive to designing a general log analysis method. Based on this, there is an urgent need for a less invasive, implement Simple database technology for fetching changing data

Images