Transaction processing method and device, computer equipment and storage medium

Abstract

The invention discloses a transaction processing method and device, computer equipment and a storage medium, and belongs to the technical field of databases. The method comprises the steps of responding to an execution request of a target transaction; obtaining a logic execution life cycle of the target transaction; after the logic is subjected to the life cycle verification, executing a target transaction; in a transaction execution or verification stage, according to a target data item in a reading set of the target transaction and a to-be-written data item in a writing set, adjusting the logic execution life cycle; after the life cycle verification of the adjusted logic is passed, submitting the target transaction; the mechanism for processing the transaction based on the logic execution life cycle does not need to depend on a lock mechanism, so that the method is more suitable for an internet application scene with more reading and less writing, the transaction throughput of the distributed database system can be improved, the capacity of the system can be expanded, and the transaction processing performance of the system can be improved.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a transaction processing method, device, computer equipment and storage medium. Background technique [0002] With the development of database technology, in order to adapt to business scenarios such as big data and cloud computing, distributed database systems have gradually become popular. When performing distributed transaction processing in a distributed database system, decentralized transaction processing technology can be adopted. Decentralized transaction processing technology means that there is no certain node device in the database system to centrally coordinate transactions, but there are multiple node devices in the database system that can be used to act as transaction coordinators. Multiple coordinating node devices jointly process distributed transactions. When controlling transactions concurrently, they generally rely on the lock mechanism and timest...

AI Technical Summary

Problems solved by technology

Decentralized transaction processing technology means that there is no certain node device in the database system to centrally coordinate transactions, but there are multiple node devices in the database system that can be used to act as transaction coordinators. Multiple coordinating node devices jointly process distributed transactions. When concurrently controlling transactions, they generally rely on the lock mechanism and timestamp sorting mechanism. However, due to the existence of "more read requests and fewer write requests" in the current mainstream Internet application scenarios " (referred to as the phenomenon of more reads and fewer writes), the above two mechanisms limit the improvement of the transaction throughput of the entire distributed database system in the scenario of more reads and fewer writes, so they have poor transaction processing performance

Images