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 Backups


Transaction Execution in SQL Server

7 abril 2017, 11:00 Bruno Emanuel Da Graça Martins

1. Exercises about Query Optimization (cont.)

2. Important Concepts about Transaction Execution
2.1. Transaction execution in SQL Server
2.2. Isolation levels and modifying the default locking behaviour
2.3. Details about locking and versioning
3. Experiments and Exercises
3.1. A benchmark experiment for SQL Server
3.2. Exercises


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)
Multiple Granularity:
  • Intention locks
  • 2PL variant for intention locks.
Timestamp-Based Protocols


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)
Multiple Granularity:
  • Intention locks
  • 2PL variant for intention locks.
Timestamp-Based Protocols


Transaction Execution in SQL Server

7 abril 2017, 08:00 Bruno Emanuel Da Graça Martins

1. Exercises about Query Optimization (cont.)

2. Important Concepts about Transaction Execution
2.1. Transaction execution in SQL Server
2.2. Isolation levels and modifying the default locking behaviour
2.3. Details about locking and versioning
3. Experiments and Exercises
3.1. A benchmark experiment for SQL Server
3.2. Exercises