IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / I guess what I'm looking for is ...
Post #100,719
by drewk
Picture of drewk
5/7/03 10:46:26 AM
Reply
New I guess what I'm looking for is ...
Is there any possible reason to have it structured the way it is now? I don't usually like to change things until I understand why they're the way they are to begin with. Problem is the guy who built this is long gone, and it's entirely possible he was just an idiot.
===

Implicitly condoning stupidity since 2001.
Post #100,721
by jbrabeck
5/7/03 10:57:34 AM
Reply
New Guessing
Over normalized. When normalizing, keep going until all redundant data is removed. Then look at results to see if usage would be enhanced/performance increased by some "denormalization".

If you always need the county AND state then they both should be in the data table instead of requiring a lookup to find the state.

Looks like the developer didn't perform final analysis.
[link|mailto:jbrabeck@attbi.com|Joe]
     Is this schema screwed up, or is it just me? - (drewk) - (16) - May 7, 2003, 09:50:41 AM EDT
         Your new schema looks good. - (jbrabeck) - (2) - May 7, 2003, 10:31:20 AM EDT
             I guess what I'm looking for is ... - (drewk) - (1) - May 7, 2003, 10:46:26 AM EDT
                 Guessing - (jbrabeck) - May 7, 2003, 10:57:34 AM EDT
         Dependent Foreign Keys - (ChrisR) - (10) - May 7, 2003, 10:58:46 AM EDT
             Can't happen, each county is unique - (drewk) - (9) - May 7, 2003, 11:05:16 AM EDT
                 Still a function of integrity - (ChrisR) - (8) - May 7, 2003, 11:15:42 AM EDT
                     Don't even need a lookup table - (drewk) - (7) - May 7, 2003, 11:18:53 AM EDT
                         Maybe it's just me - (tseliot) - (6) - May 7, 2003, 11:46:48 AM EDT
                             Agreed. - (admin) - (5) - May 7, 2003, 11:51:52 AM EDT
                                 That's how I've already set it up - (drewk) - (4) - May 7, 2003, 12:35:35 PM EDT
                                     It's not a matter of speed. - (admin) - (3) - May 7, 2003, 12:41:23 PM EDT
                                         Generally I agree - (drewk) - (2) - May 7, 2003, 12:43:59 PM EDT
                                             Even so. - (admin) - May 7, 2003, 02:35:22 PM EDT
                                             I agree with Malraux on this one - (tablizer) - May 22, 2003, 02:00:35 AM EDT
         Thoughts... - (Simon_Jester) - (1) - May 10, 2003, 11:56:00 AM EDT
             You've about got it - (drewk) - May 12, 2003, 07:35:55 AM EDT

Over 9000!
102 ms