Sign inSign in
ConceptSystems & CS

Zone maps

Pre-computed aggregates for attribute values in a page that the DBMS checks first to decide whether to access the page.
as Jignesh Patel defines itCarnegie Mellon University
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.

Opens up

Concepts that name this one as a prerequisite.

Lecturers

2

Each in their own terms, from the easiest level.

  • Andy Pavlo

    Carnegie Mellon University · Graduate

    Metadata that stores the minimum and maximum values for a specific column within a data block or row group to allow for data skipping during query execution.
    • 42:08Data Formats & Encoding Part 1

Connections

7

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

Concepts5

Lectures2

2 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.