Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
- 2 Answers
- 43413 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 |
What is crass reference table?
Explain what is a view as it relates to system modeling?
Database in use is oracle?
What is Cognos script editor?
What is the very basic difference between data warehouse and operational databases?
How to define a cube??
How to limit the max no of rows retrieved in the report?
What is the use of incremental aggregation? Explain me in brief with an example?
How many types of facts and what are they?
What is perform recovery?
Explain er diagram?
What is the purpose of Dataware Control?
Teradata 
