Data synchronization method and device

A data synchronization and database technology, applied in the database field, can solve problems such as large system overhead, and achieve the effect of reducing system overhead and improving real-time and accuracy.

Active Publication Date: 2010-06-02
UNION MOBILE PAY
View PDF0 Cites 44 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The embodiment of the present invention provides a data synchronization method and its device to solve the problem of excessive system overhead in the existing data synchronization technology

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
  • Data synchronization method and device
  • Data synchronization method and device
  • Data synchronization method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0011] The present invention extracts data changes by parsing source database transaction logs, converts them into SQL statements, executes them on the target database, and executes the same data operation on the target database, thereby completing data synchronization between the source database and the target database .

[0012] The database transaction log completely records every data change that occurs in the source database, and records operations such as data processing, transaction submission, and transaction rollback in the chronological order of data changes. The transaction log can accurately reflect the sequence and content of the data changes in the source database, as well as the operation user of the transaction and other information. By parsing the transaction log, you can fully reproduce the SQL statement that caused the data change, and run the statement on the target database instance to achieve data synchronization; at the same time, you can trace the SQL s...

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 embodiment of the invention provides a data synchronization method which comprises the following steps: acquiring operation log records corresponding to a source database, wherein the operation log records are used for recording various operation behaviors and operation information of the source database in the specified duration before the current time; and executing corresponding operations on a target database according to the operation behaviors and the operation information corresponding to each of the acquired operation log records. The data synchronization method provided by the embodiment of the invention analyzes the data operation aiming at the source database by reading the logs of the source database, and executes the same data operation on the target database to realize the data synchronization between the databases. The data synchronization method provided by the embodiment of the invention and the device thereof reduce the system cost in the data synchronization method and improve the real-time property and accuracy of data synchronization.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to a data synchronization method and device. Background technique [0002] With the development of computer networks, online consumption has penetrated into people's daily life, and the amount of data processed by corresponding real-time transaction systems is increasing. Many network real-time transaction systems have to divide the original database instance into two or more database instances according to different functional modules, so as to reduce the database access pressure. For example, the database is divided into an online database and a back-line database. The online database is responsible for online transaction processing, and the back-line database is responsible for batch transactions, customer service inquiries, and statistical analysis. [0003] Due to the application of multiple database instances, data synchronization between databases has become one of the mos...

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 Applications(China)
IPC IPC(8): G06F17/30
Inventor 吴宏强陈瑛绮
Owner UNION MOBILE PAY
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