Re: some information about anchor modeling

From: Eric <eric_at_deptj.eu>
Date: Wed, 18 Jul 2012 19:21:10 +0100
Message-ID: <slrnk0dvkm.pit.eric_at_teckel.deptj.eu>


On 2012-07-18, vldm10 <vldm10_at_yahoo.com> wrote:
> ...
> 2. Today, more than 90% of databases have an identifier which is a
> property of the corresponding entity. The VIN ? Vehicle Identification
> Number is a good example. For these databases the following is true:
> a) This identifier is much better than the surrogate key.
> b) These databases do not have any reason to use a surrogate key.
> ...

The VIN (and most other such things) is nothing more or less than Somebody Else's Surrogate Key. It is not an intrinsic property of the object it refers to.

Eric

-- 
ms fnd in a lbry
Received on Wed Jul 18 2012 - 20:21:10 CEST

Original text of this message