Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between MOLAP and ROLAP?
- 3 Answers
- 8657 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kashish
MOLAP
This is the more traditional way of OLAP analysis. In
MOLAP, data is stored in a multidimensional cube. The
storage is not in the relational database, but in
proprietary formats.
Advantages:
• Excellent performance: MOLAP cubes are built for
fast data retrieval, and is optimal for slicing and dicing
operations.
• Can perform complex calculations: All calculations
have been pre-generated when the cube is created. Hence,
complex calculations are not only doable, but they return
quickly.
Disadvantages:
• Limited in the amount of data it can handle:
Because all calculations are performed when the cube is
built, it is not possible to include a large amount of data
in the cube itself. This is not to say that the data in the
cube cannot be derived from a large amount of data. Indeed,
this is possible. But in this case, only summary-level
information will be included in the cube itself.
• Requires additional investment: Cube technology are
often proprietary and do not already exist in the
organization. Therefore, to adopt MOLAP technology, chances
are additional investments in human and capital resources
are needed.
ROLAP
This methodology relies on manipulating the data stored in
the relational database to give the appearance of
traditional OLAP's slicing and dicing functionality. In
essence, each action of slicing and dicing is equivalent to
adding a "WHERE" clause in the SQL statement.
Advantages:
• Can handle large amounts of data: The data size
limitation of ROLAP technology is the limitation on data
size of the underlying relational database. In other words,
ROLAP itself places no limitation on data amount.
• Can leverage functionalities inherent in the
relational database: Often, relational database already
comes with a host of functionalities. ROLAP technologies,
since they sit on top of the relational database, can
therefore leverage these functionalities.
Disadvantages:
• Performance can be slow: Because each ROLAP report
is essentially a SQL query (or multiple SQL queries) in the
relational database, the query time can be long if the
underlying data size is large.
• Limited by SQL functionalities: Because ROLAP
technology mainly relies on generating SQL statements to
query the relational database, and SQL statements do not
fit all needs (for example, it is difficult to perform
complex calculations using SQL), ROLAP technologies are
therefore traditionally limited by what SQL can do. ROLAP
vendors have mitigated this risk by building into the tool
out-of-the-box complex functions as well as the ability to
allow users to define their own functions.
| Is This Answer Correct ? | 6 Yes | 1 No |
MOLAP:An Query which can query the data from a
multidimensional database for multidimensional analysis know
as "MOLAP"
multidimensional analysis can be achieved by using drillup
and drilldown
ROLAP:An Query which can query the data from Relational
database is known as "ROLAP"
EX:Cognos8.4,Microstrategy
| Is This Answer Correct ? | 4 Yes | 2 No |
Describe a data warehouse.
Suppose we want to display zero when null values coming to report how can we do that?
Explain what is power center repository?
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
What is cfapplication tag?
What is MODEL is Data mining world?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
Why is business intelligence (bi) important in data warehousing?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
Explain the difference between filter and conditin?
2.What is staging area ?
4 Answers HCL, IBM, iFlex, TCS,
What are Non-additive facts?
Teradata 
