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

Star Schema for MPP databases

3 posters

Go down

Star Schema for MPP databases Empty Star Schema for MPP databases

Post  ryendluri 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

Back to top Go down

Star Schema for MPP databases Empty Re: Star Schema for MPP databases

Post  BoxesAndLines 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
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Star Schema for MPP databases Empty Re: Star Schema for MPP databases

Post  ngalemmo 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)
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Star Schema for MPP databases Empty Re: Star Schema for MPP databases

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