adspace


  1. Categories >> Software >> Data Warehouse >> Data Warehouse General
  2. Suggest New Category

What is the difference between OLAP, ROLAP, MOLAP and HOLAP?

Question Posted / p.d.vijay kumar

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 the purpose of Dataware Control?

1125

Explain how to generate iqd file from framework manager?

1040

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1053

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6097

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2354