OLAP Server Implementation
Relational OLAP (ROLAP)
- 3rd-normal form representation is inapplicable due to overhead of processing joins across a very large number of tables
- use a denormalized Star Schema
Multi-dim OLAP (MOLAP)
- store measures of dense dimensions in dense blocks
- represent sparse dimensions by an index