Last Lab

1 junho 2021, 09:30 • João Tiago Aparício

Q&A about the project and exam.

Presentation of research papers

28 maio 2021, 09:30 • Helena Galhardas

Presentation and discussion of the following research papers:

• Hongjun Lu, Ming-Chien Shan, Kian-Lee Tan: Optimization of Multi-Way Join Queries for Parallel Execution. VLDB 1991: 549-560
  
• C. Mohan, Bruce G. Lindsay, Ron Obermarck: Distributed Transaction R* Management System. ACM Trans. Database Syst. 1986
• Venky Harinarayan, Anand Rajaraman, Jeffrey D. Ullman. Implementing Data Cubes Efficiently. SIGMOD, 1996.
  

Presentation of research papers

28 maio 2021, 09:30 • Helena Galhardas

Presentation and discussion of the following research papers:

• Hongjun Lu, Ming-Chien Shan, Kian-Lee Tan: Optimization of Multi-Way Join Queries for Parallel Execution. VLDB 1991: 549-560
  
• C. Mohan, Bruce G. Lindsay, Ron Obermarck: Distributed Transaction R* Management System. ACM Trans. Database Syst. 1986
• Venky Harinarayan, Anand Rajaraman, Jeffrey D. Ullman. Implementing Data Cubes Efficiently. SIGMOD, 1996.
  

Lab Guide 10: Performance Monitoring (aula online)

25 maio 2021, 12: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.

Project support

25 maio 2021, 11:00 • Helena Galhardas

Clarification of questions about the project.