Distributed transaction processing method and device based on improved one-phase commit

A technology of distributed transactions and processing methods, applied in the direction of transaction processing, multi-programming devices, etc., can solve problems such as inability to support distributed transactions, poor efficiency of two-phase commit, inconsistent distributed transactions, etc., to achieve consistency and guarantee The effect of high submission rate and execution efficiency

Active Publication Date: 2017-02-22
MINSHENG BANKING CORP
View PDF4 Cites 15 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The present invention provides a distributed transaction processing method and device based on improved one-phase commit, which is used to solve the poor efficiency of two-stage commit in the prior art, traditional one-stage commit cannot support distributed transactions, best effort one-stage commit Inconsistencies in distributed transactions due to infrastructure failures

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 based on improved one-phase commit
  • Distributed transaction processing method and device based on improved one-phase commit
  • Distributed transaction processing method and device based on improved one-phase commit

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0027] figure 1 The flow chart of the distributed transaction processing method based on the improved one-phase commit provided by Embodiment 1 of the present invention, as shown in figure 1 As shown, the method of the present embodiment includes:

[0028] Step 101, execute the SQL operation of the application transaction on each database. ...

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 provides a distributed transaction processing method and device based on improved one-phase commit. The method comprises the steps of carrying out SQL (Structured Query Language) operations of application transactions on databases; resolving the SQL operations, thereby determining transaction correlated SQL operations; when it is determined that any two transaction correlated SQL operations belong to different databases, generating insert statements of distributed transaction locks, and inserting the insert statements of the distributed transaction locks into the application transactions; carrying out the SQL operations, after the SQL operations are carried out successfully, calling commit operations; after the commit operations are carried out successfully, triggering release operations of the distributed transaction locks; and after the commit operations are carried out unsuccessfully, carrying out re-commit operations of the preset retry times on the unsuccessful commit operations. According to the method and the device, the consistency of the distributed transactions is realized, the commit states of the distributed transactions can be obtained, the unsuccessful transactions are recovered, and a commit rate of the one-phase commit is ensured.

Description

technical field [0001] The invention relates to the technical field of the Internet, in particular to a method and device for processing distributed transactions based on an improved one-phase commit. Background technique [0002] With the development of Internet technology, there are more and more business scenarios with high concurrent access and massive data processing. Distributed transaction processing methods can be used to process data. Distributed transactions refer to transaction participants, servers supporting transactions, and resources. Servers and transaction managers are located on different nodes of the distributed system. [0003] In the existing technology, the two-phase commit method is a blocking protocol, which has poor performance and cannot be used in high-concurrency scenarios; the traditional one-phase commit method executes each database transaction operation independently, and cannot be rolled back when a database operation fails Other database tr...

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): G06F9/46
CPCG06F9/466
Inventor 温卫斌
Owner MINSHENG BANKING CORP
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