What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
Answer Posted / p.d.vijay kumar
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 |
Post New Answer View All Answers
How are models actually derived?
What do you mean by static and local variable?
What is the main difference between inmon and kimball philosophies of data warehousing?
Explain which are the olap tools available that are supported by oracle?
How did you plan your Data ware house project?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
How to drill through from a powerplay cube to reportnet?
What is fact less fact table? Where you have used it in your project?
Explain what is partitioning? What are the types of partitioning?
what are different storage options supported by oracle ?
Explain what is metadata reporter?
Explain the definition of normalized and denormalized view and what are the differences between them?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
How to pivot data using informatica when you have variable amount of pivot rows?
Describe a data warehouse.