What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
- 2 Answers
- 43508 Views
- I also Faced
- E-Mail Answers
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 |
How to calculate fact table granularity?
Why should you put your data warehouse on a different system than your oltp system?
Explain is olap databases are called decision support system true/false?
Why should we use data ware housing and how can you extract data for analysis with example?
Compare cold fusion with other programming languages?
What does level of granularity of a fact table signify?
Why fact table is in a normal form?
Define data warehouse?
What is a hash cluster?
What is real-time datawarehousing?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
Is there any default username & pwd for bo designer & supervisor?
Teradata 
