ConceptSystems & CS
Relational algebra
A procedural query language consisting of fundamental operators used to query and manipulate relations.
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
2Each in their own terms, from the easiest level.
Andy Pavlo
Martin Atzmueller
A formal system of relational operators working with relations as sets of tuples.
Lectures that assume it
22The first 12 are shown.
- Query Planning & Optimization
- History of Query Optimizers ft. IBM System R
- Sorting & Aggregation Algorithms
- User-Defined Function Optimizations
- Query Optimizer Implementation 2
- Query Cost Models: Statistics
- IBM Starburst Query Rewriter + Optimizer
- Query Execution & Processing Part 2
- Concurrency Control Theory
- Database Networking Protocols
- EXODUS + Volcano Query Optimizer Generators
- Unnesting Queries
Connections
33The lectures that define it or assume it, and the concepts next to it.
Concepts8
Show 2 moreShow fewer
Lectures25
- The Relational Model & Relational Algebra
- Modern SQL — Window Functions, CTEs & Bag Semantics
- A Brief Perspective on Deep Learning Using Common Lisp
- Query Planning & Optimization
- History of Query Optimizers ft. IBM System R
- Sorting & Aggregation Algorithms
Show 19 moreShow fewer
- User-Defined Function Optimizations
- Query Optimizer Implementation 2
- Query Cost Models: Statistics
- IBM Starburst Query Rewriter + Optimizer
- Query Execution & Processing Part 2
- Concurrency Control Theory
- Database Networking Protocols
- EXODUS + Volcano Query Optimizer Generators
- Unnesting Queries
- Query Scheduling & Coordination
- Multi-Way Join Algorithms / Worst-Case Optimal Joins
- Query Optimizer Implementation 1
- SQL Optimization Background
- Query Plan Transformations
- Join Ordering: Bottom-up
- Yellowbrick Data Warehouse System
- Search Parallelization: Top-Down
- Query Execution Part 1
- Query Execution Part 2