What are ACID Properties? #3630
-
|
What are ACID Properties? |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
|
ACID properties ensure that database transactions are processed reliably. A – Atomicity A transaction is completed entirely or not at all. Example: Transferring money between bank accounts should not withdraw money without depositing it. C – Consistency The database moves from one valid state to another while respecting all rules and constraints. I – Isolation Multiple transactions running at the same time should not interfere with one another. D – Durability Once a transaction is committed, it remains saved even if the server crashes. |
Beta Was this translation helpful? Give feedback.
ACID properties ensure that database transactions are processed reliably.
A – Atomicity
A transaction is completed entirely or not at all.
Example:
Transferring money between bank accounts should not withdraw money without depositing it.
C – Consistency
The database moves from one valid state to another while respecting all rules and constraints.
I – Isolation
Multiple transactions running at the same time should not interfere with one another.
D – Durability
Once a transaction is committed, it remains saved even if the server crashes.