Project support

25 maio 2021, 11:00 • Helena Galhardas

Clarification of questions about the project.

Lab Guide 10: Performance Monitoring (aula online)

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

Lab Guide 10:

1. Performance monitoring and performance indicators 
2. Isolating slow running queries using the SQL Profiler 
3. Saving and analyzing the trace as a database table 
4. Generating a trace for tuning 
5. Reorganizing and rebuilding indexes 
6. Using of the query governor configuration option 
7. Check files auto growth frequency 

Q&A about the course project.

Lab 9: Index Tuning (online class)

21 maio 2021, 11: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 

Presentation of research papers

21 maio 2021, 09:30 • Helena Galhardas

Presentation and discussion of the following research papers:

• Alon Y. Halevy, Flip Korn, Natalya Fridman Noy, Christopher Olston, Neoklis Polyzotis, Sudip Roy, Steven Euijong Whang: Goods: Organizing Google's Datasets. SIGMOD Conference 2016: 795-806 
  
• Ron Avnur and Joseph M. Hellerstein. Eddies: Continuously Adaptive Query Processing. SIGMOD, 2000.
  

Presentation of research papers

21 maio 2021, 09:30 • Helena Galhardas

Presentation and discussion of the following research papers:

• Alon Y. Halevy, Flip Korn, Natalya Fridman Noy, Christopher Olston, Neoklis Polyzotis, Sudip Roy, Steven Euijong Whang: Goods: Organizing Google's Datasets. SIGMOD Conference 2016: 795-806 
  
• Ron Avnur and Joseph M. Hellerstein. Eddies: Continuously Adaptive Query Processing. SIGMOD, 2000.