Decomposition storage model (DSM)

The DBMS stores the values of a single attribute for all tuples contiguously in a page

-> Also known as a "column store"

Ideal for OLAP workloads where read-only queries perform large scans over a subset of the table's attributes.

Advantages

  • Reduce the amount wasted I/O because the DBMS only reads the data that it needs

  • Better query processing and data compression (more on this later)

Disadvantages

Slow for pointer queries, inserts, updates, and deletes because of tuple splitting/stitching

PreviousN-ARY STORAGE MODEL (NSM)NextTuple Identification

Last updated