Understanding the Difference Between Column-Stores and OLAP Data Cubes

Thursday Jul 10th 2008 by DatabaseJournal.com Staff

A study of how column-stores and data cubes would evaluate a query on a sample database.

[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

Mobile Site | Full Site