What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
- 2 Answers
- 42308 Views
- I also Faced
- E-Mail Answers
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
What is difference between query studio and report studio?
What are the types of dimensional modeling?
What is factless fact tables?
Explain normalization?
What is Sequence clustering algorithm?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
Explain difference between e-r modeling and dimentional modeling?
What is your spectra photometer working principles?
Explain what are the methodologies of data warehousing?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
What are target types on the server?
What are the various methods of getting incremental records or delta records from the source systems?
What are the difference between snow flake and star schema?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
What is the difference between a primary and secondary actor in use case modeling?
