Sumários
Clarification of students' questions
30 maio 2017, 11:00 • Helena Galhardas
Clarification of students' questions regarding all topics taught.
Performance Monitoring
26 maio 2017, 11:00 • Bruno Emanuel Da Graça Martins
1. Performance monitoring and performance indicators
2. Isolating slow running queries using the SQL Profiler
3. Reorganising and rebuilding indexes
4. Checking files auto-growth frequency
5. Using of the query governor configuration option
Distributed Databases (cont.) and Parallel Databases
26 maio 2017, 09:30 • Helena Galhardas
Distributed Databases:
- Distributed Query Processing
- Updating Distributed Data
- Introduction
- Parallel DBMS Architectures
- Speed-Up versus Scale-Up
- Pipeline parallelism versus Partition Parallelism
- Automatic Data Partitioning
- Intra-operator parallelism
- Parallel Sorting
- Parallel Aggregates
- Parallel Joins
- Inter-operator parallelism
Distributed Databases (cont.) and Parallel Databases
26 maio 2017, 09:30 • Helena Galhardas
Distributed Databases:
- Distributed Query Processing
- Updating Distributed Data
- Introduction
- Parallel DBMS Architectures
- Speed-Up versus Scale-Up
- Pipeline parallelism versus Partition Parallelism
- Automatic Data Partitioning
- Intra-operator parallelism
- Parallel Sorting
- Parallel Aggregates
- Parallel Joins
- Inter-operator parallelism