Database synchronization method based on drive encapsulation

Abstract

The invention discloses a database synchronization method based on drive encapsulation. The method comprises the following steps: encapsulating native database drives to form a drive end of the synchronization method, wherein interfaces provided by the drive end are the same as interfaces of the native database drives; when database accessing is carried out by an application through the interfaces provided by the drive end, directly querying a database and returning a result if the database accessing is database querying, and otherwise, recording modification operations to a log file while the database accessing is carried out; sending contents of the log file to a service end by the drive end; extracting the modification operations by the service end according to the contents of the log file, synchronizing the modification operations to other databases, and then returning a synchronization result to the drive end; and backing up the log file. The method of the invention does not depend on technical constraints of database vendors, can support various relational databases, and support synchronization of heterogeneous data, and has good data synchronization performance in a case of low loads on the databases.

Description

technical field [0001] The invention relates to the technical field of relational databases, in particular to a database synchronization method based on drive encapsulation. Background technique [0002] With the rapid development of the Internet, data has become more and more important. As a traditional data storage carrier, relational databases are being widely used. Almost all industries will store industry data in databases. As a data carrier, the database only serves as a static storage function for data, but does not involve the dynamic relationship between data (data backup, data aggregation / distribution). Therefore, a large number of database synchronization software have emerged. These synchronization software have realized the basic database synchronization function, which is to capture the changes of the source database data, and send the changed data to the destination database for storage, so as to maintain the source and destination data. End database data con...

AI Technical Summary

Problems solved by technology

Many synchronization software are developed by database manufacturers themselves. As supporting tools for their own database software, they do not support databases from other manufacturers.

[0004] (2) The supported data synchronization function is limited

Many data synchronization software only support the synchronization of homogeneous data, but have limited support for heterogeneous data synchronization

[0005] (3) Restricted by the database, it has a great impact on database performance

Since none of the database vendors has opened their redo log formats, the scanning of redo logs must be implemented through the interfaces or tools provided by the database vendors, which is restricted by the data vendors. If the database vendors refuse to provide such interfaces, they can only be scanned through trigger implementation

Images