Browse by Tags

• data warehousing
• Kimball
• random waffle
• sql
• twitter

• Twitter status id conundrum

  I have an interest, a slightly perverse one some might say, in using online services and trying to figure out what the underlying (logical) data model is and in this day and age Twitter is one that lends itself very well to scrutiny. Consider this recent Read More... Posted Sunday, April 18, 2010 5:05 PM by jamiet | 5 Comments Filed under: data modelling, random waffle, twitter

• Debunking Kimball Effective Dates

  Those who are familiar with Ralph Kimball’s theories on data warehousing modelling may be familiar with his assertion that a type 2 dimension member record should have a StartDate and an EndDate that defines the effective period of that record. He outlines Read More... Posted Saturday, November 28, 2009 4:59 PM by jamiet | 50 Comments Filed under: data modelling, data warehousing, Kimball, sql