Database synchronization method and system

A technology for synchronizing systems and databases, applied in database distribution/replication, digital data processing, structured data retrieval, etc., and can solve problems such as low synchronization speed, processing capacity, and response time impact

Inactive Publication Date: 2014-03-26
KINGDEE SOFTWARE(CHINA) CO LTD
View PDF6 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, when implementing database synchronization through triggers, it is usually necessary to establish triggers on all required database tables, and then use triggers to capture

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0025] Taking the oracle database as an example below, the present invention is further described:

[0026] refer to figure 1 As shown, a database synchronization method includes the following steps:

[0027] Step S101, obtaining online redo logs in the source database, and creating corresponding capture threads;

[0028] Step S102, analyzing the online redo log. For example, each online redo log in the oracle database can start a thread for continuous analysis. Step S103, switch the capture thread according to the analysis result, and capture incremental data in the source database through the...

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 synchronization method and a database synchronization system. The database synchronization method comprises the following steps that an online redo log of a source database is obtained, and a corresponding capture thread is created; the online redo log is analyzed; the capture threads are switched according to the analysis result, and incremental data in the source database is obtained through the switched capture thread; the captured incremental data is transmitted to a corresponding transmit queue; the incremental data in the transmit queue is subjected to adaptation and is then transmitted to a target database for synchronization. With the database synchronization method and the database synchronization system, the database synchronization speed can be improved.

Description

technical field [0001] The invention relates to the field of data storage, in particular to a database synchronization method and a database synchronization system. Background technique [0002] At present, database synchronization usually needs to be implemented with the help of triggers. The synchronization process is: create a trigger on the database table that needs to be synchronized, and when the data changes, use the trigger to record and capture the changed data, and then send it to the target database. The application implements data synchronization. [0003] However, when implementing database synchronization through triggers, it is usually necessary to establish triggers on all required database tables, and then use triggers to capture data changes. This method uses third-party components to achieve database synchronization. The processing power and response time have a great impact, resulting in a lower synchronization speed. Contents of the invention [0004...

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): G06F17/30
CPCG06F11/3065G06F16/27
Inventor 贺召军
Owner KINGDEE SOFTWARE(CHINA) CO LTD
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