Distributed heterogeneous database data processing method and device

Abstract

The embodiment of the invention discloses a distributed heterogeneous database data processing method and device, and the method comprises the steps: receiving a data updating request of a data updating initiator, and starting a data updating collaborative transaction; according to the data updating request, performing data pre-updating processing on a plurality of databases in the distributed heterogeneous database, and obtaining a pre-updating result corresponding to each database; judging whether the pre-updating result of any database in the pre-updating results of the databases is updating failure or not; if yes, acquiring non-updated data of which the pre-updating result is provided by the database which fails to be updated; covering the updated data in the database of which the pre-updating result is successful updating by utilizing the non-updated data; closing data update collaboration transactions. In the data updating collaborative transaction, the updated data is updated byutilizing the non-updated data coverage, so that the data consistency in the distributed heterogeneous database is guaranteed.

Description

technical field [0001] The embodiment of the present invention relates to the technical field of databases, and in particular to a data processing method and device for a distributed heterogeneous database. Background technique [0002] A heterogeneous database is a collection of multiple databases, where each database has its own autonomy, which can be multiple databases with the same data model, or databases with different data models. To achieve data consistency between databases of heterogeneous databases, the existing technology generally adopts the XA protocol (a two-phase commit protocol defined by the X / Open DTP organization, which uses a two-phase commit method to manage distributed transactions), or the TCC distribution Two-stage transactions such as formal transactions and BASE flexible transaction methods are used to achieve data consistency. However, using any of the above two-phase transactions, there are the following problems: [0003] 1) A large amount of ...

AI Technical Summary

Problems solved by technology

[0004] 2) There may still be transaction inconsistencies

For example, BASE flexible transactions will fail when there is a positive data update retry, resulting in the heterogeneous database still unable to reach consistency in the end

The XA protocol cannot completely avoid the abnormality of the node updating the database in the second phase, resulting in transaction inconsistency

Images