HomeToolsAbout a20k

ACID

What is it

Atomicity, Consistency, Isolation, and Durability (ACID)

Used to ensure that a database  transaction is completed in a timely manner

Atomicity

  • database transactions can be broken down to smaller parts
  • atomicity refers to the integrity of the entire database transaction, not just a component of it.
  • In other words, if one part of a transaction doesn't work like it's supposed to, the other will fail as a result.

Consistency

  • Only data which follows those rules is permitted to be written to the database.

Isolation

  • Huge amount of data will simultaneously interact with the database.
  • Isolation refers to the ability to concurrently process multiple transaction in a way that one does not affect another

Durability

  • All technology fail from time to time...the goal is to make those failures invisible to the end-user.
  • In a database that possess durability, data is saved once a transaction is completed, even if a power outage or system failure occurs
© VincentVanKoh