Please disable adblock to view this page.

← Go home

ACID properties of transaction

September 13, 2016
Published By : Pratik Kataria
Categorised in:


Source: sqlserverhelpdotcom

  • Atomicity : Either all operations are executed or none of the operations are executed.
  • Consistency : All the data must be in a consistent state. There should be no transaction that has adverse effect on data residing in database.
  • Isolation : If more than 1 transactions are executing simulataneously then every transaction should be executed as if no other transaction is running.
  • Durability: The database system should be able to sustain the updates. Even if the system fails or restarts, the updates should be applied.