ConceptSystems & CS
Query plan
A Directed Acyclic Graph (DAG) of relational operators.
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
1Lectures that assume it
25The first 12 are shown.
- History of Query Optimizers ft. IBM System R
- Query Optimizer Implementation 2
- Query Cost Models: Statistics
- IBM Starburst Query Rewriter + Optimizer
- Buffer Pool Managers, LRU-K Eviction & Direct I/O
- Modern OLAP Database Systems
- Query Execution & Processing Part 1
- Query Execution & Processing Part 2
- DuckDB Embedded Database System
- EXODUS + Volcano Query Optimizer Generators
- Cascades Query Optimizer
- Unnesting Queries
Connections
33The lectures that define it or assume it, and the concepts next to it.
Concepts7
- Query optimization
- Relational algebra
- Distributed query execution
- Exchange operator
- Expression
- Heuristic-based optimization
Show 1 moreShow fewer
Lectures26
- Query Scheduling & Coordination
- History of Query Optimizers ft. IBM System R
- Query Optimizer Implementation 2
- Query Cost Models: Statistics
- IBM Starburst Query Rewriter + Optimizer
- Buffer Pool Managers, LRU-K Eviction & Direct I/O
Show 20 moreShow fewer
- Modern OLAP Database Systems
- Query Execution & Processing Part 1
- Query Execution & Processing Part 2
- DuckDB Embedded Database System
- EXODUS + Volcano Query Optimizer Generators
- Cascades Query Optimizer
- Unnesting Queries
- Query Cost Models: Cardinality Estimation
- Query Cost Models: More Cardinality Estimation
- Distributed Data Warehouse OLAP Databases
- JIT Query Compilation & Code Generation
- Query Optimizer Implementation 1
- SQL Optimization Background
- Join Ordering: Bottom-up
- Vectorized Query Execution Using SIMD
- Parallel Hash Join Algorithms
- Databricks Photon / Spark SQL
- SingleStore Database Overview
- Query Execution Part 1
- Query Execution Part 2