The Most Common Database Design Mistakes

1 of 10

The Most Common Database Design Mistakes

By Brian Prince

2 of 10

The Most Common Database Design Mistakes - Plan? What Plan?

Lack of planning was an oft-repeated theme. Poor planning is the fountain from which many other problems spring-

3 of 10

The Most Common Database Design Mistakes - Whats My Name?

The failure to adopt a naming standard was also cited as a problem, with each developer putting his or her own meaning on column names. Naming standards are a simple solution, with each table name and column name having a common meaning. For example, use column names that end with _date for date columns and _code for coded value columns.

4 of 10

The Most Common Database Design Mistakes - Too Much, Too Little, Too Late

Experts say that developers often use too many or too few indexes, both of which are bad for performance. The trick is to measure your performance: A simple query analysis often can tell you what you need to know to decide how many indexes are needed; other times, you may have to examine the overall server performance and how it's affected by the locking of specific indexes under load.

5 of 10

The Most Common Database Design Mistakes - Everybody Needs a Friend

When stakeholders aren't involved from the beginning, there can be problems. Including, for example, the SAN (storage-area network) and systems administrators in the planning stage can pay off in the end.

6 of 10

The Most Common Database Design Mistakes - Tooling Around

Not using tools or features meant to guarantee data integrity is a mistake. Databases now include all kinds of tools meant to make your life easier, so there's no excuse for not having a thorough understanding of tuning and optimization features.

7 of 10

The Most Common Database Design Mistakes - Just What Is Normal?

When it comes to OLTP, poor normalization can hurt data integrity and performance. Be cognizant of the 3NF (third normal form), and use model validation tools to detect normalization issues. A technical walk-through of the model by someone other than the modeler helps, too.

8 of 10

The Most Common Database Design Mistakes - This Is a RAID

Get to know RAID (Redundant Arrays of Inexpensive Disks). Develop a thorough understanding of RAID-5 versus RAID-1, and avoid RAID-5 when you are dealing with large-volume random access data patterns.

9 of 10

The Most Common Database Design Mistakes - Lets Get Physical

It's a mistake to ignore the physical side of the data model -

10 of 10

The Most Common Database Design Mistakes - See More Slideshows Like This One

<img src="/imagesvr_ez/b2bezp/2016/05/12_things_mgrs_resolve.jpg?alias=original" alt="thumbnail" /> 10 Things You Should Know About Databases <img src="/imagesvr_ez/b2bezp/2016/05/10_new_tech_ibm.jpg?alias=original" alt="thumbnail" /> 10 New Technologies IBM Is Cooking in Its Innovation Labsby Clint Boulton <img src="/imagesvr_ez/b2bezp/2016/05/uniform_desktop_secure.jpg?alias=original" alt="thumbnail" /> A Uniform Desktop Is a Secure Desktopby Cameron Sturdevant <img src="/imagesvr_ez/b2bezp/2016/05/15_influential_people_secur.jpg?alias=original" alt="thumbnail" /> The 15 Most Influential People in Security Todayby Ryan Naraine

Top White Papers and Webcasts