Re: two nasty schemata, union types and surrogate keys

From: Philipp Post <post.philipp_at_googlemail.com>
Date: Fri, 18 Sep 2009 07:18:59 -0700 (PDT)
Message-ID: <61f6b289-7560-4b07-b4fa-8c24627f0693_at_h30g2000vbr.googlegroups.com>



> Tell me what you think, and sorry for going into essay length. <

The natural key for persons all around the globe that comes to my mind would be some DNA profile, what would however not be a practical solution (difficult to get, too long, data protection issues).

But what about using an artificial key? I. e. create your own encoding scheme, for example SMITHPA00001 for a person called "Paul Smith". Being fixed lenght, possibly with a check digit at the end. Some difficulties may arise with asian languages, where you would have to transcribe them first.

Could be worth a try, prior you go with a surrogate or physical locator instead.

brgds

Philipp Post Received on Fri Sep 18 2009 - 09:18:59 CDT

Original text of this message