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

Answer Posted / marcelo malheiros

I believe you lost the begining of my answer...

"I know a lot of people understand ROLAP and MOLAP as where
the information is stored: if data is in a RDBMS, is ROLAP;
if it is in a self-contained cube, it is MOLAP.

I find the above a misconcept of the terms."

Let me repeat the fundamental question: How would classify
On Line Analytical Process performed on top of IMS, IDMS,
ADABAS, VSAM, flat file, XML and other non RDBMS data
storages?"

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

508


What is a real-time data warehouse? How is it different from near to real-time data warehouse?

541


What is the difference between connected and unconnected stored procedures?

539


How can we do data cleaning?

577


Explain what is difference between query studio and report studio?

537






Explain what are the various reporting tools in the market?

546


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

648


Explain what is the difference between olap and datawarehosue?

594


what is parallel query?

1617


How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

539


What is ods (operation data source)?

545


What is a Decision Tree Algorithm?

4530


Explain what type of indexing mechanism do we need to use for a typical datawarehouse?

593


What is edw?

619


Explain the definition of normalized and denormalized view?

515