Newsletter Subscription | Glossary | Contact Us
Home > All Categories > MySQL > Education > Top 20 DB Design Tips Every Architect Needs to Know
Question Title Top 20 DB Design Tips Every Architect Needs to Know
Authored by: SQLTube
Viewed: 268 times so far
Experience in MySQL specifically. This session will aim to educate an attendee for the top 20 things every database design should have.


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
Click Here to View all the questions in Education category.
File Attachments File Attachments
There are no attachment file(s) related to this question.
User Comments User Comments
There are no user comments for this question. Be the first to post a comment. Click Here
Post Comment Add a Comment
Email Address:
Comment/Message
Verify Code

Post Comment How helpful was this article to you?
Related Questions Related Article
  1. MySQL Stored Procedures: CASE syntax
  2. MySQL 5.1 data dictionary diagram
  3. MySQL 5.1 partitions in practice
  4. A Primer on Falcon Tablespaces
  5. MySQL Sandbox University lesson - June 12, 14:00 GMT
  6. COUNT(*) vs COUNT(col)
  7. Using XML in MySQL 5.1 and 6.0
  8. High Performance MySQL 2nd Edition is in production
  9. The top 20 design tips for MySQL Enterprise data architects
  10. InnoDB Sessions at MySQL Conference
  11. Database Security Talk
  12. Webinar - Reduce the TCO with MySQL
  13. Reading the guide
  14. How to create a MySQL Database
  15. Designing Scalable Architectures with MySQL Proxy
  16. MySQL Conference Tracks for the DBA
  17. Top 20 DB Design Tips Every Architect Needs to Know part 5
  18. MySQL Special Promotions - Training Services
  19. High Performance MySQL Second Edition Schedule
  20. Top 20 DB Design Tips Every Architect Needs to Know part 3
  21. Interview by Sun TV at MySQL Conference
  22. Top 20 DB Design Tips Every Architect Needs to Know part 4
  23. An Introduction to BLOB Streaming for MySQL part 4
  24. Top 20 DB Design Tips Every Architect Needs to Know part 2
  25. An Introduction to BLOB Streaming for MySQL part 2
  26. An Introduction to BLOB Streaming for MySQL part 3
  27. Two second editions, two first times
  28. An Introduction to BLOB Streaming for MySQL part 5
  29. MySQL Obfuscator, What features do you want to see
  30. An Introduction to BLOB Streaming for MySQL
  31. Drizzling MySQL
  32. Employee MySQL virtual columns
  33. Capacity Planning, Archetecture, Scaling, Response time, Throughput
  34. OSCON 2008 - MySQL Proxy - from architecture to implementation
  35. Wonderful world of MySQL Storage Engines
  36. MySQL Proxy @ OSCON 08
  37. MySQL University Thu 30 Oct
  38. UC2009 - A few days, a few wishes
Article Information Additional Information
Article Number: 312
Created: 2008-06-17 12:56 PM
Rating No Rating
 
Article Options Article Options
Print Question Print this Question/Article
Email Question Email this Question/Article to Friend
Export to MS Word Export to MS Word
Bookmark Article
del.icio.us Bookmark del.icio.us Bookmark
Digg It Digg It
Furl It Furl It
Subscribe to Article Subscribe to Article
 
Language Translation Language Translation
 
Search Knowledge Base Search Knowledge Base

 
  Copyright © Mentat Technologies