What is Molap and Rolap? What is Diff between Them?

Answer Posted / pratap gangula

Hi Marcelo,

The retrieval procedure is different because the storage model is different so ultimately the main difference between ROLAP and MOLAP is still in the storage concepts. While designing DW we dont decide whether the requirement is to fetch the data using SQL or MDX....rather we focus on whether the need for storing the data is in RDBMS format or Multidimensional format .

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is the difference between a primary and secondary actor in use case modeling?

647


How to know the time taken for particular report execution?

510


in general which algorithms for used?

1539


Explain ddl (data definition language)?

563


How much data hold in one universe.

542






Explain what are the various reporting tools in the market?

540


What is many-to-many dimensional model in datawarehousing ?

499


What are the different methods of loading dimension tables?

553


How do you define data block size?

580


Explain me what is vldb?

510


Explain how many ways you create ports?

599


Explain the main difference between inmon and kimball philosophies of data warehousing?

544


What is the purpose of Dataware Control?

588


Describe the differences between a data warehouse and data mart.

493


What are the different ways to represent the loading of dimension tables?

503