Method and system for detecting data consistency of real-time synchronous system of database
A technology for synchronizing systems and system data, used in electrical digital data processing, special data processing applications, instruments, etc.
Active Publication Date: 2016-05-18
WUHAN DAMENG DATABASE +1
View PDF4 Cites 23 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0008] The verification method disclosed in the patent document with publication number "CN200710000456" and titled "A Method and System for Verifying Data Synchronization" predetermines the synchronization data to be verified, and focuses on the comparison method of the synchronization data to be verified, so it can be concluded that For the aforementioned offline detection method, it is not suitable for online detection of real-time data synchronization of the database
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 moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0027] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention. In addition, the technical features involved in the various embodiments of the present invention described below can be combined with each other as long as they do not constitute a conflict with each other.
[0028] The present invention takes the database table as the data consistency detection object, that is, each detection is only performed on a single database table.
[0029] The functional components involved in the present invention include data agent (AGENT, mainly used for comparing data set acquisition, and calculating its MD5 summary), comparison tool (VERI, mainly used for data comparison...
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
Login to View More Abstract
The invention discloses a method and a system for detecting data consistency of a real-time synchronous system of a database. A source end data broker and a target end data broker are deployed at a source end and a target end respectively. Specifically, the source end data broker carries out table locking operation on a source database table, obtains an operation sequence number of the source database table, and transmits the operation sequence number to the synchronous system of the database; the synchronous system of the database executes data synchronization on the operation sequence number and pauses; the source end data broker queries the data corresponding to the operation sequence number in the source database table; the target end data broker queries the data corresponding to the operation sequence number in a target database table; and a comparison tool compares the data queried by the source end data broker and the data queried by the target end data broker and generates a consistency comparison report. The method and the system improve the detection efficiency on the synchronous data consistency and ensure correct operation of the synchronous system of the database when ensuring the business continuity of an application system.
Description
technical field [0001] The present invention relates to the field of database data synchronization, in particular to a method and system for detecting data consistency in a real-time database synchronization system, which is used to determine the consistency of source data and destination data in the process of synchronous replication, thereby determining the current database synchronization system work effectiveness. Background technique [0002] With the rapid development of information technology, information systems have become the key to maintaining business operations. Enterprises urgently need to improve the availability of information systems, ensure business continuity, and minimize losses caused by disasters or failures. On the other hand, diversified business types have led to increasingly complex data access requirements, and the sharp increase in data volume has also caused the database server to be overwhelmed. Enterprises also urgently need to improve the oper...
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
Login to View More IPC IPC(8): G06F17/30
CPCG06F16/275
Inventor 付铨孙峰陈琦李专
Owner WUHAN DAMENG DATABASE