Transaction processing method, device, computer equipment and storage medium

Abstract

The application discloses a transaction processing method, device, computer equipment and storage medium, belonging to the technical field of databases. This application obtains the read-write collection of the target transaction in the execution phase of the target transaction, and in the verification phase, according to the logical start time and logical commit time of the target transaction, verifies whether the target transaction conforms to its own concurrency consistency level, and based on the predetermined strategy Dynamically update the logical start time, so that the final updated logical start time and logical commit time can be legal, without data exceptions that are not allowed by its own concurrency consistency level, and then submit the target transaction, which can make the entire system Different transactions in the database correspond to different concurrency consistency levels, greatly improving the accuracy of data anomaly detection, improving transaction processing efficiency and database system performance.

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] Data processing technology requires the semantics of transactions and borrows the four ACID characteristics of relational databases to ensure the transaction characteristics of the system to meet the needs of electronic transactions. Among them, A is atomicity, C is consistency, I is isolation, and D is persistence. Electronic transaction operations require these four characteristics to ensure the safety and reliability of transactions. Distributed transaction processing technology also needs to meet the four ACID characteristics of transactions. In order to meet the four ACID characteristics, data processing technology needs a variety of technologies to guarantee, the most important of which is data consistency and isolation. Among them, data consistency Th...

AI Technical Summary

Problems solved by technology

The serializable technology and multiple concurrent access control technologies in the database field can only solve the problems related to transaction consistency, but cannot solve other consistency problems (for example, the consistency problem of shared data objects), so through serialization Technology, unable to detect some abnormal problems

That is to say, there are transactions that partially meet the serializability requirements but still have exceptions, which cannot be detected by the serializable scheduling technology, that is, transactions consistent with other consistency (for example, shared data object consistency ) data abnormality problem, which cannot be identified, and the accuracy of system status detection is low

Images