ACID Properties
A transaction is a sequence of operations performed as a single logical unit.
ACID
Atomicity
All or nothing - either all operations complete or none do.
0:00
0% complete
LearnStep 1 of 2
ACID Properties
Learning Objectives
- •Understand ACID properties
- •Apply transaction concepts
Lesson Outline
LearnStep 1/2
ACID Properties
sql
Consistency
Database moves from one valid state to another valid state.
- Constraints are maintained
- Business rules are preserved
Isolation
Concurrent transactions don't interfere with each other.
Durability
Once committed, changes persist even after system failure.
- Write-ahead logging (WAL)
- Transaction logs