Understanding the Difference Between Column-Stores and OLAP Data Cubes

July 10, 2008

[From The Database Column]

Both column-stores and data cubes are designed to provide high performance on analytical database workloads (often referred to as Online Analytical Processing, or OLAP.) These workloads are characterized by queries that select a subset of tuples, and then aggregate and group along one or more dimensions.

The article continues at http://www.databasecolumn.com/2008/07/understanding-the-difference-b.html