Dimensional Data Modeling - OLAP Cube

About

An OLAP cube is a dimensional data structure that answer dimensional query. It store data in a multidimensional way. You can a cube as an extension of the two dimensions relational table.

Creation

A cube is defined:

  • its dimension (and hierarchy)
  • and measures (calculation)

and is generally pre-computed.

Computation

The OLAP cube consists of numeric facts called measures which are categorized by dimensions. The cube metadata may be created from a star schema or snowflake_schema of tables in a relational database. Measures are derived from the records in the fact table and dimensions are derived from the dimension tables.


Powered by ComboStrap