agdba.com

Column-Stores vs. Row-Stores: How different are they really?

Authors: 
Abadi, Daniel J.; Madden, Samuel R.; Hachem, Nabil

There has been a significant amount of excitement and recent work
on column-oriented database systems (“column-stores”). These
database systems have been shown to perform more than an or-
der of magnitude better than traditional row-oriented database sys-
tems (“row-stores”) on analytical workloads such as those found in
data warehouses, decision support, and business intelligence appli-
cations. The elevator pitch behind this performance difference is
straightforward: column-stores are more I/O efficient for read-only
queries since they only have to read from disk (or from memory)

Year: 
2008
Syndicate content