Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
- 2 Answers
- 43295 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 |
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What is a full backup?
Explain in detail abt measure objects? And what is the use of it? How to create it?
Give me a broad concept of what a data warehouse is, and what it might be used for?
Where the data cube technology is used?
where exactly in dataware house a confirmed dimension can be created
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
Explain what is the difference between olap and datawarehosue?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
Where the applications and where ware house management system is used?
What is the difference between drill through and masterdetail reports?
Explain normalization?
Teradata 
