OurSQL Episode 64: Are We Normal Yet?

This week, we talk about 2NF, 3NF and a bit about normalization vs. denormalization.

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

Normalization
Book: An Introduction to Database Systems by CJ Date

OurSQL episode 7, which goes over first normal form (1NF).

Wikipedia links:
functional dependency
2NF
3NF
BCNF
5NF

Schema of airport codes, cities and countries in 2NF:
YOW - Ottawa - Canada
EWR - Newark - USA
BOS - Boston - USA
LHR - London - England
SEA - Seattle - USA

Schema of airport codes, cities and countries in 3NF:
Airport table:
YOW - Ottawa
EWR - Newark
BOS - Boston
LHR - London
SEA - Seattle

And the city table would have entries like:
Ottawa - Canada
Newark - USA
Boston - USA
London - England
Seattle - USA

Brian K. Jones writes about denormalizing, but only if you have to, in A couple of MySQL performance tips.

Ronald Bradford's presentations on Better Indexes Save You Money and Improving Performance with Better Indexes.

Ovias Tariq's blog post with a list of pros and cons about normalization and denormalization.

How Facebook used BigTable and what decision they made to duplicate data

OurSQL Episode 54:Scaling MySQL, where we talk about sharding, and also a Scalebase article on database sharding

Giuseppe Maxia's article about too much denormalization.

Ear Candy
Manual page for Percona patched MySQL variable use_global_long_query_time

Where you can see us
Boston MySQL User Group on Monday, November 14th at 7:00 PM where Mike Frank of Gazzang will present "MySQL Encryption".

The November Seattle MySQL User Group on Thursday November 10th from 7 - 9pm, an unusual day of the week for this meetup, but Sarah moved it to accommodate Ori Herrnstadt, CTO Akiban talking about Renormalize - Solving Performance Problems in MySQL Without Denormalization.

The December Seattle MySQL User Group on Monday December 5th from 7 - 9 pm where Ivan Zoratti of SkySQL will present "MySQL HA Revisited".

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/1135