Re: two nasty schemata, union types and surrogate keys
Date: Fri, 18 Sep 2009 07:18:59 -0700 (PDT)
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.
Philipp Post Received on Fri Sep 18 2009 - 16:18:59 CEST