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.

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).


Example was the Apache logs containing the following data:
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".

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