Shulou(Shulou.com)05/31 Report--

This article mainly introduces the four characteristics and meaning of database transactions, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, let the editor take you to understand it.

Four characteristics and meanings of Database transaction

There are four basic elements for the correct execution of database transaction transanction.

ACID

Atomicity (Atomicity)

Atomicity: all operations in the whole transaction are either completed or not completed, and cannot be stuck in the middle. An error occurs during the execution of a transaction and is Rollback back to its state before the transaction starts, as if the transaction had never been executed.

Consistency (Correspondence)

Consistency: before the transaction starts and after the transaction ends, the integrity constraints of the database are not broken.

Isolation (Isolation)

Isolation: transactions are executed in an isolated state so that they appear to be the only operations performed by the system at a given time. If there are two transactions that run at the same time and perform the same function, the isolation of the transaction ensures that each transaction is thought to be the only transaction in the system that is using the system. This attribute is sometimes called serialization, and to prevent confusion between transaction operations, requests must be serialized or serialized so that there is only one request for the same data at a time.

Persistence (Durability)

Persistence: after the transaction completes, the changes made by the transaction to the database are persisted in the database and are not rolled back.

Thank you for reading this article carefully. I hope the article "what are the four characteristics and meanings of database transactions" shared by the editor will be helpful to everyone? at the same time, I also hope that you will support and pay attention to the industry information channel. more related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.