Database synchronization method and system thereof

A database and data technology, applied in the database synchronization method and system field, can solve the problems of synchronization failure, cumbersome work, multi-system resources, etc., and achieve the effects of reducing the consumption of system resources, ensuring consistency, and ensuring reliability

Inactive Publication Date: 2011-07-20
TELEFON AB LM ERICSSON (PUBL)
View PDF2 Cites 78 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Since this synchronization method loses the transaction information when it is initially entered into the table, the data corresponding to the difference of all transactions must be synchronized during the synchronization process, otherwise the integrity of the transaction cannot be guaranteed
[0004] This synchronization method is not only cumbersome, but if there is a lot of synchronization data, the database transaction will be too long, which will not only occupy more system resources, but also may cause synchronization failure

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0044] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.

[0045] Such as figure 1 Shown is the flowchart of the database synchronization method of the embodiment of the present invention, including the following steps:

[0046] In step 101, the change information of the data in the source database and the transactions corresponding to the change information are captured in real time, and the captured change information and transactions are stored in the intermediate database.

[0047] In the embodiment of the present inv...

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 relates to the technical field of data synchronization, and discloses a database synchronization method. The method comprises the following steps of: capturing the variation information of the data in a source database and the affairs corresponding to the data variation in real time, and storing the captured variation information and the affairs in a middle database; determining a target database needed to be synchronized, according to the variation information stored in the middle database; converting the variation information into the target data corresponding to the target database; and synchronously updating all the target data corresponding to the same affair to the target database. With the database synchronization method and the system thereof, the data synchronization of different types of databases and the data synchronization between heterogeneous data tables are implemented, consumption of system resource in the synchronization process is reduced, and the reliability of the synchronization process is ensured.

Description

technical field [0001] The present invention relates to the technical field of data synchronization, and more specifically, to a database synchronization method and system. Background technique [0002] In the production and operation process of an enterprise, there are often multiple systems, and these systems need to cooperate with each other, and some data needs to be shared among these systems, so it is necessary to keep these shared data synchronized among different systems. [0003] In the prior art, due to differences in different systems and different functions, the physical structures of the databases in each system are not completely consistent. In order to synchronize these shared data, it is usually necessary to write a synchronization program for each system. In the process of data synchronization, the synchronization program converts the data in the source table, compares the converted data with the data in the target table, and then incrementally synchronizes ...

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
Inventor 陈宏明温文全
Owner TELEFON AB LM ERICSSON (PUBL)
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