ACID RDBMS
Atomicity: In a sequence of steps either all actions occur or
none.
Example: Moving money from savings to checking accounts.
Consistency: The database is transformed from one valid
state to another valid state.
Example: If someone moves 10,000$ from their checking
account that information is logged. If it can't be logged then
the money is not transferred.
Isolation:
The results of a transaction are invisible to other
transactions until the transaction is complete.
Example: If someone an accountant starts a report at 1700
and Joe User deposits 100$ into their account at 1701. The
report, even if it finishes at 1702 will not show the changes
made by Joe User.
Durability: Once committed (completed), the results of a
transaction are permanent and survive future system and media
failures.
Example: Once your seat is reserved on an airplane, even
if the system crashes the moment it finishes writing that information
in the database your seat will still be reserved.
tristancohen@yahoo.com