Sign inSign in
ConceptSystems & CS

System R optimizer

A pioneering cost-based, bottom-up query optimizer that serves as the foundation for most modern database optimizers.
as Jignesh Patel defines itCarnegie Mellon University
Watch it explained

Know first

Named as a prerequisite by the lectures that define this. The number is how many say so. A grey one has no page yet.

Cost-based optimization1Dynamic programming1Generative / bottom-up approach1Join algorithms1Join ordering1Query optimization1

Lecturers

2

Each in their own terms, from the easiest level.

  • Andy Pavlo

    Carnegie Mellon University · Graduate

    A bottom-up optimizer that breaks queries into blocks, generates logical and physical operators, and constructs a left-deep join tree minimizing estimated work.
    • 30:20Query Optimizer Implementation 1

Connections

4

The lectures that define it or assume it, and the concepts next to it.

Concepts2

Lectures2

2 lecturers. Definitions are written by AI from each lecture’s transcript. A time with a play mark starts the lecture at the moment the lecturer says it.