Sumários

Transaction Management

4 abril 2017, 11:00 • Helena Galhardas

Recapitulating transactions:

  • ACID Properties
  • Concurrent Executions
  • Serializability and Testing for Serializability
  • Recoverability and Cascadeless Schedules
  • Implementation of Isolation
  • Weak Levels of Consistency
  • Transaction Definition in SQL

Transaction Management

4 abril 2017, 11:00 • Helena Galhardas

Recapitulating transactions:

  • ACID Properties
  • Concurrent Executions
  • Serializability and Testing for Serializability
  • Recoverability and Cascadeless Schedules
  • Implementation of Isolation
  • Weak Levels of Consistency
  • Transaction Definition in SQL

Lab5

4 abril 2017, 09:30 • Carlos Mendes

1. Important Concepts 

1.1. Transaction execution in SQL Server.
1.2. Isolation levels and modifying the default locking behavior 
1.3. Details about locking and versioning 
2. Experiments and Exercises 
2.1. A benchmark experiment for SQL Server 
2.2. Exercises

Query Optimization

31 março 2017, 11:00 • Bruno Emanuel Da Graça Martins

1. Exercise on Estimating Join Costs

2. Important Concepts on Query Optimisation

2.1 Basics of query optimization in SQL Server

2.2. Index and column statistics

2.3. Hinting the query optimiser

3. Experiments and Exercises on Query Optimisation

3.1. A benchmark experiment for SQL Server Indexes

3.2. Exercises

4. Support to the Course Project

Query Optimization (cont.)

31 março 2017, 09:30 • Helena Galhardas

  • Catalog Information for Cost Estimation
  • Statistical Information for Cost Estimation
  • Cost-Based Optimization
    • Dynamic Programming for Choosing Evaluation Plans
    • Use of Heuristics 
    • Use of transformation rules.