System and method for synchronizing difference data in common domain between databases

Abstract

The invention relates to a system and method for synchronizing discrepant data of a common domain between databases. The method includes the steps that the discrepant data are read, related configuration information of a data table is inquired according to discrepant data information, and a first search condition is generated according to the related configuration information; whether the discrepant data exist or not is searched for at the common domain of the two databases according to the first search condition, and accordingly search results are recorded; baseline information of the discrepant data is inquired according to the discrepant data information, and a second search condition is generated according to the baseline information; a stored record of the discrepant data is searched for in a baseline library according to the second search condition, a needed SQL statement is formed according to the second search condition and the searched stored record of the discrepant data in the baseline library, and the data of a non-baseline library are modified through the formed SQL statement by using the record of the baseline library as the baseline. By the adoption of the system and method, data synchronous processing effectiveness is guaranteed, data synchronous accuracy is improved, and mistakes and hidden risks caused by negligence of operators are reduced.

Description

technical field

[0001] The invention relates to the field of communications, and in particular, to a system and method for synchronizing common domain difference data between databases. Background technique

[0002] During the actual operation of the business operation support system, there is a common domain between the two databases. The common domain data is the data that exists in both databases. Based on the state of one database, the common domain of the other database is used as the benchmark. The data in the database should be consistent with the data in the benchmark library. However, the data of the common domain is consistent with the data department. For example, there is a certain chance that the common domain of the NGCRM library and the NGBOSS library in the system will have data inconsistency. The emergence of data discrepancies will affect the success rate of business acceptance and the accuracy of billing.

[0003] At present, the main means of processing...

Examples

Embodiment Construction

[0050] The principles and features of the present invention will be described below with reference to the accompanying drawings. The examples are only used to explain the present invention, but not to limit the scope of the present invention.

[0051] like figure 1As shown, a common domain difference data synchronization system between databases includes a difference data scanning module 1, a difference data storage module 2, a configuration table module 3, a difference situation confirmation module 4, a reference data confirmation module 5 and a data synchronization module 6; Described difference data scanning module 1, it is used for scanning the common domain data state between databases in real time, and the difference data of scanning is stored in difference data storage module 2; Described difference data storage module 2, it is used for storing in the form of data table The common domain difference data collection between databases; the configuration table module 3, whi...

technical field

[0001] The invention relates to the field of communications, and in particular, to a system and method for synchronizing common domain difference data between databases. Background technique

[0002] During the actual operation of the business operation support system, there is a common domain between the two databases. The common domain data is the data that exists in both databases. Based on the state of one database, the common domain of the other database is used as the benchmark. The data in the database should be consistent with the data in the benchmark library. However, the data of the common domain is consistent with the data department. For example, there is a certain chance that the common domain of the NGCRM library and the NGBOSS library in the system will have data inconsistency. The emergence of data discrepancies will affect the success rate of business acceptance and the accuracy of billing.

[0003] At present, the main means of processing...

Examples

Embodiment Construction

[0050] The principles and features of the present invention will be described below with reference to the accompanying drawings. The examples are only used to explain the present invention, but not to limit the scope of the present invention.

[0051] like figure 1As shown, a common domain difference data synchronization system between databases includes a difference data scanning module 1, a difference data storage module 2, a configuration table module 3, a difference situation confirmation module 4, a reference data confirmation module 5 and a data synchronization module 6; Described difference data scanning module 1, it is used for scanning the common domain data state between databases in real time, and the difference data of scanning is stored in difference data storage module 2; Described difference data storage module 2, it is used for storing in the form of data table The common domain difference data collection between databases; the configuration table module 3, whi...

Images