Re: integer id columns for all tables

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Mon, 28 Aug 2006 22:52:04 GMT
Message-ID: <osKIg.5433$9u.54351@ursa-nb00s0.nbnet.nb.ca>

Matthias Klaey wrote:

> Alexandr Savinov <spam_at_conceptoriented.com> wrote:
>
> [...]
>

>>>Someone with greater expertise than I recently told me that it is best
>>>to have an integer primary-key for all tables in a database, even if
>>>the table already has some non-integer primary key,

>

>>Its main advantage is that it more or less successfully 
>>separates identification means (primary key in RM) from what is going to 
>>be identified.

>
> [...]
>

>>for separating two concerns:
>>
>>- object semantic characterisation (entity modeling) and
>>- object identification means (identity modeling).

>
>
> could you please give an example of what you mean by these two
> concerns? or perhaps a reference to a definition and/or to a textbook?
> i have never heard of this before, so i am very curious

Savinov has long ago demonstrated that he is a complete moron. You can safely ignore him. Received on Mon Aug 28 2006 - 17:52:04 CDT