Method for achieving two-way synchronous data circulation in heterogeneous database synchronizing system based on logs

A two-way synchronization and synchronization system technology, applied in structured data retrieval, database distribution/replication, electronic digital data processing, etc.

Active Publication Date: 2014-08-06
ZHEJIANG UNIV
View PDF3 Cites 22 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0008] The present invention provides a solution to two-way synchronous data circulation in a log-based heterogeneous database synchronization system. While not affecting database performance, the atomicity of database transactions is used to simply and conveniently solve the problem of data circulation

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 for achieving two-way synchronous data circulation in heterogeneous database synchronizing system based on logs

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] In the following, a solution to the two-way synchronization data cycle in a log-based heterogeneous database synchronization system of the present invention will be described in detail with reference to the accompanying drawings.

[0026] The heterogeneous database synchronization system applicable to the present invention includes at least two databases capable of bidirectional synchronization. If certain two databases can only perform one-way synchronization, then the existing technology is adopted. If certain two databases can perform bidirectional synchronization, then use The method of the invention avoids the problem of data circulation in the bidirectional synchronization of data increments.

[0027] For ease of description, the following takes database A and database B capable of two-way synchronization as examples to describe the synchronization method in detail, such as figure 1 As shown, it specifically includes the following steps:

[0028] (1) Create a spe...

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 discloses a method for achieving two-way synchronous data circulation in a heterogeneous database synchronization system based on logs. The method comprises the steps that special tables are established in databases for two-way synchronization respectively; when incremental data are transmitted to a destination database from a source database, a piece of special table data is inserted in the destination database firstly, all the incremental data are executed in the destination database secondly, and incremental data events are submitted manually in the destination database finally; in the incremental data synchronization process, incremental data are obtained from the logs with the events as units, whether the events contain a piece of inserted data of the special table B of the database B is checked, and the incremental data are no longer synchronized to the database A if the inserted data exist and the source of the inserted data is the database A; otherwise, the incremental data are synchronized to the database A. According to the method, the properties of the databases are not affected, the atomicity of the events is utilized, and data circulation is achieved simply and conveniently.

Description

technical field [0001] The invention relates to the technical field of database synchronization, in particular to a solution to bidirectional synchronization data circulation in a log-based heterogeneous database synchronization system. Background technique [0002] The database is a basic component in the IT architecture and an effective facility for storing and managing data. Now almost all applications are inseparable from the support of the database. Due to the uneven distribution of massive data and data access areas, a single database can no longer carry all the access. Generally, a database needs to be deployed in multiple different places to provide services. Each database is data complete and reliable to the outside world. The service is complete, but in fact the data between each two databases is inconsistent, so incremental data synchronization between these databases in different places is required to ensure the data consistency and service integrity of all datab...

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/2358G06F16/27
Inventor 李莹姚祥龙尹建伟邓水光吴健吴朝晖
Owner ZHEJIANG UNIV
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