Re: Natural keys vs Aritficial Keys
From: Roy Hann <specially_at_processed.almost.meat>
Date: Fri, 03 Jul 2009 02:03:19 -0500
Message-ID: <mr-dnfiT-7OqMNDXnZ2dnUVZ8rudnZ2d_at_pipex.net>
Date: Fri, 03 Jul 2009 02:03:19 -0500
Message-ID: <mr-dnfiT-7OqMNDXnZ2dnUVZ8rudnZ2d_at_pipex.net>
lawpoop wrote:
> On Jul 2, 11:24 am, Bob Badour <bbad..._at_pei.sympatico.ca> wrote:
>
>> > Isn't any key that partially relies on a date/time field thereby
>> > partially artificial?
>>
>> All keys are equally artificial. They are after all artifices for
>> identifying things. Your own name is an artifice chosen by your parents
>> and to which you were conditioned to respond. Unless your name is George
>> Foreman or Prince Michael, it was chosen to be somewhat unique for your
>> parents' ease of reference.
>
> If all keys are equally artificial, is a natural key then artificial?
Ultimately, yes. But "ultimately" is nothing to do with the problem you are trying to solve.
-- RoyReceived on Fri Jul 03 2009 - 09:03:19 CEST