Data synchronization method and system for heterogeneous databases

Abstract

Provided is a data synchronization method and a system for heterogeneous databases. Two heterogeneous databases respectively set the same unique identifier for related control data of the same application level transaction. A source database triggers modification of the related control data, with the unique identifier, of the same application level transaction. Modification information is set in a source data synchronization table in the source database. The source data synchronization process in a data synchronization execution system reads the modification information in the source data synchronization table, and the modification information is converted into a standard text file to store. The target database synchronization process in the data synchronization execution system reads the standard text file, and the standard text file is converted into the modification information of the related control target data, with the unique identifier, of the same application level transaction. The modification information is written into a target data synchronization table in a target database. The related target data in the target database is modified after the modification information of the related control target data in the target data synchronization table. According to the data synchronization method and the system for heterogeneous databases, data synchronization between databases with different data storage structures is achieved.

Description

technical field [0001] The invention relates to the field of databases, in particular to a data synchronization method and system among heterogeneous databases. Background technique [0002] With the development of database technology, databases with different data storage structures appear. How to synchronize data in databases with different data storage structures has become an urgent problem to be solved. [0003] A specific example is given to illustrate that, for example, data synchronization is performed between a business support system (CRM) database and a business operation support system (BOSS) database, and the data is data synchronization that supports transaction control. CRM is mainly responsible for the user's business acceptance and activation in various channels, and BOSS is mainly responsible for the billing of users. When BOSS wants to bill the user, the BOSS database needs to obtain the control information of the user's application-level transaction from...

AI Technical Summary

Problems solved by technology

[0006] Using the above method to realize the data synchronization process between the CRM database and the BOSS database, it is necessary to ensure that the two databases have the same storage structure and the same version, which has some disadvantages: the relevant control data of an application-level transaction needs to be decomposed into multiple database transactions , which corresponds to multiple entries in the CRM database, and also corresponds to multiple database transactions when synchronizing to the BOSS database

When the CRM database wants to modify the relevant control data of an application-level transaction, it is necessary to modify multiple entries in the CRM database. At this time, it is also necessary to modify multiple entries in the BOSS database, which is cumbersome and error-prone

In addition, when the control data related to an application-level transaction is synchronized to the BOSS database, it is split into multiple entries, and the multiple entries do not indicate the relevant application-level transactions, and the BOSS database does not update the data before synchronization. The data is saved, so when it is necessary to revoke the application-level transaction-related control data, it is difficult to simply completely revoke it

[0007] Therefore, there is no data synchronization method and system among heterogeneous databases at present.

Images