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 |
Explain what is the difference between power center & power mart?
Explain the difference between view and materialized view?
State any 5 of Cods guidelines of an OLAP system, brief description each?
How much data hold in one universe.
Best Data Ware housing training institute in delhi
How to provide security in frame work manager for a query subject?
How we are using this function?
Explain where do we use semi and non additive facts?
What is the difference between datawarehouse and bi?
What is a staging area? Do we need it? What is the purpose of a staging area?
What is bi?
wht is degenerated dimension ?it's uses?