MOLAP & ROLAP

View previous topic View next topic Go down

MOLAP & ROLAP

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

Discuss the difference between MOLAP & ROLAP Datacubes

aashaya m

Posts : 18
Join date : 2011-04-25

View user profile

Back to top Go down

Re: MOLAP & ROLAP

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

More MOLAP & ROLAP

Post  kbreedlove50 on 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

View user profile

Back to top Go down

Re: MOLAP & ROLAP

Post  John Simon on 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

View user profile http://jsimonbi.wordpress.com

Back to top Go down

Re: MOLAP & ROLAP

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


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