Skip to content
lectern.tv
1/4

OLTP vs. OLAP Storage Models & Database Compression

Andy PavloDistinguishedCarnegie Mellon University

Associate Professor of Databaseology

1:23:25·2023·undergraduate level

Deconstructs NSM row stores vs. DSM columnar formats (Parquet/ORC) and shows how dictionary, run-length, and bit-packing compression allow late-materialization query execution directly on compressed data.

Systems & CSDatabase SystemsColumnar StorageParquetOLAP

Andy Pavlo (https://www.cs.cmu.edu/~pavlo/)

Slides: https://15445.courses.cs.cmu.edu/fall2023/slides/05-storage3.pdf

Notes: https://15445.courses.cs.cmu.edu/fall2023/notes/05-storage3.pdf

LecturerAll lecturers →
Andy PavloDistinguished

Associate Professor of Databaseology, Carnegie Mellon University

Associate Professor of Computer Science at Carnegie Mellon whose 15-445 and 15-721 courses are the gold standard in database systems architecture.

3 courses · 58 lecturesCanon
Previous · Lecture 5

Database Storage II — Log-Structured Merge Trees (LSM) & Tuple Layout

Next · Lecture 7

Buffer Pool Managers, LRU-K Eviction & Direct I/O

Comments

Add a comment...Sign in