Transaction execution method, apparatus, computer equipment and storage medium

Abstract

The present application discloses a transaction execution method, device, computer equipment and storage medium, which belong to the technical field of databases. Based on the target time period, the present application obtains at least one active transaction whose submission time is within the target time period, detects whether the read set of the target transaction has an intersection with the write set of the at least one active transaction, and obtains the detection result. According to the detection result, Determine the transaction status information of the target transaction. The transaction status information is used to indicate the execution status corresponding to the detection result. When writing the target transaction globally, the transaction status information of the target transaction is stored, and the write-write conflict is still performed. However, regardless of whether the detection result indicates that there is a conflict, it does not affect the global writing of the target transaction, which improves the concurrency of transaction execution in the database system and improves the transaction execution efficiency in the database system.

Description

technical field [0001] The present application relates to the technical field of databases, and in particular, to a transaction execution method, apparatus, computer equipment and storage medium. Background technique [0002] With the development of database technology, distributed database systems have gradually become popular in order to adapt to business scenarios such as big data and cloud computing. Concurrency control algorithms used in distributed database systems generally do not allow write-write conflicts (write-write conflicts refer to two different transactions performing write operations on the same data item), and the concurrency control algorithm will use a rollback or delay mechanism. To block write-write conflict transaction commits. Since write-write conflicts are common in high concurrency scenarios, the concurrency control algorithm's constraint mechanism on write-write conflicts will greatly affect the concurrency of transaction execution, resulting in ...

AI Technical Summary

Problems solved by technology

Since write-write conflicts are common in high-concurrency scenarios, the constraint mechanism of the concurrency control algorithm on write-write conflicts will greatly affect the concurrency of transaction execution, resulting in the rollback of a large number of transactions in the distributed database system, affecting the distributed database system. transaction execution efficiency

Images