Re: integer id columns for all tables

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

Matthias Kläy

--
www.kcc.ch