Distributed transaction processing method and device

A distributed transaction and processing method technology, applied in the field of distributed transaction processing methods and devices, can solve the problems of prone to errors and omissions, large workload, low work efficiency, etc., to ensure consistency, small workload, work and development Efficient effect

Pending Publication Date: 2020-10-09
BANK OF CHINA
View PDF2 Cites 6 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

During this process, if there is an error during the transaction, it is necessary to manually write the application program for data backflush, restore the database to the state before the transaction, or manually process the inconsistent recovery, which has a large workload, low work efficiency, and is prone to errors and omissions

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
  • Distributed transaction processing method and device
  • Distributed transaction processing method and device
  • Distributed transaction processing method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0054] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention more clear, the embodiments of the present invention will be further described in detail below in conjunction with the accompanying drawings. Here, the exemplary embodiments and descriptions of the present invention are used to explain the present invention, but not to limit the present invention.

[0055] The names involved in the present invention are explained below:

[0056] Distributed system: usually refers to a system whose components are distributed on networked computers, and the components communicate and coordinate actions by passing messages. A distributed system consists of multiple machines that form a set, which is perceived as a whole to provide external services to users, and cooperates between multiple machines through network messages.

[0057]Transaction: It consists of a set of data change operations. We hope that this set of operations can ...

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 distributed transaction processing method and device. The method comprises the steps of establishing a unified global transaction ID for multiple transactions in multiple databases; performing association processing on read-write operations in a plurality of database to-be-processed data tables and the global transaction ID; updating the to-be-processed data tables in theplurality of databases to obtain an updating result; and submitting or rolling back a transaction record in the to-be-processed data tables according to the updating result, wherein the plurality ofdatabases are isomorphic databases or heterogeneous databases. According to the method and the device, the consistency of data during transaction rollback across multiple databases is guaranteed, meanwhile, an application program does not need to be manually written for data rollback, the workload is small, the working and development efficiency is high, and mistakes and omissions are not likely to occur.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a distributed transaction processing method and device. Background technique [0002] At present, there is a bottleneck in the application of distributed systems in database transactions. There are database performance problems through XA protocol two-phase commit / three-phase commit, and it is difficult to achieve automatic transaction rollback across multiple databases, resulting in greater consistency in distributed databases. question. [0003] The prior art generally uses flexible transactions, such as TCC (Try Confirm Cancel) or SAGA, to perform transaction rollback, which has solved the above-mentioned consistency problem. Take TCC as an example. TCC is a compensating distributed transaction. It has three steps to realize distributed transactions: Try, which is to try the business to be executed. This process does not execute the business, but completes the consistency c...

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): G06F16/27G06F16/23
CPCG06F16/27G06F16/2365G06F16/2343
Inventor 李增兴谢立治邓卫兵
Owner BANK OF CHINA
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