Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Trying to understand aggregation Expand / Collapse
Author
Message
Posted Saturday, June 14, 2014 6:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, June 15, 2014 8:38 AM
Points: 1, Visits: 4
Hi all,

I'm new to data warehousing and have been reading about ROLAP, MOLAP and HOLAP implementations and how creating aggregations help in speeding up query response time.

I'm trying to understand when these aggregations are created and the relative time to create them between the approaches.

Does it take longer to build MOLAP aggregations than in ROLAP for the same data set?

Would both ROLAP and MOLAP aggregation be typically updated overnight?

Hoping people can help a newbie
thanks,
Post #1580831
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse