OurSQL Episode 63: Snowing Already?

This week, Gerry Narvaja guest hosts and we talk about star and snowflake schemas, as a follow-up to last week's podcast on Data Warehousing 101.

News
FOSDEM has a call for papers open until Sunday, November 6th. FOSDEM is one of the largest free and non-commercial open source events, taking place in Brussels, Belgium on February 4th and 5th. There will be a Developer’s room that's near and dear to our hearts called "MySQL, MariaDB and friends".

Call for papers for Percona Live: MySQL Conference & Expo 2012 is open until Monday, December 5th. The MySQL Conference & Expo is Tuesday April 10 - Thursday, April 12, 2012 in Santa Clara, CA. To submit a paper, first register as a speaker at http://www.percona.com/live/mysql-conference-2012/user/register and then go to My Account -> Submit Proposal.

Main content
OurSQL Episode 7, What's it like to be Normal? that explained normalization and 1NF (first normal form).

2NF
3NF

Example was the Apache logs containing the following data:
timestamp
request method (GET, POST)
Browser agent (Mozilla, Safari, internet explorer)
requesting IP
referring IP
URL requested
status (OK, 404 error, redirected)
number of bytes sent

Some good books:
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
The Data Warehouse Lifecycle Toolkit

Other links:
Wikpedia's definition of a star schema
Wikpedia's definition of a snowflake schema
Wikipedia's definition of a fact table, including a factless fact table

Ralph Kimball's company, The Kimball Group, has some great forums.

Ear Candy
This week's ear candy is about data cubes. A data cube is simply a dimensional model stored in a structure, which can be virtual or real.

Where you can see us
November Seattle MySQL User Group ( http://www.meetup.com/seattlemysql/ ) on Thus Nov 1th from 7 - 9 pm at 7:00 PM where the CTO of Akiban Technologies will present: "Renormalize - Solving Performance Problems in MySQL Without Denormalization".
Boston MySQL User Group on Monday, November 14th at 7:00 PM where Mike Frank of Gazzang will present "MySQL Encryption".

Feedback
Facebook group
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast

Trackback URL for this post:

http://technocation.org/trackback/1134