acid properties in dbms studytonight code example

Example 1: acid properties in dbms

Atomicity
The entire transaction take place at once or doesn't happen at all.

Consistency
Database must be consistent before and after the transaction.

Isolation
Multiple transactions occur independently without interference.

Durability
The changes of the successful transaction occurs even if the system 
failure occur.

Example 2: acid property db

A - Atomicity      transactions either take place or they dont. ('all or nothing' property)
C - Consistency	   Db must be consistent before and after a transaction.
I - Isolation      multiple transaction don't interfere with each other.
D - Durability     changes survive eventual failures of the system.

Tags:

Misc Example