Sign inSign in
ConceptSystems & CS

Materialized view

A database object that stores the result of a query, allowing for faster access than recomputing the query.
as Andy Pavlo defines itCarnegie Mellon UniversityThe wording closest to all 3 definitions
Watch it explained

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.

SQL queries2Aggregation1Base tables1Caching1Database1Database caching1Database query1Query1

Opens up

Concepts that name this one as a prerequisite.

Lecturers

3

Each in their own terms, from the easiest level.

  • Owen Xiao

    Carnegie Mellon University · Undergraduate

    Pre-computed table views used to avoid repeating expensive aggregations and sorts.
    • 17:34Apache Doris: Real-Time Analytics and Search Database for AI Agents
  • Martin Kleppmann

    University of Cambridge · Graduate

    A cache of the result of some query that is updated when underlying data changes.
    • 8:36Thinking in Events: From Databases to Distributed Collaboration Software

Lectures that assume it

2

Connections

10

The lectures that define it or assume it, and the concepts next to it.

3 lecturers. Definitions are written by AI from each lecture’s transcript. A time with a play mark starts the lecture at the moment the lecturer says it.