Sponsors
  • Intel
  • Microsoft
  • Google
  • Sun Microsystems
  • BT
  • IBM
  • Yahoo! Inc.
  • Zimbra
  • Atlassian Software Systems
  • Disney
  • EnterpriseDB
  • Etelos
  • Ingres
  • JasperSoft
  • Kablink
  • Linagora
  • MindTouch
  • Mozilla Corporation
  • Novell, Inc.
  • Open Invention Network
  • OpSource
  • RightScale
  • Silicon Mechanics
  • Tenth Planet
  • Ticketmaster
  • Voiceroute
  • White Oak Technologies, Inc.
  • XAware
  • ZDNet

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com.

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for more information on trade opportunities with O'Reilly conferences, or contact mediapartners@oreilly.com.

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com.

OSCON Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the OSCON newsletter (login required).

Contact Us

View a complete list of OSCON 2008 Contacts

How to be Normal: A Guide for Developers

Databases
Location: D133 Level: Novice
Presentation: external link
Average rating: ***..
(3.92, 12 ratings)

At some point in every software project involving a database it becomes necessary for the developers who created (or inherited) the project to step back and take a look at their database. Many projects have a database schema that has evolved over time, with columns added here and tables added there, increasing complexity and often adding redundancy. Super-tables grow with more and more columns making ALTERs slow and backups difficult.

In this session MySQL author and speaker Mike Hillyer will guide the audience through the principles of database normalization and review some common normalization scenarios encountered by many application developers.

Topics include:

  • What is normalization and what are its benefits?
  • What are the normal forms?
    o First Normal Form
    o Second Normal Form
    o Third Normal Form
    o And so on…
  • Normalization Scenarios
  • Relationships and Joins
  • How Much is Too Much?

This session is intended for a beginner to intermediate audience and is applicable to developers and administrators who deal with database design.

Photo of Mike  Hillyer

Mike Hillyer

Message Systems

Mike Hillyer has been involved with the MySQL community for over six years, two of those spent as a Technical Writer for MySQL AB. He’s spoken at every MySQL User Conference since the first conference in 2003, on subjects ranging from VB6 development with MySQL to Managing Data Hierarchies.

Until recently he was a resident MySQL Expert for Techtarget’s SearchOpenSource.com site.

He is one of the top ranked MySQL experts at Experts-Exchange, a site for providing advice to fellow developers.

He currently works as an Engineer for Message Systems, a division of OmniTI Computer Consulting.

OSCON 2008