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
What is data analysis? Where it will be used?
How to reduce warnings?
Explain is olap databases are called decision support system true/false?
How to import vsam files from source to target. Do we need a special plugin?
What is metadata in context of a datawarehouse?
List any five applications of data warehouse.
What are target types on the server?
Explain is fact table?
How to export mappings to the production environment?
Explain what are the basic needs to join two sources in a source qualifier?
what is user variable in affinium campaign? and some real time examples.
What are the stages of datawarehousing?
what are the all possible features supported modify stage?
What do you mean by static and local variable?
What is called dimensional modelling?