Transactions
Sequence of indivisible DML requests
- Atomicity
- Consistency
- Isolation
- Durability
Subsystems
- Concurrency Control Management
- Responsible for scheduling the execution of reads and writes on physical objects in a way that ensures transaction isolation
- Recovery Management
- Responsible for enduring transaction atomicity and durability
DML processing is responsible for ensuring the part of the transaction consistency defined by the integrity constraints
Database is a finite set of independent physical objects
- Transaction reads object - Transaction writes object
Transactions