Sign inSign in
ConceptSystems & CS

Early materialization

Copy the values for the attributes in outer and inner tuples into a new output tuple immediately.
as Matt Butrovich 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.

Query execution2Buffer pool1Join1Join operator1Key-value pair1Tuple1Tuple representation1

Opens up

Concepts that name this one as a prerequisite.

Lecturers

3

Each in their own terms, from the easiest level.

  • Jignesh Patel

    Carnegie Mellon University · Undergraduate

    Storing both the key and the entire tuple data together in intermediate files during sorting passes.
    • 23:12Sorting & Aggregation Algorithms
  • Andy Pavlo

    Carnegie Mellon University · Graduate

    A strategy where all required attributes of a tuple are combined into a single row as early as possible in the query plan.
    • 37:48Query Execution & Processing Part 2

Connections

8

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

Concepts5

Lectures3

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.