Star Schema for MPP databases

View previous topic View next topic Go down

Star Schema for MPP databases

Post  ryendluri on Mon Jun 17, 2013 3:55 pm

Have anyone designed Star Schema for MPP databases?  If so, can someone point me to an article or paper that covers this topics? Thanks, ..rao

ryendluri

Posts : 1
Join date : 2013-06-17

View user profile

Back to top Go down

Re: Star Schema for MPP databases

Post  BoxesAndLines on Mon Jun 17, 2013 6:44 pm

Here's the closest I've found, http://www.slideshare.net/pepeborja/teradata-aggregate-join-indices-and-dimensional-models-4860226?from=share_email
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Star Schema for MPP databases

Post  ngalemmo on Mon Jun 17, 2013 8:34 pm

It depends on which MPP you are working with.

Netezza handles star schema extremely well.  The only major consideration is when you have one very large dimension (50M+ rows).  Typically you would distribute the fact on that dimension key, to achieve a co-located join on that dimension.  Smaller dimension are usually not a concern, and anything under 1M rows isn't any bother at all.  Dimensions should be distributed on their surrogate PK.

With Teradata you need to build 'join indexes' which are essentially pre-joined materialized views.  (Buy a lot more disk)
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Star Schema for MPP databases

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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