Re: Normalization, Natural Keys, Surrogate Keys
Date: Fri, 17 May 2002 14:36:26 -0600
"Ed prochak" <ed.prochak_at_alltel.com> wrote in message
> Galen Boyer <galenboyer_at_hotpop.com> wrote in message
> > On Fri, 17 May 2002, comedyharris_at_hotmail.com wrote:
> > This topic is dear to me right now, because I'm dealing with the
> up of data that uses ID's and we have all the problems associated
> this "network model" style of database design: duplicates, invalid
> relations (the keys relate, but the "natural" data does not),
> (child without a true parent).
> (And this data is supposed to reflect and interface to what is in
> several other systems, so we also have out-of-sync conditions. at
> least one of these interfaces is based on a surrogate key which is
> currently out of wack.)
> Yes I know entering several attributes can be time consuming, but I
> not think that is a good arguement for using surrogates instead of
> natural keys. Ad hoc queries always take longer than we want (we all
> want the answer yesterday, right?).
- UNIQUE index on the natural key
- Implement RI to ensure no orphaned rows and ensure valid relationships
Perhaps I'm missing something obvious.
-- Pablo Sanchez, High-Performance Database Engineering mailto:pablo_at_hpdbe.com http://www.hpdbe.com Available for short-term and long-term contractsReceived on Fri May 17 2002 - 22:36:26 CEST