Sumários
Lab 6
18 abril 2017, 09:30 • Carlos Mendes
1. Important Concepts
1.1. Transaction Logs and Recovery in SQL Server
1.2. WAL and ARIES-like logging and recovery scheme
1.3. SQL Server Restore Recovery Models
1.4. Disaster Recovery in SQL Server
2. Experiments and Exercises
2.1 Some Examples on Database BackupsTransaction Execution in SQL Server
7 abril 2017, 11:00 • Bruno Emanuel Da Graça Martins
1. Exercises about Query Optimization (cont.)
Concurrency Control
7 abril 2017, 09:30 • Helena Galhardas
Lock-Based Protocols for Concurrency Control
- Two-phase locking, strict two-phase locking, and rigorous two-phase locking
- Implementation of Locking
- Deadlock handling (prevention strategies, deadlock detection and deadlock recovery)
- Intention locks
- 2PL variant for intention locks.
Concurrency Control
7 abril 2017, 09:30 • Helena Galhardas
Lock-Based Protocols for Concurrency Control
- Two-phase locking, strict two-phase locking, and rigorous two-phase locking
- Implementation of Locking
- Deadlock handling (prevention strategies, deadlock detection and deadlock recovery)
- Intention locks
- 2PL variant for intention locks.
Transaction Execution in SQL Server
7 abril 2017, 08:00 • Bruno Emanuel Da Graça Martins
1. Exercises about Query Optimization (cont.)