Re: Trying to define Surrogates

Bob Badour wrote:
> JOG wrote:
> > The 2nd level of indirection in the last line indicates use of a
> > representative for an attribute that existed naturally before the
> > design of the database. It is not that it is just wasn't 'familiar', it
> > didn't exist at all - we have made the domain up specifically to
> > facilitate the information modelling process. We have not just modelled
> > the propositions we have added to them.
>
> We do that every time we create a candidate key. It isn't familiar until
> it is used, and then it is.

Ok, if you are using the term 'familiar' to correspond to 'did not previously exist prior to the data modelling process' then we agree. Nonetheless I find that use of the term 'familiar' extremely woolly, and think it is likely to cause confusion.

I also still contend that the need to create such a surrogate only occurs if we can't encode a natural attribute directly, or if the distinguishing attribute is an extremely unstable one, such as location. Anything else appears sloppiness on the designers part to me. Received on Thu Aug 17 2006 - 19:25:56 CEST