ConceptSystems & CS
Relational model
A data model that presents information to be stored and retrieved in rows and columns.
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
1Andy Pavlo
Lectures that assume it
10- Database Storage I — Volatile vs. Non-Volatile Hierarchy & Slotted Pages
- History of Query Optimizers ft. IBM System R
- IBM Starburst Query Rewriter + Optimizer
- Lakebases & LTAP: Unifying Transactions and Analytics on Open Object Storage
- B+Tree Indexes
- EXODUS + Volcano Query Optimizer Generators
- JIT Query Compilation & Code Generation
- Data Formats & Encoding Part 2
- Join Algorithms
- SpacetimeDB: Inverting the Backend - Why We Built Our MMORPG Inside a Database
Connections
19The lectures that define it or assume it, and the concepts next to it.
Concepts7
Show 1 moreShow fewer
Lectures12
- The Relational Model & Relational Algebra
- Modern SQL — Window Functions, CTEs & Bag Semantics
- Database Storage I — Volatile vs. Non-Volatile Hierarchy & Slotted Pages
- History of Query Optimizers ft. IBM System R
- IBM Starburst Query Rewriter + Optimizer
- Lakebases & LTAP: Unifying Transactions and Analytics on Open Object Storage