Heterogeneous database content synchronizing method, device and middleware

Abstract

An embodiment of the invention discloses a heterogeneous database content synchronizing method, device and middleware. The heterogeneous database content synchronizing method includes: through a heterogeneous database content synchronizing middleware, reading transaction log of a source database and extracting increment log of the transaction log according to prestored data analysis rules of the source database, analyzing the increment log to acquire data of the increment log for updating the source database, generating global transaction unified change record of the acquired data according topreset format and storing the record, and writing the global transaction unified change record in a file format of a target database into the target database. According to the embodiment, the method,device and middleware can realize synchronization of heterogeneous database content efficiently in a short time without any influence on service of the database.

Description

technical field [0001] The embodiments of the present invention relate to the field of computer technology, and in particular to a method, device and middleware for synchronizing heterogeneous database content. Background technique [0002] At present, there are many database products, and the mainstream data products include: oracle, MySQL, SQL Server, etc. Due to the different database products used by different businesses, data content synchronization between multiple databases is required, or in the case of interaction, it is necessary to solve the differences in data formats between heterogeneous databases, and design corresponding heterogeneous database synchronization methods to achieve content synchronization. . [0003] Existing heterogeneous database content synchronization methods mainly include methods based on triggers and methods based on synchronization protocols. [0004] Among them, the trigger-based method designs triggers in the heterogeneous databases, ...

AI Technical Summary

Problems solved by technology

[0004] Among them, the trigger-based method designs triggers in the heterogeneous databases, and the triggers modify the heterogeneous databases respectively, extract their respective log files, and then realize the content synchronization between the two; the disadvantage of this method is that: The database is modified, affecting the performance of the database

The method based on the synchronization protocol modifies the network protocol between the heterogeneous database platforms, designs the standard SyncML protocol, and uses the XML (Extensible Markup Language) format to transmit the protocol data; the disadvantage of this method is that the data type is not considered Comprehensive, data loss due to network codec

Images