Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

Difference between ROLAP and MOLAP

  • Difficulty Level : Medium
  • Last Updated : 27 May, 2019

Relational Online Analytical Processing (ROLAP):
ROLAP is used for large data volumes and in this data is stored in relation tables. In ROLAP, Static multidimensional view of data is created.





Multidimensional Online Analytical Processing (MOLAP):
MOLAP is used for limited data volumes and in this data is stored in multidimensional array. In MOLAP, Dynamic multidimensional view of data is created.





The main difference between ROLAP and MOLAP is that, In ROLAP, Data is fetched from data-warehouse. On the other hand, in MOLAP, Data is fetched from MDDBs database. The common term between these two is OLAP.

Let’s see the difference between ROLAP and MOLAP:

S.NOROLAPMOLAP
1.ROLAP stands for Relational Online Analytical Processing.While MOLAP stands for Multidimensional Online Analytical Processing.
2.ROLAP is used for large data volumes.While it is used for limited data volumes.
3.The access of ROLAP is slow.While the access of MOLAP is fast.
4.In ROLAP, Data is stored in relation tables.While in MOLAP, Data is stored in multidimensional array.
5.In ROLAP, Data is fetched from data-warehouse.While in MOLAP, Data is fetched from MDDBs database.
6.In ROLAP, Complicated sql queries are used.While in MOLAP, Sparse matrix is used.
7.In ROLAP, Static multidimensional view of data is created.While in MOLAP, Dynamic multidimensional view of data is created.

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!