Method and device for checking consistency of synchronous data in heterogeneous databases

A technology for synchronizing data and verification methods, applied in database update, structured data retrieval, database distribution/replication, etc., can solve problems affecting the stability of the synchronization system and the normal operation of the source database, and achieve consistent calibration experimental effect

Active Publication Date: 2020-06-26
WUHAN DAMENG DATABASE
View PDF8 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The purpose of the present invention is to overcome the above-mentioned technical deficiencies, provide a heterogeneous database synchronization data consistency verification method and device, and solve the problem that the heterogeneous database synchronization data verification in the prior art affects the normal operation of the source database and affects the stability of the synchronization system sexual technical issues

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
  • Method and device for checking consistency of synchronous data in heterogeneous databases
  • Method and device for checking consistency of synchronous data in heterogeneous databases
  • Method and device for checking consistency of synchronous data in heterogeneous databases

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0026] Such as figure 1 As shown, Embodiment 1 of the present invention provides a heterogeneous database synchronization data consistency verification method, including the following steps:

[0027] S1. Establish a commit transaction table in the target database, and record the synchronized source database transaction information in the commit transaction table;

[0028] S2. Capture and parse the source transaction log of the source database;

[0029] S3. Capture and parse the target-side transaction log of the target-side database;

[0030] S4. Send the target-end transaction log to the source-end data synchronization verification service;

[0031] S5. Compare the source-end transaction log with the target-end transaction log according to the synchronized source database transaction information, and verify the consistency of the synchronization data.

[0032] The invention establishes a commit transaction table in the target database, and uses the commit transaction table...

Embodiment 2

[0054] Such as image 3 As shown, Embodiment 2 of the present invention provides a heterogeneous database synchronization data consistency verification device, including a source server 10 and a target server 20; a source comparison program 11 is deployed in the source server 10, and the A target comparison program 21 is deployed in the target server 20;

[0055] The target-side comparison program 21 is used to set up a submission transaction table in the target-side database, and record the synchronized source database transaction information in the submission transaction table;

[0056] The target server 20 is configured to establish a submitted transaction table, and record the synchronized source library transaction information in the submitted transaction table;

[0057] The source comparison program 11 is used to capture and analyze the source transaction log of the source database;

[0058] The target end comparison program 21 is used to capture and analyze the target...

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 the technical field of database synchronization, and discloses a heterogeneous database synchronization data consistency verification method and device. The verification method comprises the following steps of establishing a submission transaction table in a target end database, and recording synchronized source library transaction information in the submission transactiontable; capturing and analyzing a source end transaction log of a source end database; capturing and analyzing a target end transaction log of the target end database; sending the target end transaction log to a source end data synchronization verification service; and comparing the source end transaction log with the target end transaction log according to the synchronized source library transaction information, and verifying the consistency of the synchronization data. When consistency verification is carried out on the synchronous data of the heterogeneous database, normal work of the source end database cannot be influenced, and stability of the real-time data synchronization process cannot be influenced.

Description

technical field [0001] The invention relates to the technical field of database synchronization, in particular to a method and device for checking the consistency of synchronous data in heterogeneous databases. Background technique [0002] In the process of synchronizing data in the heterogeneous database synchronization system, it is necessary to verify the data consistency of the synchronization tables of the source database and the target database to verify the correctness of data synchronization. Hereinafter referred to as the source end database is the source end, and the target end database is the target end. Since the source database is always in the production environment, the data in the source data table is constantly changing. On the other hand, due to the synchronization performance problem of the heterogeneous database synchronization system, there may be a certain period of synchronization delay when the changes in the data table at the source end are synchro...

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): G06F16/27G06F16/23
CPCG06F16/2358G06F16/2365G06F16/27
Inventor 付铨孙峰余院兰赵家威
Owner WUHAN DAMENG DATABASE
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