R* Optimizer Validation and Performance Evaluation for Distributed Queries

90-minute presentation for the Advanced topics in Data Management course at KAUST, on "R* Optimizer Validation and Performance Evaluation for Distributed Queries" by Mackert et al, published in VLDBJ '86.

Transcript

1. R* Optimizer Validation and Performance Optimization for Distributed Queries Lothar F. Mackert, Guy M. Lohman IBM Almdaden Research Centre
2. Introduction
3. R*
4. Query Optimisation
5. Distributed Query Optimisation
6. Cost Function
7. Tasks
8. Questions to Answer
9. Distributed Joins
10. Inner Table Transfer Strategy
13. Distributed VS Local
15. Relative Cost Importance
18. Optimiser Evaluation
19. Alternative Distributed Join Methods
20. High Speed Medium Speed
23. Other Parameters