Lab 5: Transactions and Concurrency Control

10 abril 2018, 09:30 • Diogo Ribeiro Ferreira

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

Lab 4: Query optimization

6 abril 2018, 11:00 • Diogo Ribeiro Ferreira

Tutorial about query execution and optimization using hints and indexes. Exercises about query equivalence and statistics.

Transaction Management + Concurrency Control

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

• Concurrent Execution of Transactions
  
• Serializability and Testing for Serializability
• Recoverability and Cascading Rollbacks
• Implementation of Isolation
• Possible Anomalies with Concurrent Execution
• Weak Levels of Consistency
• Transaction Definition in SQL
• Concurrency Control
• Lock-Based Protocols

Transaction Management + Concurrency Control

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

• Concurrent Execution of Transactions
  
• Serializability and Testing for Serializability
• Recoverability and Cascading Rollbacks
• Implementation of Isolation
• Possible Anomalies with Concurrent Execution
• Weak Levels of Consistency
• Transaction Definition in SQL
• Concurrency Control
• Lock-Based Protocols

Lab 4: Query optimization

6 abril 2018, 08:00 • Diogo Ribeiro Ferreira

Tutorial about query execution and optimization using hints and indexes. Exercises about query equivalence and statistics.