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
CN104376017AActive Publication Date: 2015-02-25ALIBABA GRP HLDG LTD
5 Cites 42 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
ALIBABA GRP HLDG LTD
Publication Date
2015-02-25

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

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