Re: Surrogate Keys: an Implementation Issue
Date: Thu, 27 Jul 2006 13:16:53 -0500
Message-ID: <eaavt3$5c2$1_at_nntp.aioe.org>
>> I doubt that there are any such rdbms's today. It is like criticism of
>> RT because of SQL shortcomings - the lack of faithful implementations
>> only serves to encourage naive extensions to RT.
The idea of hidden surrogates and associated myths is mistakenly nurtured by
many who are intimately familiar with current crop of SQL products. For
instance, a cursory inspection of some sql programming newsgroups reveals
several blatant claims like:
In most cases, claimant misses the fundamental that a surrogate key is
nothing but a simple, stable and generally an irreducible candidate key. And
that it has nothing to do with the physical model and that once used outside
the DBMS, it is verifiable as well.
-- Surrogates are immutable
-- Surrogates should not be exposed the user
-- Surrogates help performance
-- Surrogates belong to the physical model
-- Surrogates are never verifiable in reality
-- ...
-- AnithReceived on Thu Jul 27 2006 - 20:16:53 CEST