Back to the Club's homepage
Data Base internals and Cost Based Optimizer (CBO) - Meir Maor
Abstract
- How is data stored in the DB, How are indexes(indices) built and how they differ from your classical B-trees learned in a data-structure course.
- What are the diffrent access paths available for the DB to access the data, how does a CBO choose the most efficent path, when is it worng?
- Compare and contrast Oracle with Postgres. in these regards.
The lecture would be high level, and require basic knowledge of SQL and the conscept of Balanced trees.
Lecture slides in Open Document Presentation
format
or Portable Document Format (PDF)
Back to the Club's homepage