Pages

Men

rh

6/04/2012

ACID Properties in SQL Server

A transaction is a single unit of work in a data base. The ACID is often used to describe the characteristics of a transaction.

ACID Stands for
  • Atomicity
  • Consistency
  • Isolation
  • Durability
Atomicity: A Transaction is  a atomic unit, either all operations are defined in the transaction are completed, or none of them are completed.

Consistency:
A Transaction always leaves the data in consistent state.

Isolation:
A Transaction operates in a isolation from other database activity;  other concurrent data base activity has no effect on the transaction.

Durability:
When a transaction is committed, the  results are stored in persistent storage and will survive system failure.

No comments :

Post a Comment