What are the most common database design mistakes?

by Daniel J. Power
Editor, DSSResources.COM

In a 2008 eWeek slide show, Brian Prince identified "The Most Common Database Design Mistakes." The list was based on input from analysts and some professionals in the field. Prince's list includes 1) lack of planning, 2)failure to adopt a naming standard for tables and fields, 3) too many or too few indexes, 4) lack of stakeholder involvement, 5) not using tools for database tuning, database optimization or to assist in maintaining data integrity, 6) poor design and lack of normalization for transaction systems, 7) poor data back up or poor RAID implementation, and 8) ignoring the physical data model.

Prince, B., "The Most Common Database Design Mistakes," eWeek, at URL

Last update: 2013-08-03 02:38
Author: Daniel Power

Print this record Print this record
Show this as PDF file Show this as PDF file

Please rate this entry:

Average rating: 1 from 5 (15 Votes )

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry

DSS Home |  About Us |  Contact Us |  Site Index |  Subscribe | What's New
Please Tell Your Friends about DSSResources.COMCopyright © 1995-2015 by D. J. Power (see his home page).
DSSResources.COMsm is maintained by Daniel J. Power. Please contact him at with questions. See disclaimer and privacy statement.


powered by phpMyFAQ 1.5.3