Database data synchronization method and device

A data synchronization and database technology, applied in the field of data processing, can solve the problems of high cost, wide range of changes in the business layer, high cost of use and operation and maintenance threshold, etc., to achieve the effect of accurate data synchronization operation and guarantee of data consistency

Pending Publication Date: 2020-09-25
INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF7 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Existing real-time synchronization tools for commercial or open source databases have relatively high cost of use and threshold for operation and maintenance. Instead of using third-party tools, implementing multi-active databases through homologous multi-write transformation is very costly for stock applications. The business layer The scope of changes is wide, and the risk of abnormalities is relatively large

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0053]In order to make the purpose, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments It is a part of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of this application.

[0054] Considering that commercial or open source database real-time synchronization tools in the existing technology have high usage costs and operation and maintenance thresholds, instead of using third-party tools, it is very costly for stock applications to achieve multi-active databases through homologous multi-write transformation , the scope of business ...

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 database data synchronization method and device, and the method comprises the steps: determining a corresponding data synchronization task and task triggering time corresponding to the data synchronization task according to the feature information of a target data table in a source database; synchronizing the target data table to a target database according to the task triggering time and the data synchronization task. According to the method and device, data synchronization operation of the main and standby databases can be conveniently, effectivelyand accurately realized.

Description

technical field [0001] The present application relates to the field of data processing, in particular to a database data synchronization method and device. Background technique [0002] Multi-park hot standby deployment of traditional relational databases is the core foundation for many enterprise stock applications to achieve high-availability architecture, involving data synchronization mechanisms between parks. [0003] Existing real-time synchronization tools for commercial or open source databases have relatively high cost of use and threshold for operation and maintenance. Instead of using third-party tools, implementing multi-active databases through homologous multi-write transformation is very costly for stock applications. The business layer The range of changes is wide, and the risk of abnormalities is relatively large. Contents of the invention [0004] Aiming at the problems in the prior art, the present application provides a database data synchronization me...

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): G06F16/27G06F11/14
CPCG06F16/273G06F11/1451G06F11/1458G06F2201/80G06F2201/82
Inventor 陈兴周歆易辛悦章磊
Owner INDUSTRIAL AND COMMERCIAL BANK OF CHINA
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