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


Please Help Members By Posting Answers For Below Questions

What is data analysis? Where it will be used?

561


How to reduce warnings?

527


Explain is olap databases are called decision support system true/false?

560


How to import vsam files from source to target. Do we need a special plugin?

515


What is metadata in context of a datawarehouse?

551






List any five applications of data warehouse.

555


What are target types on the server?

556


Explain is fact table?

516


How to export mappings to the production environment?

510


Explain what are the basic needs to join two sources in a source qualifier?

522


what is user variable in affinium campaign? and some real time examples.

3696


What are the stages of datawarehousing?

543


what are the all possible features supported modify stage?

1613


What do you mean by static and local variable?

531


What is called dimensional modelling?

582