Unlock instant, AI-driven research and patent intelligence for your innovation.

Method, device and system for data synchronization between source database and destination database

A synchronization device and data synchronization technology, which is applied in the database field, can solve the problem of heavy workload of transmitting LCR, and achieve the effect of small workload

Inactive Publication Date: 2010-04-21
ZTE CORP
View PDF0 Cites 21 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The source database transmits all changed LCRs to the destination database one by one. When the source database changes frequently, the workload of transmitting LCR 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
  • Method, device and system for data synchronization between source database and destination database
  • Method, device and system for data synchronization between source database and destination database
  • Method, device and system for data synchronization between source database and destination database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0052] In order to make the technical problems, technical solutions and advantages to be solved by the embodiments of the present invention clearer, the following will describe in detail with reference to the drawings and specific embodiments.

[0053]Embodiments of the present invention aim at the problem of heavy workload of transmitting LCR when data is synchronized between the source database and the destination database in the prior art, and provide a method, device and system for data synchronization between the source database and the destination database.

[0054] Such as figure 2 As shown, the method for data synchronization between the source database and the destination database according to the present invention includes:

[0055] Step 21, the synchronizing device acquires at least one first logical change record LCR and a keyword of the first logical change record from the source database;

[0056] Step 22, the synchronization device judges whether there is a se...

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 method, a device and a system for data synchronization between a source database and a destination database, relates to the field of databases, and aims to solve the problem of large workload for transmitting LCR during the data synchronization between the source database and the destination database. The method comprises the following steps that: a synchronization device acquires at least one first LCR and keywords of the first LCR from the source database; the synchronization device judges whether to have a second LCR of which keywords are the same as the keywords of the first LCR, and generates a judgment result; the synchronization device processes the first LCR according to the judgment result, and generates a processed LCR so that the synchronization device only stores one LCR comprising the keywords of the first LCR; and the synchronization device sends the processed LCR to the destination database. The data transmission amount is reduced during the synchronization between the source database and the destination database.

Description

technical field [0001] The present invention relates to the field of databases, in particular to a method, device and system for synchronizing data between a source database and a target database. Background technique [0002] Since Dr. E.F. Codd proposed the original theoretical model in 1970, the relational database has become one of the essential infrastructures in all information systems, and its importance is second only to the operating system. Today, no large-scale system can be separated from the database. and exist. [0003] In practical applications, due to the complexity of business logic and the modular design of functions, often multiple sets of databases are deployed in an information system, and these multiple sets of databases need to cooperate and share data, which requires Ability to synchronize data. In order to achieve this goal, all mainstream database vendors have launched their own data synchronization technologies, such as Oracle (Oracle Systems Co....

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
CPCG06F17/30286G06F16/273
Inventor 丁奇鹏
Owner ZTE CORP