Sign inSign in
ConceptSystems & CS

PAX (partition attributes across)

A storage layout that combines row-based and column-based storage by partitioning data into pages and then storing attributes within those pages in a columnar format.
as Ippokratis Pandis 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.

Columnar storage3Column-oriented storage1Row storage1Row-based storage1Row-oriented storage1

Lecturers

2

Each in their own terms, from the easiest level.

  • Andy Pavlo

    Carnegie Mellon University · Graduate

    A storage format that combines columnar storage with row-based grouping, where all attributes for a tuple are stored in the same file in a columnar layout.
    • 1:03:34Modern OLAP Database Systems
    • 24:35Data Formats & Encoding Part 1

Connections

4

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

Concept1

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.