Sign inSign in
ConceptSystems & CS

Vectorization model

A query processing model where each operator emits a batch of tuples instead of a single tuple, utilizing tight for-loops over arrays for hardware efficiency.
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.

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 · Undergraduate

    A query processing model that takes advantage of pipelining by passing vectors of tuples up the operator tree without writing intermediate results to disk.
    • 24:35SQL Optimization Background
  • Jignesh Patel

    Carnegie Mellon University · Undergraduate

    An execution model where each operator processes and emits a batch of tuples at a time rather than a single tuple or the entire table.
    • 23:30Query Execution Part 1

Connections

7

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

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.