ACID

In computer science ACID is a set of properties which make sure that database transactions are processed reliably. In the context of database a single logical operation called Transaction.

 Atomicity

Atomicity means “All or Nothing”. If one part of transaction fails whole transaction will get into failed state and database status left unchanged. This concepts works in real time environment when database will suffer auto shut down, electricity failure, error and crashes.

Consistency

Consistency property ensures that whatever value database will store will pass all the validation and that is a correct value.

This will make sure that data will be valid according to defined rules, not limited to constraints, cascades and triggers

Isolation

Isolation property ensures that the concurrent execution of transactions results in a system state that would be obtained if transactions were executed serially. i.e one after another.

No transaction sees the intermediate effects another transaction. If we have two transaction doing same things isolation will ensure that both will run seprately

Durability

Durability means that once a transaction has been committed, it will remain so even in the power loss also. In relational database once a group of SQL statement runs the results will be stored permanently even if the database crashes immediately there after. 

Happy Reading

Sanjay

mesanjaybakshi@gmail.com