Database synchronization method and system, source data and target data synchronization device

A technology for synchronizing devices and target data, which is applied in the database field, can solve problems such as poor database performance and limited disk space, and achieve the effect of ensuring performance and saving disk space

Inactive Publication Date: 2017-05-17
ZTE CORP
View PDF4 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The invention provides a database synchronization method and system, and a source data and target data synchronization device, which solv

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

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0065] Example one

[0066] This embodiment provides a database synchronization method, such as figure 1 Shown, please refer to figure 1 :

[0067] S101. Monitor the source table in the source database;

[0068] S102. When it is monitored that a certain part of the source data in the source table undergoes an operation based on DML (Data Manipulation Language, data manipulation language), the source unique index corresponding to this part of the source data is added to the intermediate table corresponding to the source table;

[0069] S103. After the first synchronization condition is met, determine the source data to be synchronized in the source table according to the source unique index in the intermediate table, and send to the corresponding target table in the target database the source data that contains at least the source unique index corresponding to the source data to be synchronized. Synchronize messages.

[0070] Among them, when it is detected in step S102 that a certain p...

Example Embodiment

[0074] Example two

[0075] This embodiment provides a database synchronization method, such as figure 2 Shown, please refer to figure 2 :

[0076] S201: Receive a synchronization message from a source table in a source database, where the synchronization message includes at least a source unique index corresponding to the source data to be synchronized where an operation based on a data manipulation language occurs;

[0077] Wherein, the synchronization message is consistent with the synchronization message in Embodiment 1, and will not be repeated here.

[0078] S202: Extract the source unique index from the synchronization message;

[0079] S203: Search for a corresponding target unique index in the corresponding target table of the target database according to the source unique index, and perform a synchronization operation according to the search result and the synchronization message.

[0080] In step S202, extracting the source unique index from the synchronization message means...

Example Embodiment

[0081] Example three

[0082] This embodiment provides a database synchronization method, such as image 3 Shown, please refer to image 3 :

[0083] S301. Monitor the data of the source table in the source database;

[0084] S302: When it is monitored that a certain part of the source data in the source table is operated based on the data manipulation language, add the source unique index corresponding to this part of the source data to the intermediate table corresponding to the source table;

[0085] S303. After the first synchronization condition is met, determine the source data to be synchronized in the source table according to the source unique index in the intermediate table, and send to the corresponding target table in the target database the source data that contains at least the source unique index corresponding to the source data to be synchronized. Synchronization message

[0086] S304: Extract the source unique index from the synchronization message;

[0087] S305: Searc...

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 synchronization device for source data and target data and a database synchronization method and system. Through monitoring source tables in source database, the source unique index of the source data in the source table based on the operation of the data manipulation language is added to the intermediate table corresponding to the source table; after satisfying the synchronization conditions, relevant source data to be synchronized in the source table is searched based on the source unique index recorded in the intermediate table and a synchronization message carrying the source unique index is sent to a target in the target library corresponding to the source table; searching and synchronization are carried out in the target table according to the synchronization message. The synchronization process does not need to be done in archive mode, which guarantees the performance of database and saves disk space.

Description

technical field [0001] The invention relates to the database field, in particular to a database synchronization method and system, and a source data and target data synchronization device. Background technique [0002] At present, there are many methods to realize oracle database synchronization, including dataguard, stream, goldengate and other mature technologies. [0003] Among the above database synchronization technologies, all are completed in the oracle archive mode, and data synchronization is completed based on mining oracle archive logs or redo logs. However, Oracle has certain requirements for database disk space when enabling the archive mode, and a regular cleanup mechanism needs to be configured to clean up the archive. Moreover, the above technologies are suitable for large-scale multi-data synchronization. For database synchronization in some specific scenarios, it may not be possible to use the above technologies to achieve data synchronization. After archi...

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
CPCG06F16/275G06F16/00
Inventor 于维贺
Owner ZTE CORP
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