What is Molap and Rolap? What is Diff between Them?
Answer Posted / suba
multidimensional online analytical processing and
relational online analytical processing. In MOLAP data is
stored in form of multidimensional cubes. The advantages of
this mode is that it provides excellent query performance
and the cubes are built for fast data retrieval. All
calculations are pre-generated when the cube is created and
can be easily applied while querying data.In ROLAP, the
data is stored in relational databases this model gives the
appearance of traditional OLAP’s slicing and dicing
functionality. The advantages of this model is it can
handle a large amount of data and can leverage all the
functionalities of the relational database.
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
What is data analysis?
What are session timeout and application timeout? Where we have to do this process?
What is surrogate key? Where we use it explain with example?
Explain what are the possible data marts in retail sales?
Tell me what is full load & incremental or refresh load?
What is the difference between aggregate table and materialized view?
Why we use repository connectivity?
What is MODEL is Data mining world?
in general which algorithms for used?
What are the main steps to build the data warehouse?
What is data warehosuing hierarchy?
How did you plan your Data ware house project?
What is the advantages data mining over traditional approaches?
What is the difference between dependent data warehouse and independent data warehouse?
What is loop in data warehousing?