[prev] 108 [next]

Rows vs Columns

Workload for different operations
  • insert requires more work in CoDbs
    • row: update one page;   column: update multiple pages
  • project comes "for free" in CoDbs
    • row: extract fields from each tuple;   column: merge columns
  • select may require less work in CoDbs
    • row: read whole tuples;   column: read just needed columns
  • join may require less work in CoDbs
    • row: hash join;   column: scan columns for join attributes