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

A differential data and synchronization system technology, applied in the field of communication, can solve problems such as hidden risks, imprecise manual intervention, and unguaranteed processing timeliness, so as to reduce errors and hidden risks, provide data synchronization accuracy, and ensure processing The effect of aging

Active Publication Date: 2017-06-13
北京思特奇信息技术股份有限公司
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

After the difference occurs, the processing time cannot be guaranteed, and the manual intervention method is not rigorous, which may cause errors due to the negligence of the operator, and there are hidden risks

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • System and method for synchronizing difference data in common domain between databases
  • System and method for synchronizing difference data in common domain between databases
  • System and method for synchronizing difference data in common domain between databases

Examples

Experimental program
Comparison scheme
Effect test

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...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

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...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/2282G06F16/24537G06F16/27G06F16/275
Inventor 刘金洁
Owner 北京思特奇信息技术股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap