Method and system for inter-database data synchronization

A data synchronization and database technology, which is applied in database distribution/replication, electronic digital data processing, structured data retrieval, etc., can solve problems such as inability to support heterogeneous databases, inability to solve infinite loop synchronization, etc., to reduce network transmission volume, The effect of improving efficiency

Active Publication Date: 2015-02-25
ALIBABA GRP HLDG LTD
View PDF5 Cites 42 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] However, the above-mentioned existing technology is only a solution within the mysql database, which means that it can only be effective between mysql databases and cannot support heterogeneous databases, that is, if different types of databases are used in different computer rooms , the above solution will not be able to solve the infinite loop synchronization problem

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 and system for inter-database data synchronization
  • Method and system for inter-database data synchronization
  • Method and system for inter-database data synchronization

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] The following will clearly and completely describe the technical solutions in the embodiments of the application with reference to the drawings in the embodiments of the application. Apparently, the described embodiments are only some of the embodiments of the application, not all of them. All other embodiments obtained by persons of ordinary skill in the art based on the embodiments in this application belong to the protection scope of this application.

[0031] In the embodiment of this application, instead of improving the internal code of a specific type of database, a set of synchronization management system is developed during the process of using various types of databases to deploy computer rooms in different places. The SQL (Structured Query Language) specification used by this synchronization management system operates on various databases. Therefore, as long as it is a database that supports the SQL specification, the synchronization management system in the e...

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 and a system for inter-database data synchronization. The method includes starting a service when receiving synchronization change information transmitted to second database from first database; inserting identifiers defined for the first database in advance and business data carried in the synchronization change information into the service through the SQL (structured query language) standard so as to trigger the second database to record the identifiers of the first database in the change log; submitting the service to the second database so as to enable the second database to implement data synchronization change according to the business data; judging whether the identifiers in the change log are identical with those defined for the first database in advance or not after the synchronization change of the second database is completed to generate new change data; if yes, neglecting the change data so as not to transmit the synchronization change information to the first database. By the method and the system for the inter-database data synchronization, endless-loop synchronization among isomerous databases can be avoided.

Description

technical field [0001] The present application relates to the technical field of two-way synchronization of databases, in particular to a method and system for data synchronization between databases. Background technique [0002] At present, in some large-scale business processing systems, in order to improve the business processing speed, it is generally necessary to deploy computer rooms in multiple places. Of course, the databases in different computer rooms need to maintain data synchronization. For example, the main business of the international station of an e-commerce trading platform is export, and the characteristics of its business are: the seller users are in China, and the buyer users are abroad. Therefore, it is necessary to deploy remote computer rooms in foreign countries (for example, the United States). It has formed that the seller publishes the product on the domestic computer room, and synchronizes it to the US computer room through the database synchroni...

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 ALIBABA GRP HLDG LTD
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