Sumários
Recovery Management (cont.)
23 abril 2021, 09:30 • Helena Galhardas
- Recovery, Atomicity and Durability
- Recovery based on Log
- Aries algorithm: detailed description of the three phases of the algorithm - analysis, redo and undo.
Recovery Management (cont.)
23 abril 2021, 09:30 • Helena Galhardas
- Recovery, Atomicity and Durability
- Recovery based on Log
- Aries algorithm: detailed description of the three phases of the algorithm - analysis, redo and undo.
Lab 5: Transactions and Concurrency Control (aula online)
23 abril 2021, 08:00 • Carlota de Oliveira Lopes Dias
Lab Guide 5:
- Exercise 2.1 (SQL Server): Benchmarking to test transaction isolation levels
- Exercise 2.2.1 (pencil & paper): Serializability, precedence graphs, 2PL protocol.
- Exercise 2.2.2 (pencil & paper): 2PL protocol and deadlocks.
Lab 5: Transactions and Concurrency Control (online class)
20 abril 2021, 12:30 • João Tiago Aparício
Lab Guide 5:
- Exercise 2.1 (SQL Server): Benchmarking to test transaction isolation levels
- Exercise 2.2.1 (pencil & paper): Serializability, precedence graphs, 2PL protocol.
- Exercise 2.2.2 (pencil & paper): 2PL protocol and deadlocks.
Concurrency Control (cont.) and Recovery Management
20 abril 2021, 11:00 • Helena Galhardas
Concurrency control:
- Multiversion schemes: Multiversion timestamp ordering
- Snapshot isolation:
- First-committer-wins rule
- First-updater-wins rule
- Skew write.
- Failure Classification
- Storage Structure
- Recovery, Atomicity and Durability
- Recovery based on Log: brief introduction.