![Trending Articles on Technical and Non Technical topics](/images/trending_categories.jpeg)
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Difference Between ROLAP and MOLAP
In this post, we will understand the difference between ROLAP and MOLAP.
ROLAP
It stands for Relational Online Analytical Processing.
It is used for large volumes of data.
The access time in ROLAP is slow.
It stores data in the form of relation tables.
The data in ROLAP is fetched from a data warehouse.
It uses complex SQL queries.
A static multidimensional view of the data is created in ROLAP.
MOLAP
It stands for Multidimensional Online Analytical Processing.
It is used for less/limited volumes of data.
The access time is quick in MOLAP.
Data is stored in a multidimensional array.
Data is fetched from the MDDBs database.
A sparse matrix is used in MOLAP.
Dynamic multidimensional view of the data is created in MOLAP.
Advertisements