Skip to content
lectern.tv
CMU 15-799: Query Optimization in Modern Database Systems →0/14
1

SQL Optimization Background

53:57
2

History of Query Optimizers ft. IBM System R

1:10:40
3

IBM Starburst Query Rewriter + Optimizer

1:14:08
4

EXODUS + Volcano Query Optimizer Generators

1:23:28
5

Cascades Query Optimizer

1:27:28
6

Query Plan Transformations

1:20:35
7

Join Ordering: Bottom-up

1:08:22
8

Join Ordering: Top-Down / Transformational

1:10:21
9

Search Parallelization: Bottom-up

59:34
10

Search Parallelization: Top-Down

1:11:32
11

Unnesting Queries

1:14:15
12

Query Cost Models: Statistics

1:14:48
13

Query Cost Models: Cardinality Estimation

1:11:38
14

Query Cost Models: More Cardinality Estimation

1:11:53

History of Query Optimizers ft. IBM System R

Andy PavloDistinguishedCarnegie Mellon University

Professor

1:10:40·2025·graduate level

This session explores the historical evolution of query optimizers, focusing on the seminal contributions and architectural design of IBM System R and its influence on modern database systems.

Systems & CSDatabase SystemsBehavioral & Evolutionary BiologyIBM System RDatabase History

15-799 Special Topics in Database: Query Optimization (Spring 2025) Carnegie Mellon University

Source: CMU Database Group via YouTubeWatch on YouTube
LecturerAll lecturers →
Andy PavloDistinguished

Associate Professor of Databaseology, Carnegie Mellon University

Associate Professor of Computer Science at Carnegie Mellon whose 15-445 and 15-721 courses are the gold standard in database systems architecture.

3 courses · 58 lecturesCanon
Previous · Lecture 1

SQL Optimization Background

Next · Lecture 3

IBM Starburst Query Rewriter + Optimizer

Comments

Add a comment...Sign in