Real-time synchronization system and method for heterogeneous database

The invention relates to the technical field of databases, in particular to a real-time synchronization system of a heterogeneous database, which comprises: a log analysis module used for extracting a first type of transaction statements related to source end database changes in logs; the decomposit...

Full description

Saved in:
Bibliographic Details
Main Author WANG LINYONG
Format Patent
LanguageChinese
English
Published 20.08.2021
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary:The invention relates to the technical field of databases, in particular to a real-time synchronization system of a heterogeneous database, which comprises: a log analysis module used for extracting a first type of transaction statements related to source end database changes in logs; the decomposition module that is used for extracting a first type of grammar in the first type of transaction statement and a first type of data type corresponding to a field in the first type of transaction statement; the escape module that is used for mapping a first type of grammar of the first type of transaction statement into a second type of grammar corresponding to a target database in a plurality of databases, mapping a first type of data type of the first type of transaction statement into a second type of data type corresponding to the target database, and assembling the first type of transaction statements into a second type of transaction statements according to a second type of grammar and a second type of data typ
Bibliography:Application Number: CN202110402736