Conventional Thinking, a guide to database naming standards

Robert Treat (OmniTI)
Databases, People, Programming
Location: Meeting Room J2
Average rating: ****.
(4.00, 4 ratings)

The process of determining a good naming scheme for your database is more complicated than one might initially think. Take the idea of UPPERCASE vs. lowercase vs. MiXedCaSe table names. Most people will focus on the visual aspect of naming things, but it’s important to understand that SQL standard defines behavior related to case folding, and that many databases implement this differently; for example if you install MySQL on windows, you get a different default behavior than on unix, not to mention there are configuration options that change behavior too; all of which can actually increase the complexity and the amount of code when dealing with your database. In this talk we’ll discuss examples like this and make sure people see all sides of each situation. Areas we’ll touch on include:

  • Case Sensitivity
  • Pluralism
  • Key Names
  • Reserved Words
  • Specific Object Names
  • Naming for Relational Patterns
  • Codes and Abbreviations
  • SQL Formatting

We’ll discuss pros and cons of each topic, as well as how different databases implementations will affect the choices you make. We’ll also discuss techniques for enforcing these rules without causing major pain to your fellow developers.

Robert Treat

OmniTI

Robert Treat works as a database architect at OmniTI and has been working with open source for over a decade. A veteran industry speaker at conferences worldwide, Robert is also co-author of the book Beginning PHP and PostgreSQL 8, and has been recognized as a major contributor to the PostgreSQL project for his work over the years.

Comments on this page are now closed.

Comments

Picture of Shirley  Bailes
Shirley Bailes
08/10/2009 8:14am PDT

@ralph, they’re available above as a PDF now.

Robert Treat
08/08/2009 11:31am PDT

I’ve uploaded them to the OSCon website, I figure they should show up at some point on this page.

Ralph Wissing
07/27/2009 3:08pm PDT

Will the slides be available somewhere? They’d be much appreciated!

  • Intel
  • Microsoft
  • Google
  • SourceForge.net
  • Sun Microsystems
  • Facebook
  • Gear6
  • Kaltura
  • Liferay
  • MindTouch
  • MySpace.com
  • Novell, Inc.
  • Open Invention Network
  • Rackspace Cloud
  • Schooner Information Technology
  • Silicon Mechanics
  • Symbian Foundation
  • Twilio
  • WSO2
  • Yabarana Corporation

Sponsorship Opportunities

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

Download the OSCON Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for 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 contacts