The id column and row header (as depicted in the post) can significantly waste I/O bandwidth.
See the paper "Column-stores vs. row-stores: how different are they really?" in SIGMOD 2008 for performance comparisons between C-store and approaches of emulating column-store in row-store databases.
Comments
The id column and row header (as depicted in the post) can significantly waste I/O bandwidth.
See the paper "Column-stores vs. row-stores: how different are they really?" in SIGMOD 2008 for performance comparisons between C-store and approaches of emulating column-store in row-store databases.