What is the difference between ROLAP and MOLAP?
This web site should help: http://www.dmreview.com/article_sub.cfm?articleId=1330
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.
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 ...
This solution clearly explains the ROLAP and MOLAP and highlights the differences between them.