F2023 #05 - Storage Models & Database Compression (CMU Intro to Database Systems)
CMU Database Group · 83:25
Row-oriented (NSM) storage is ideal for OLTP point lookups and single-tuple updates, but it wastes I/O, CPU, and money on OLAP scans that only need a few columns; column stores (DSM) and the hybrid PAX layout fix that...