Showing posts with label ACID property in SQL server. Show all posts
Showing posts with label ACID property in SQL server. Show all posts

Tuesday, May 10, 2016

ACID properties in SQL

ACID stand for
  1. A is stand for Atomicity
  2. C is stand for Consistency
  3. I is stand for Isolation
  4. D is stand for Durability

Atomicity – Atomicity is the features that means all the operations in the transaction must be completed successfully and committed, if any operations become fails then all the transactions must be rolled back.

Consistency – This is the features that means the transaction must be consistent is a state, in other words the transaction must be change the state of the system for a specific operation.

Isolation - Isolation is the property that contains the features that one operation in the transaction cannot see the result of the other operation in the transaction.

Durability – It means the transaction must be durable once it has been successfully completed, it prevent from the loss of information in case of resource damage and system failure.