Data Warehouse:

November 8, 2007 at 10:35 pm Leave a comment

warehouse2

My current job has me working with data warehousing a lot more than I have up to this point. There’s some really cool stuff going on in this area. I’ve been tearing through a couple good books on the ‘Kimball’ method and this week I’ve viewed several hours of webcast from Microsoft.

There seam to be two competing philosophies around data warehousing. I’ve been reading and practicing the ‘Kimball’ method, named after Ralph Kimball. It’s interesting stuff. It’s not at all like the transactional systems I’ve been supporting up to this point. In a nutshell, you do a lot of the work of summarizing the data during the data load. When it’s time to make reports you just pull the summarized data you pre-calculated, or you aggregate new summaries for whatever you need. For example, you load all your data into tables, but then load other tables with aggregate values (like total sales per day). Later you can pull the daily totals, or you can sum the daily totals over a month, much faster than if you had to calculate the totals for all the detail records. Now that’s cool.

Advertisements

Entry filed under: Uncategorized.

.net study group online now! Dreaming in code.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


Calendar

November 2007
M T W T F S S
« Oct   Apr »
 1234
567891011
12131415161718
19202122232425
2627282930  

Most Recent Posts


%d bloggers like this: