Ten Common Database Design Mistakes

21 03 2007

1. Poor design/planning
2. Ignoring normalization
3. Poor naming standards
4. Lack of documentation
5. One table to hold all domain values
6. Using identity/guid columns as your only key
7. Not using SQL facilities to protect data integrity
8. Not using stored procedures to access data
9. Trying to build generic objects
10. Lack of testing

+ info en http://www.simple-talk.com


Acciones

Information

2 responses

22 03 2007
lynxman

Basically the worst are two of them.

1. Poor design/planning
5. One table to hold all domain values (this is indeed part of point 1.)
6. Using identity/guid columns as your only key (this is the most common one)

The rest usually depend heavily on 1. so well there are really two of them🙂

22 03 2007
biobit

Now I know whom to ask for help😉

Responder

Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión / Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión / Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión / Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión / Cambiar )

Conectando a %s




A %d blogueros les gusta esto: