Thursday, August 8, 2013

Storage modes in SQL Server Analysis Services

Cube data divided into meta data, detail data and aggregated data.
ROLAP stands for Relational Online Analytical Processing,
Cube only  builds model. Its having only meta data. Detail and aggregated data in relational database.
MOLAP stands for Multidimensional OLAP,  Cube with meta data, detailed data and aggregated data.
HOLAP stands for Hybrid OLAP, Cube with meta data and aggregated data. Detail data in relational database.

For more information visit this link
http://www.slideshare.net/umarali1981/difference-between-molap-rolap-and-holap-in-ssas

No comments:

Post a Comment