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 obtaining a read-write set of a target transaction in an execution stage of the target transaction, verifying whether the target transaction meets a self concurrency consistency level or not according to a logic starting moment and a logic submitting moment of the target transaction in a verification stage, and dynamically updating the logic starting moment based on a predetermined strategy. Thus, the logic starting moment and the logic submitting moment which are finally updated are enabled not to generate data exception which is not allowed by the own concurrency consistency level under the legal condition, and then the target transaction is submitted, so that different transactions in the whole system can correspond to different concurrency consistency levels, and the user experience is improved. The data exception detection accuracy is greatly improved, and the transaction processing efficiency and the performance of a database system are 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] 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