Sign inSign in
ConceptSystems & CS

Cost model

An internal cost representation used by the optimizer to estimate and compare the physical execution cost of different query plans given a database state.
as Andy Pavlo defines itCarnegie Mellon UniversityThe wording closest to all 4 definitions
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.

Opens up

Concepts that name this one as a prerequisite.

Lecturers

3

Each in their own terms, from the easiest level.

  • Jignesh Patel

    Carnegie Mellon University · Undergraduate

    A framework used by a database management system to estimate the resource consumption of different query execution plans.
    • 1:04:25Query Planning & Optimization
  • Andy Pavlo

    Carnegie Mellon University · Graduate

    An internal system component used to predict the behavior and compare the relative quality of different query plans given a database state.
    • 43:03SQL Optimization Background
  • Saman Amarasinghe

    MIT · Research

    A mechanism used by a compiler to estimate the performance impact of different code transformations.
    • 8:44Compiler 2.0: Building the Next Generation of Compilers with Machine Learning

Lectures that assume it

10

Connections

24

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

3 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.