What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
Answers were Sorted based on User's Feedback
ROLAP
ROLAP stands for Relational Online Analytical Process that
provides multidimensional analysis of data, stored in a
Relational database(RDBMS).
MOLAP
------
MOLAP(Multidimensional OLAP), provides the analysis of data
stored in a multi-dimensional data cube.
HOLAP
------
HOLAP(Hybrid OLAP) a combination of both ROLAP and MOLAP can
provide multidimensional analysis simultaneously of data
stored in a multidimensional database and in a relational
database(RDBMS).
DOLAP
-----
DOLAP(Desktop OLAP or Database OLAP)provide multidimensional
analysis locally in the client machine on the data collected
from relational or multidimensional database servers.
| Is This Answer Correct ? | 69 Yes | 10 No |
Answer / guest
OLAP: Online analytical process. For analysis.
ROLAP: Relational Online analytical processing.
MOLAP: Multi dimensional analytical process.
HOLAP: Hybrid Online analytical process.
| Is This Answer Correct ? | 41 Yes | 14 No |
Difference between e-r modeling and dimentional modeling?
capital of tamilnadu
What is the definition of cube in datawarehousing?
How to provide security in frame work manager for a query subject?
Explain what are necessary tasks to install reportnet software?
What according to you might be the future of data warehousing?
What is data validation strategies for data mart v?
what is difference between Independent Data Mart Dependent Data Mart 1- 1- 2- 2- 3- 3- 4- 4-
Name at least three brands of Database Management Systems
Difference between ODS and Staging
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
Data WareHousing course in noida