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

"A Trio of Interesting Snowflakes" article

4 posters

Go down

"A Trio of Interesting Snowflakes" article  Empty "A Trio of Interesting Snowflakes" article

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

Back to top Go down

"A Trio of Interesting Snowflakes" article  Empty Re: "A Trio of Interesting Snowflakes" article

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

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

http://aginity.com

Back to top Go down

"A Trio of Interesting Snowflakes" article  Empty Re: "A Trio of Interesting Snowflakes" article

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

Back to top Go down

"A Trio of Interesting Snowflakes" article  Empty Abbreviated text

Post  Nancy Rinn 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

http://www.kimballgroup.com

Back to top Go down

"A Trio of Interesting Snowflakes" article  Empty Re: "A Trio of Interesting Snowflakes" article

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

Back to top Go down

"A Trio of Interesting Snowflakes" article  Empty Re: "A Trio of Interesting Snowflakes" article

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

Back to top Go down

"A Trio of Interesting Snowflakes" article  Empty Re: "A Trio of Interesting Snowflakes" article

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