Concurrency Control (Cont.)

13 abril 2018, 09:30 • Bruno Emanuel Da Graça Martins

• Timestamp-Based Protocols (Including Thomas’ Write Rule)
  
• Multiversion Schemes
• Snapshot Isolation and the Skew Write Anomaly
• Insert and Delete Operations (Avoiding Phantom Reads)
• Associate a Data Item with the Relation
• Index Locking Protocol
• Next-Key Locking

Lab 5: Transactions and Concurrency Control

13 abril 2018, 08:00 • Diogo Ribeiro Ferreira

Tutorial about concurrent transactions and isolation levels in SQL Server. Exercises about serializability, lock-based protocols, and timestamp-based protocols.

Lab 5: Transactions and Concurrency Control

10 abril 2018, 12:30 • Diogo Ribeiro Ferreira

Tutorial about concurrent transactions and isolation levels in SQL Server. Exercises about serializability, lock-based protocols, and timestamp-based protocols.

Concurrency Control

10 abril 2018, 11:00 • Bruno Emanuel Da Graça Martins

• Lock-Based Concurrency Control Protocols
  
• Regular, Strict and Rigorous Two-Phase Locking
• Pitfalls of Lock-Based Protocols
• Lock Conversions
• Automatic Acquisition of Locks
• Implementation of Locking
• Deadlock Handling
• Deadlock prevention (wait-die and wound-wait schemes)
• Deadlock detection
• Multiple Granularity Locking Scheme
• Timestamp-Based Protocols

Concurrency Control

10 abril 2018, 11:00 • Bruno Emanuel Da Graça Martins

• Lock-Based Concurrency Control Protocols
  
• Regular, Strict and Rigorous Two-Phase Locking
• Pitfalls of Lock-Based Protocols
• Lock Conversions
• Automatic Acquisition of Locks
• Implementation of Locking
• Deadlock Handling
• Deadlock prevention (wait-die and wound-wait schemes)
• Deadlock detection
• Multiple Granularity Locking Scheme
• Timestamp-Based Protocols