Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A data synchronization method and a device for data synchronization

A data synchronization and database technology, applied in the direction of structured data retrieval, database distribution/replication, etc., can solve problems such as data synchronization errors, failure to obtain operation log definition information, etc., and achieve the effect of ensuring correctness

Active Publication Date: 2019-01-11
WUHAN DAMENG DATABASE +1
View PDF9 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] The technical problem to be solved by the present invention is that when the log analysis method is used for data synchronization, the correct definition information of the operation object corresponding to the operation log cannot be obtained, resulting in an error in data synchronization

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
  • A data synchronization method and a device for data synchronization
  • A data synchronization method and a device for data synchronization
  • A data synchronization method and a device for data synchronization

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0030] In practical application scenarios, when log analysis is used for data synchronization, correct object definition information must be used. Object definition information that is too new or too old may cause analysis or synchronization errors. In this embodiment, the object definition information in the source database system dictionary is stored locally. During the log analysis process, it is sufficient to access the local offline dictionary without real-time access to the database. Not only can the impact on database performance be reduced, At the same time, it can also ensure that the correct object definition information is obtained, thereby ensuring the accuracy of data synchronization or log analysis. The method for data synchronization using an offline dictionary will be described in detail below.

[0031] Step 10: Create an offline dictionary containing object definition information.

[0032] In this embodiment, the source database first establishes an offline d...

Embodiment 2

[0101] see Image 6 , Image 6 It is a schematic structural diagram of an apparatus for data synchronization provided by an embodiment of the present invention. The device for data synchronization in this embodiment includes one or more processors 61 and a memory 62 . in, Image 6 A processor 61 is taken as an example.

[0102] Processor 61 and memory 62 can be connected by bus or other means, Image 6 Take connection via bus as an example.

[0103] Memory 62, as a non-volatile computer-readable storage medium based on data synchronization, can be used to store non-volatile software programs, non-volatile computer-executable programs and modules, such as the data synchronization method in Embodiment 1 and the corresponding program instructions. The processor 61 executes various functional applications and data processing of the data synchronization method by running the non-volatile software programs, instructions and modules stored in the memory 62, that is, realizes th...

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, which provides a data synchronization method and a device for data synchronization. The data synchronization method includes establishing an offline dictionary containing object definition information; obtaining the operation log from the source database log file; obtaining the corresponding object definition information from the offline dictionary according to the log sequence number of the operation log, and parsing the operation log according to the obtained object definition information; sending the log parsed data to the destination database. The data synchronization method of the invention can establish complementary analysis with the operation log containing only local key information in the prior art by accessing the offline dictionary, which not only ensures the correctness of the definition information of the object in the operation log, but also avoids the situation that the database is accessed in real time and the performance of the database is affected.

Description

【Technical field】 [0001] The invention relates to the technical field of database synchronization, in particular to a data synchronization method and a data synchronization device. 【Background technique】 [0002] Database synchronization technology is currently widely used in various emerging products such as distributed systems, big data, and cloud databases. The redundancy scheme of the database can effectively alleviate the huge pressure on the system brought by large amounts of data and high concurrent access. By extracting the transaction log of the source database, the data operations of the source database, including INSERT, DELETE, and UPDATE, are obtained, and then sent to the destination database through the network, and the destination restores the original SQL (Structured Query Language, abbreviated as SQL) statement in the destination database It is a commonly used database synchronization technology. The database synchronization technology has the advantages o...

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): G06F16/27
Inventor 付铨孙峰陈艳杨春
Owner WUHAN DAMENG DATABASE
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products