Monday, June 25, 2007
how not to structure a database
This is what I've been working on for the past three weeks: a circular relationship map for the database I'm supporting, reverse engineered using Embarcadero ER/Studio. There are no indexes other than primary keys defined and there are no foreign keys in any tables so the relationships have to be inferred from the stored procedures. This explains why a 5GB database with 120 users is running on Windows Server 2003 x64, dual dual-core CPU's and 8GB RAM.
Oh, and those tiny little blips in the upper left corner are views with no columns defined. I haven't figure out why they're in the database yet.