ACID Properties : Database Transaction Concept

ACID Properties

ACID Properties

A transaction is a unit of program execution that accesses and possibly updates various data items.

The transaction consists of all operations executed between the begin transaction and end transaction.

Properties of Transaction (ACID Properties):

  • Atomicity: Either all operations of the transactions are reflected, or none are.
  • Consistency: Execution of transaction is isolation.
  • Isolation: Each transaction is unaware of other transactions.
  • Durability: After a transaction completes successfully, the changes it has made to the database persist.

Transaction State:

  • Active:
  • Partially Committed:
  • Failed:
  • Aborted:
  • Committed:

Benefits of concurrency:

  • Improved throughput and resource utilization.
  • Reduced waiting time.

Check out more about Database : Click Here

Adarsh Patel

My Self Adarsh Suryakant Patel. Currently I am working as Assistant Professor at Parul Instiute of Engineering and Technology, MCA Department, Limda, Vadodara. Major Responsibility : * Lectures * Organizing Training and Expert Sessions for * Placement and Recruitment * Faculty Representative