Four characteristics of DBMS transactions

The four characteristics of database transactions are: atomicity , consistency , isolation and persistence .

Characteristics	Description	Realize
Consistency	The database must be in a consistent state before and after a transaction is executed. If the state of the database satisfies all the integrity constraints, it can also be said that the database is consistent	Implementation of DBMS Integrity subsystem
Atomic Nature	A transaction is an indivisible set of operations units that either succeed at the same time or fail at the same time	Implementation of DBMS's transaction management subsystem
Isolation of	Multiple users cannot interact with each other and need to isolate each other	Implementation of DBMS concurrency control subsystem
Durability	Once a transaction is committed, its effect on the database is permanent and irreversible, and if a rollback or exception occurs later, the committed transaction is not affected	Implementation of DBMS's recovery management subsystem

Reference:

Https://www.2cto.com/database/201801/709531.html

Https://www.cnblogs.com/Terry--Wu/p/6130502.html

Four characteristics of DBMS transactions