Enseignements
Database tuning and optimisation (M1)
- course description
- lecture notes:
- slides for Database Systems: The Complete Book (by courtesy of Prof. J.D. Ullman)
- CS245 from Stanford University (by courtesy of Prof. H. Garcia-Molina)
- project
lesson | subject | material |
---|---|---|
1 | data organisation | exercises |
2 | indexing (B-TREEs) | exercises |
3 | indexing (Hashing) | exercises |
4 | query evaluation & optimisation (logical query plan & cost) | exercises |
5 | query evaluation & optimisation (physical plan selection) | exercises |