ACID

Stands for

• Atomicity
  • The Database transaction operations are either all successful or none successful
• Consistency
  • Consistent in state, the state of the database at anytime needs to be valid
• Isolation
  • A transaction should not be affected by other concurrently running transaction
• Durability.
  • Once a Database transaction is commited. We should not lose it state, it must persist in the event of a system failure

Are standard for Database/SQL database

[!note]
The C in ACID is different with the C in CAP theorem.

• C in ACID means transaction bring the database from one valid state to another valid state
• C in CAP theorem means all nodes see the same data at the same time