What are the ACID features in the database?

Editor to share with you what is the characteristics of ACID in the database, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

ACID, the basic feature of database management system.

A-automacity, atomicity

C-consistency, consistency

I-isolation, isolation

D-durability, persistence

Detailed explanation:

Atomicity: all operations in a transaction are either completed or not completed. It doesn't end in some middle part of the transaction. During the execution of the transaction, an error occurs and is rolled back to the state before the start of the transaction.

Consistency: the integrity of the database is not compromised before the transaction starts and after the transaction ends.

Isolation: the ability of a database to allow multiple concurrent transactions to read, write and modify its data at the same time. Isolation can prevent data inconsistencies caused by cross execution when multiple transactions are executed concurrently. Transaction isolation is divided into different levels, including read uncommitted (Read uncommitted), read commit (read committed), repeatable read (repeatable read) and serialization (Serializable).

Persistence: after the transaction is completed, the modification of the data is permanent, even if the system failure will not be lost.

These are all the contents of the article "what are the ACID features in the database?" Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!