System and method for synchronizing discrepant data of common domain between databases

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

Active Publication Date: 2015-01-21
北京思特奇信息技术股份有限公司
View PDF3 Cites 9 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

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 discrepant data of common domain between databases
  • System and method for synchronizing discrepant data of common domain between databases
  • System and method for synchronizing discrepant data of common domain between databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0050] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0051] Such as figure 1As shown, a system for synchronizing difference data in shared domains 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 benchmark data confirmation module 5 and a data synchronization module 6; Described difference data scanning module 1, it is used for real-time scanning common domain data state between databases, 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 set between databases; the configuration tab...

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 communication field, in particular to a system and method for synchronizing difference data in shared domains between databases. Background technique [0002] During the actual operation of the business operation support system, there is a shared domain between the two databases. The data at should be consistent with the data in the reference library. However, the data in the public domain may be partially consistent. For example, there is a certain probability that the data in the public domain of the NGCRM database and the NGBOSS database in the system may be inconsistent. The emergence of data discrepancies will affect the success rate of business acceptance and billing accuracy. [0003] At present, the main means of dealing with the difference data between the two parties is manual intervention, that is, manually writing scripts for updating (one or more data tables). After the difference occurs, the processing time...

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