"A Trio of Interesting Snowflakes" article

View previous topic View next topic Go down

"A Trio of Interesting Snowflakes" article

Post  AlanB on Thu Mar 24, 2011 7:06 pm

Does anyone know where to find a copy of Kimball's "A Trio of Interesting Snowflakes" article from Intelligent Enterprise Magazine, June 2001?

The link in Articles and Papers only shows part of the article. http://www.kimballgroup.com/html/articles_search/articles2001/0106IE.html?TrkID=IE200106

Links to Intelligent Enterprise get redirected to Information Week which no longer has the article, at least not if you search on Kimball & snowflake. Even Google failed me!

AlanB

Posts : 4
Join date : 2011-02-16
Location : Vancouver, BC

View user profile

Back to top Go down

Re: "A Trio of Interesting Snowflakes" article

Post  ngalemmo on Fri Mar 25, 2011 2:58 am

Its a shame they seemed to have lost the archive... maybe they should change their name to Information Weak.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: "A Trio of Interesting Snowflakes" article

Post  AlanB on Fri Mar 25, 2011 11:43 am

ngalemmo wrote:Its a shame they seemed to have lost the archive... maybe they should change their name to Information Weak.

Nice touch! Maybe someone should talk to them about DLM.

An email's been sent to the InformationWeek.com Sr Director of User Experience. Let's see where that leads.

AlanB

Posts : 4
Join date : 2011-02-16
Location : Vancouver, BC

View user profile

Back to top Go down

Abbreviated text

Post  Nancy Rinn on Fri Mar 25, 2011 2:06 pm

Thanks for letting us know about the missing text! We now have the complete article available online: http://kimballgroup.com/html/articles_search/articles2001/0106IE.html?TrkID=IE200106

Nancy

Nancy Rinn

Posts : 23
Join date : 2008-08-18
Location : MN

View user profile http://www.kimballgroup.com

Back to top Go down

Re: "A Trio of Interesting Snowflakes" article

Post  AlanB on Fri Mar 25, 2011 2:54 pm

Thanks Nancy.

Having a large, complex customer dimension, I thought I'd better read up on this.

AlanB

Posts : 4
Join date : 2011-02-16
Location : Vancouver, BC

View user profile

Back to top Go down

Re: "A Trio of Interesting Snowflakes" article

Post  hang on Fri Mar 25, 2011 7:57 pm

Nice article, but still missing some relevant schema diagrams.

I am working on a BI system managing national job seekers with 20 million records in the dimension. The original design has denormalised all the lengthy text attributes, as well as low cardinality attributes, into a monster dimension. You can imagine about the sheer volume of redundancies in the dimension making queries really slow and inefficient.

People can easily get carried away by the guidelines in dimensional modelling, that is normalised facts and denormalised dimensions. However in some cases, eg. monster dimensions, if the guidelines are misused as dogmatic rules, the consequence is sever. I donít like people setting rigid rules in any design. If there is a rule for dimension denormalisation in dimensional modeling, I strongly suggest the monster dimension be excepted.

hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

View user profile

Back to top Go down

Re: "A Trio of Interesting Snowflakes" article

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