data-warehouse

Data Cube

OLAP Data Cube

The data cube is a tool to model data points using multiple dimensional axes. Each axes represents an aggregation criteria, such as “sex” or “date”.

A 2D example of the data cube could be the following. It has two dimensional axes:

  • dim_sex: Male or Female
  • dim_date: a day

Each point in the plane represent a value (or a value tuple). Therefore, the combination of an dim_date and dim_sex coordinate identifies a value uniquely.