ConceptSystems & CS
Materialized view
A database object that stores the result of a query, allowing for faster access than recomputing the query.
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
3Each in their own terms, from the easiest level.
Owen Xiao
Pre-computed table views used to avoid repeating expensive aggregations and sorts.Martin Kleppmann
A cache of the result of some query that is updated when underlying data changes.
Lectures that assume it
2Connections
10The lectures that define it or assume it, and the concepts next to it.