Supercharge Your Innovation With Domain-Expert AI Agents!

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 solves the problems of poor database performance and limited disk space in the prior art caused by database synchronization completed in archive mode

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

Embodiment 1

[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 detected that a certain part of the source data in the source table is operated based on DML (Data Manipulation Language, 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;

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

[0070] Wherein, when detecting in step S102 that a certain part of the source data in the source t...

Embodiment 2

[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 the source database, where the synchronization message at least includes a source unique index corresponding to the source data to be synchronized where the operation based on the 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 the corresponding target unique index in the corresponding target table of the target library 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 ...

Embodiment 3

[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 detected that a 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 satisfied, determine the source data to be synchronized in the source table according to the source unique index in the intermediate table, and send a message containing at least the source unique index corresponding to the source data to be synchronized to the corresponding target table in the target database synchronization message;

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

[0087] S305. Search the target table fo...

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
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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