Sign inSign in
ConceptSystems & CS

Sequential scan

Scanning through large chunks of data sequentially without using index lookups.
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.

Access methods1Buffer pool1Database systems1OLAP1Storage engine1

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

    • 0:57Data Formats & Encoding Part 1
  • Jignesh Patel

    Carnegie Mellon University · Undergraduate

    A sequential scan retrieves pages from the buffer pool and iterates over each tuple to check whether to include it, maintaining an internal cursor.
    • 34:49Query Execution Part 1

Lectures that assume it

3

Connections

13

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.