Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

MOLAP & ROLAP

4 posters

Go down

 MOLAP & ROLAP Empty MOLAP & ROLAP

Post  aashaya m Sat Dec 17, 2011 10:59 am

Discuss the difference between MOLAP & ROLAP Datacubes

aashaya m

Posts : 18
Join date : 2011-04-25

Back to top Go down

 MOLAP & ROLAP Empty Re: MOLAP & ROLAP

Post  ngalemmo Sun Dec 18, 2011 1:15 pm

MOLAP is a OLAP environment based on a MultiDimensional database (MDDB) such as TM1, Hyperion, and SSAS. ROLAP is an OLAP environment based on a relational database (RDB). MDDB's are physically different than RDB's. Whereas in a RDB data is stored in tables, rows and columns, in an MDDB, data is stored in cells within a cube. MDDB's provide significantly better performance but significantly lower capacity. They usually contain aggregate data and supported by detailed (atomic level) star schema implemented in a relational database.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

 MOLAP & ROLAP Empty More MOLAP & ROLAP

Post  kbreedlove50 Wed Jan 11, 2012 4:21 pm

To expand on the first reply, MOLAP/MDDB may appear to be faster, but it usually depends on when you start timing. If your existing cubes don't answer your question and new one(s) need to be built, add this time into the overall response time. And because of the indexing and physical storage of values for all the drill paths you may have requested, the overall size is significantly smaller than what a ROLAP tool can offer. Also, because the cube is a store of aggregated data, it's likely that you cannot drill directly into the underlying, causal atomic detail data.

Regards,

Keith

kbreedlove50

Posts : 4
Join date : 2011-05-09

Back to top Go down

 MOLAP & ROLAP Empty Re: MOLAP & ROLAP

Post  John Simon Sun Jan 15, 2012 11:38 pm

Just an FYI on a few things:
1) Yahoo have a 18Tb MOLAP SSAS cube. So there is no real size restriction on MOLAP cubes
2) SSAS can do MOLAP, HOLAP and ROLAP. I work in a Teradata environment where we use SSAS and have MOLAP dimensions with ROLAP fact data.
3) SSAS does not pre-aggregate data by default. However it is designed that it can still aggregate data quickly, and aggregations may be built on an SSAS cube (whether MOLAP or ROLAP).

John Simon

Posts : 186
Join date : 2009-05-29
Location : Melbourne, Australia

http://jsimonbi.wordpress.com

Back to top Go down

 MOLAP & ROLAP Empty Re: MOLAP & ROLAP

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum