Lab 9: Index Tuning (online class)

21 maio 2021, 08:00 • Carlota de Oliveira Lopes Dias

Index tuning with the Database Tuning Advisor (DTA). 

Analysing and implementing the DTA recommendations. Pencil-and-paper exercise about choosing the best indices for given queries. 
Clarification of doubts for the course project 

Lab 9: Index Tuning (aula online)

18 maio 2021, 12:30 • João Tiago Aparício

Index tuning with the Database Tuning Advisor (DTA). 

Analysing and implementing the DTA recommendations. Pencil-and-paper exercise about choosing the best indices for given queries. 
Clarification of doubts for the course project   

Presentation of research papers

18 maio 2021, 11:00 • Helena Galhardas

Presentation and discussion of the following research papers:

• Michael J. Cafarella, Alon Halevy, Daisy Zhe Wang, Eugene Wu, Yang Zhang. WebTables: Exploring the Power of Tables on the Web. VLDB, 2008
  
• Goetz Graefe and William J. McKenna. The Volcano Optimizer Generator: Extensibility and Efficient Search. ICDE, 1993.
  

Presentation of research papers

18 maio 2021, 11:00 • Helena Galhardas

Presentation and discussion of the following research papers:

• Michael J. Cafarella, Alon Halevy, Daisy Zhe Wang, Eugene Wu, Yang Zhang. WebTables: Exploring the Power of Tables on the Web. VLDB, 2008
  
• Goetz Graefe and William J. McKenna. The Volcano Optimizer Generator: Extensibility and Efficient Search. ICDE, 1993.
  

Lab 9: Index Tuning (aula online)

18 maio 2021, 09:30 • João Tiago Aparício

Index tuning with the Database Tuning Advisor (DTA). 

Analysing and implementing the DTA recommendations. Pencil-and-paper exercise about choosing the best indices for given queries. 
Clarification of doubts for the course project