Share
Explore BrainMass

Difference between ROLAP and MOLAP

What is the difference between ROLAP and MOLAP?

This web site should help: http://www.dmreview.com/article_sub.cfm?articleId=1330

Solution Preview

Before looking at difference between ROLAP and MOLAP we will see what ROLAP and MOLAP stands for.

ROLAP stands for Relational Online Analytical Processing

MOLAP stands for Multidimensional Online Analytical Processing.

ROLAP vs MOLAP:

ROLAP and MOLAP analytic tools are designed to allow analysis of data through the use of a multidimensional data model.

1.
MOLAP requires the pre-computation and storage of information in the cube - the operation known as processing. MOLAP stores this data in an optimized multi-dimensional array storage, rather than in a relational database (i.e. in ROLAP)

ROLAP differs significantly in that it does not require the pre-computation and storage of information. Instead, ROLAP tools access ...

Solution Summary

This solution clearly explains the ROLAP and MOLAP and highlights the differences between them.

$2.19