HomeToolsAbout

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.

If one part of a transaction doesn't work like it's supposed to, the other will fail also.

Consistency

Only data which follows defined 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

AboutContact