05 - Columnar Databases & Compression (CMU Intro to Database Systems / Fall 2022)
CMU Database Group · 82:29
Row-oriented (NSM) storage is ideal for OLTP because each query usually needs most columns of a few tuples, but it wastes disk I/O on unused attributes during OLAP table scans; column-oriented (DSM) storage plus nativ...