Re: ID field as logical address

From: rpost <>
Date: Mon, 1 Jun 2009 16:36:02 +0000 (UTC)
Message-ID: <h0101i$1enf$>

Bernard Peek wrote:

>Adding an ID field is only useful if you can reliably link the ID to the
>real person. The traditional way to do this is to tell each person the
>ID that you have created for them and insist that they remember it for
>you. This is how SSNs and payroll numbers work. This system is not

There is an alternative: keeping the schema such that persons can always be identified based on non-ID fields, either directly within the table (i.e. it has a key that doesn't involve ID fields), or indirectly (i.e. queries to distinguish all persons exist, but may involve multiple tables, even joins over ID fields).

>Bernard Peek

Reinier Post
Received on Mon Jun 01 2009 - 18:36:02 CEST

Original text of this message