What is ACID ( Atomicity, Consistency, Isolation, Durability)? — Parv The IT Geek

Atomicity — this basically means the transaction works or doesn’t and is sometimes called the “all or nothing” rule. I always liken it to an Atomic bomb because they either work or fail. A failed transaction would then enter a state of rollback.

Consistency — this means only valid data is written to the database. This means if the constraints, keys….. are violated the data would not be committed.

Isolation — this means that multiple transactions should not impact other transactions which are occurring simultaneously.

Durability — this means when a transaction is successful all the pending changes are applied to the database.


Originally published at https://parvtheitgeek.com on January 8, 2014.

Published by Parvinder Nijjar

I blog at ParvTheITGeek.com

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

<span>%d</span> bloggers like this: