Top 20 DB Design Tips Every Architect Needs to Know

Ronald Bradford (EffectiveMySQL)

There are many poorly designed database application in use today. There are several reasons including lack of expertise, or lack of experience in MySQL specifically.

This session will aim to educate an attendee for the top 20 things every database design should have. As a consultant I see these common mistakes regularly, some of which can easily be corrected without any code changes.

Some topics include:

Why is normalization important? When do you optimize your normalized schema? Why NOT NULL is important? Why VARCHAR is bad? Disk = Memory = Performance? MySQL has 9 different Numeric data types, Oracle has 1. Why? Think transactions, think strict data integrity. Leverage the power of covering indexes. Query Cache, friend or enemy.

Photo of Ronald  Bradford

Ronald Bradford

EffectiveMySQL

Ronald is a Senior Consultant with MySQL Inc based in the US. Ronald brings 9 years of MySQL experience with 19 years experience in RDBMS products, enterprise data architecture, large systems development and Internet Web technologies.

Sponsors
  • Kickfire
  • Zmanda, Inc.
  • Continuent
  • EDS
  • JasperSoft
  • Sun Microsystems
  • Symantec Anti-Virus Software
  • XAware
  • Data Direct Technologies
  • Dolphin Interconnect Solutions
  • Hewlett Packard
  • Infobright, Inc
  • Linagora
  • Microsoft
  • OpSource
  • Oracle
  • Pentaho
  • R1Soft
  • Red Hat
  • Ticketmaster
  • TechRepublic

Contact Us

View a complete list of MySQL contacts.