Data synchronization method and apparatus for database system, and server

A data synchronization and database technology, applied in the field of communication, can solve the problems of low data synchronization efficiency in database systems, and achieve the effect of improving data synchronization efficiency

Inactive Publication Date: 2015-10-14
ZTE CORP
View PDF4 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] Aiming at the problem of low data synchronization efficiency of the database system in the related art, the present invention provides a data synchronization method, device and server of the database system to at least solve the above problems

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
  • Data synchronization method and apparatus for database system, and server
  • Data synchronization method and apparatus for database system, and server
  • Data synchronization method and apparatus for database system, and server

Examples

Experimental program
Comparison scheme
Effect test

example 1

[0089]This example illustrates that in a typical application scenario, there are two LCR operations on the same data table in one transaction:

[0090] Step A1: Assume that the data table TAB exists in both the source database and the destination database, defined as follows:

[0091] CREATE TABLE TAB(

[0092] FLD_A INT PRIMARY KEY,

[0093] FLD_B CHAR(10),

[0094] FLD_C VARCHAR(10)).

[0095] The three fields of the table represent the three most commonly used data types, among which FLD_A is the primary key.

[0096] Step B1: Execute a transaction on the table TAB in the source database, including one INSERT action and one UPDATE action:

[0097] BEGIN

[0098] INSERT INTO TAB VALUES(1,'A','B');

[0099] UPDATE TAB SET FLD_B='B',FLD_C='A'WHERE FLD_A=1;

[0100] COMMIT

[0101] Step C1: Capture these two actions through a certain LCR capture mechanism, and the content of the captured LCR is:

[0102] BEGIN: transaction start marker

[0103] LCR1 content:

[0104]...

example 2

[0124] This example illustrates that in a typical application scenario, there are two LCR operations on different data tables in one transaction, and the data synchronization is successful:

[0125] Step A2: The TAB structure of the table follows the table in Step A1 in Example 1. The table TAB1 is different from the table TAB only in the table name and has the same structure.

[0126] Step B2: Executing a transaction in the source database includes one INSERT action on the data table TAB and one INSERT action on the data table TAB1:

[0127] BEGIN

[0128] INSERT INTO TAB VALUES(1,'A','B');

[0129] INSERT INTO TAB1VALUES(2,'A','B');

[0130] COMMIT

[0131] Step C2: Through a certain LCR capture mechanism, capture the two actions of the transaction, and the content of the captured LCR is:

[0132] BEGIN: transaction start marker

[0133] LCR1 content:

[0134] Table name: TAB Operation type: INSERT

[0135] Field original value list: None (INSERT action has no origin...

example 3

[0154] This example illustrates that in a typical application scenario, there are two LCR operations on different tables in one transaction, data synchronization fails, and the transaction rolls back:

[0155] Step A3: The structure of the data table follows the table TAB and table TAB1 in the second example.

[0156] Step B3: Executing a transaction in the source database includes one INSERT action on the data table TAB and one INSERT action on the data table TAB1:

[0157] BEGIN

[0158] INSERT INTO TAB VALUES(1,'A','B');

[0159] INSERT INTO TAB1VALUES(2,'A','B');

[0160] COMMIT

[0161] Step C3: Use some kind of LCR capture mechanism to capture the two actions of the transaction, and the content of the captured LCR is:

[0162] BEGIN: transaction start marker

[0163] LCR1 content:

[0164] Table name: TAB Operation type: INSERT

[0165] Field original value list: None (INSERT action has no original value list)

[0166] List of new values ​​for the field:

[0167...

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

A data synchronization method, device and server of a database system, the data synchronization method of the database system comprising: reading a transaction scope consisting of logical change records (LCRs) of a source database; distributing the LCRs corresponding to the same data sheet of the transaction scope to the same thread of multiple threads, the multiple threads being configured to execute the LCRs, such that data synchronization tasks of some or all of different data sheets can be processed concurrently, thus improving data synchronization efficiency of the database system.

Description

technical field [0001] The present invention relates to the communication field, in particular, to a data synchronization method, device and server of a database system. 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 will be deployed in an information system, and these multiple sets of databases need to cooperate and share data, which requires Ability to synchronize data. [0004] In order to achieve this goal, all mainstream database vendors have launched their own data synchronization technologies, such as Oracle's Streams and Sybase's Replicatio...

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): G06F17/30
CPCG06F16/27
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