Four characteristics of DBMS transactions

Source: Internet
Author: User

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





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


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




Four characteristics of DBMS transactions

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.