Part2/6: Top 20 DB Design Tips Every Architect Needs to Know

0 Part2/6: Top 20 DB Design Tips Every Architect Needs to KnowAbstract:

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.

About Ronald Bradford and Primebase Technologies:

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.

Duration : 0:7:20

Technorati Tags: , , , , , , , ,

Tags: , , , , , , , ,

Leave a Comment