Purchase Solution

difference between ROLAP and MOLAP

Not what you're looking for?

Ask Custom Question

What is the difference between ROLAP and MOLAP. Which is perferred? Why?

(Please include citiation/references)

Purchase this Solution
Solution Summary

The difference between ROLAP and MOLAP is included. Multidimensional online analytical processing is analyzed.

Solution Preview

ROLAP and MOLAP
--------------------------------------------------------------------------------
What is the difference between ROLAP and MOLAP. Which is preferred? Why?

(Please include citiation/references)

<b>Multidimensional Online Analytical Processing (MOLAP)</b>

MOLAP (multidimensional online analytical processing) is online analytical processing (OLAP) that indexes directly into a multidimensional database. In general, an OLAP application treats data multidimensionally; the user is able to view different aspects or facets of data aggregates such as sales by time, geography, and product model. If the data is stored in a relational data base, it can be viewed multidimensionally, but only by successively accessing and processing a table for each dimension or aspect of a data aggregate. MOLAP processes data that is already stored in a multidimensonal array in which all possible combinations of data are reflected, each in a cell that can be accessed directly. For this reason, MOLAP is, for most uses, faster and more user-responsive than relational online analytical processing (ROLAP), the main alternative to MOLAP. There is also hybrid OLAP (HOLAP), which combines some features from both ROLAP and MOLAP.

MOLAP is often used as part of a data warehouse application.

<b>Relational Online Analytical Processing (ROLAP)</b>

Relational online analytical processing (ROLAP) is a form of online analytical processing (OLAP) that performs dynamic multidimensional analysis of data stored in a relational database rather than in a multidimensional database (which is usually considered the OLAP standard).
Data processing ...

Purchase this Solution
Free BrainMass Quizzes
Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Basic Networking Questions

This quiz consists of some basic networking questions.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

View More Free Quizzes
Related BrainMass Solutions

  • Difference between ROLAP and MOLAP

    135590 Differences between ROLAP and MOLAP Please help with the following problem. What is the difference between ROLAP and MOLAP? This web site should help: http://www.dmreview.com/article_sub.cfm?

  • High-Level Summary: Web Database and Data Warehouse

    It stays stored in the data warehouse, and unlike MOLAP, there is no database as such in a ROLAP server.

  • technology systems for decision support

    One is Relational Database Engine (ROLAP) which is scalable to very large data volumes. Multidimensional Databases (MDDB) is for the moderate or medium sized data volumes.

  • Compare two treatment conditions: Why do the scores differ?

    There may not be a real difference between the two treatments, and the difference may a consequence of sampling error.

  • Standard Error of the Mean and Standard Error of the Difference

    Please give a full explanation of the difference between a standard error of the mean and a standard error of the difference between means.

  • Medicare Article Analysis

    (1) Difference in cholesterol testing between continuously insured and continuously uninsured adults: difference between groups before Medicare: 35.4% difference between groups after Medicare: 17.7% change: -17.7% (95% CI: -29.3% to -6.2%; P

  • ANOVA Analysis of Psychology Study

    Reject H0 and conclude that the mean difference between treatments is significant. d) F(1,3) = 9.00, with a critical value of 10.13. Fail to reject H0 and conclude that the mean difference between treatments is not significant.

  • Difference between actual and reported GPA

    87710 Difference between actual and reported GPA Difference between actual and reported GPA. See attached file for full problem description. Please see the attached file. 13. Look at the figure below.

  • Hypothesis testing

    Thus if the standard error of the difference between two means is high ,for a particular alpha, the difference between means will be within the confidence limit even though the difference between means is high and the null hypothesis will be accepted.

View More Related Solutions