Basics - what is the main FUNCTIONAL difference between ROLAP,MOLAP,HOLAP?

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 92 of 113

what is the main FUNCTIONAL difference between ROLAP,MOLAP,HOLAP?

(NOT AS A RELATIONAL,MULTI, HYBRID?)

Total Answers and Comments: 3

Last Update: January 04, 2008 Asked by: purna chowdary

Sponsored Links

Best Rated Answer

—

Submitted by: ThomasB

The FUNCTIONAL difference between these is how they information is stored. In all cases, the users see the data as a cube of dimensions and facts.

ROLAP - detailed data is stored in a relational database in 3NF, star, or snowflake form. Queries must summarize data on the fly.

MOLAP - data is stored in multidimensional form - dimension and facts stored together. You can think of this a a persistent cube. Level of detail is determined by the intersection of the dimension hierarchies.

HOALP - data is stored using a combination of relational and multi-dimensional storage. Summary data might persist as a cube, while detail data is stored relationally, but transitioning between the two is invisible to the end-user.

Above answer was rated as good by the following members:
nishamakhija21, prerna aggarwal

April 30, 2007 09:15:00

Anushree

RE: what is the main FUNCTIONAL difference between RO...

Rolap is relational Database based on Star schema
Molap is Multidimensional Schema based on the Olap model or the Cube
wheras HOLAP is the hybrid of the both

Is this answer useful? Yes | No

December 07, 2007 07:53:51

Sivakumar.R

Member Since: December 2007 Contribution: 14

RE: what is the main FUNCTIONAL difference between ROLAP,MOLAP,HOLAP?

Rolap : Relational Olap these functionality are used in Business Objects.
Molap : Multi Dimensional Olap Functionality are used in Cognos.
Hloap : Hybrid Olap is a combination of Rolap and Molap.

Is this answer useful? Yes | No

January 04, 2008 03:39:16

ThomasB

Member Since: January 2008 Contribution: 4

RE: what is the main FUNCTIONAL difference between ROLAP,MOLAP,HOLAP?

The FUNCTIONAL difference between these is how they information is stored. In all cases the users see the data as a cube of dimensions and facts.

ROLAP - detailed data is stored in a relational database in 3NF star or snowflake form. Queries must summarize data on the fly.

MOLAP - data is stored in multidimensional form - dimension and facts stored together. You can think of this a a persistent cube. Level of detail is determined by the intersection of the dimension hierarchies.

HOALP - data is stored using a combination of relational and multi-dimensional storage. Summary data might persist as a cube while detail data is stored relationally but transitioning between the two is invisible to the end-user.

Is this answer useful? Yes | No

2 0

Overall Rating: +2

Go To Top

User Name		Remember Me?
Password

Question Bank