Re: Primary Key Theory Question

From: Laconic2 <laconic2_at_comcast.net>
Date: Sat, 3 Apr 2004 09:37:05 -0500
Message-ID: <7cadnVFbnulxVvPdRVn-hQ_at_comcast.com>

What is a surrogate key and what is a natural key is in the eye of the beholder. There exists a certain context in which SSN is a surrogate key. It's a key issued for the purposes of identification to an object whose natural features are unusable for identification. It's just not invented by "our system."

SSN only looks natural to the IT person because the subject matter expert uses it as if it were natural. Received on Sat Apr 03 2004 - 16:37:05 CEST

This message: [ Message body ]
Next message: Ryan: "which databases use multiversioning?"
Previous message: Laconic2: "Re: What predicates the following relation represents"
Maybe in reply to: ben brugman: "Re: Primary Key Theory Question"
Next in thread: Bernard Peek: "Re: Primary Key Theory Question"
Reply: Bernard Peek: "Re: Primary Key Theory Question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message