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

Database data synchronization system, method and device

A data synchronization and database technology, applied in database distribution/replication, electronic digital data processing, structured data retrieval, etc., can solve problems such as heavy load on the target database, data loss, and unsupported resuming of breakpoints

Pending Publication Date: 2019-06-28
BANK OF COMMUNICATIONS
View PDF4 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Both of the above two solutions have the following disadvantages: first, when there are a large number of transactions to be synchronized, the transactions to be synchronized captured from the source database are directly pushed to the target database, causing the target database to be overloaded; Breakpoint resume transfer is not supported, that is, when the synchronization of all transactions to be synchronized is not completed, and the target database is restarted due to failure or other reasons, the previously completed synchronization may be lost. In this case, it is necessary to resynchronize the pending synchronization transactions, the synchronization efficiency is slow, and it is easy to cause data loss

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
  • Database data synchronization system, method and device
  • Database data synchronization system, method and device
  • Database data synchronization system, method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0041] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention more clear, the embodiments of the present invention will be further described in detail below in conjunction with the accompanying drawings. Here, the exemplary embodiments and descriptions of the present invention are used to explain the present invention, but not to limit the present invention.

[0042] figure 2 It is a schematic diagram of the database data synchronization system in the embodiment of the present invention, such as figure 2 As shown, the system includes:

[0043] Synchronization source and synchronization target, where,

[0044] Synchronization source for:

[0045] Obtain the transaction to be synchronized according to the transaction log of the source database, and store the transaction to be synchronized in the cache;

[0046] Send the transactions to be synchronized in the cache to the synchronization target in batches;

[0047] Sync...

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 provides a database data synchronization system, method and device, the system comprises a synchronization source end and a synchronization target end. The method includes: according toa transaction log of a source end database, obtaining a to-be-synchronized transaction, and storing the to-be-synchronized transaction in a cache; Sending the to-be-synchronized transactions in the cache to a synchronization target end in batches, wherein The synchronization target end is used for adding the transactions to be synchronized into the transaction set after the transactions to be synchronized are received; Executing transactions in the transaction set in parallel; And deleting successfully executed transactions from the transaction set. According to the method, database data synchronization can be achieved, the burden of a target end database is low, breakpoint continuous transmission is supported, the synchronization efficiency is high, and synchronous data is not lost.

Description

technical field [0001] The invention relates to the field of data synchronization of financial industry business systems, in particular to a database data synchronization system, method and device. Background technique [0002] At present, the distributed system architecture of various applications in the financial industry leads to the need for "quasi-real-time" data synchronization between different applications, including the synchronization between the host system and the open system and the synchronization between different open systems. Typical application scenarios are as follows: [0003] Data service architecture supplement: the business system synchronizes key business data to the background data service system in quasi real-time during the day, and provides "T+0" data query and reports. [0004] Business process data centralization: Centralize process data between different systems through online synchronization and provide a global view of business processes. ...

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/2455G06F16/27
Inventor 岳艳涛汪涛张佩毅郭志军
Owner BANK OF COMMUNICATIONS
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com