Re: Surrogate keys

On 1/21/06, Christopher Browne <cbbrowne(at)acm(dot)org> wrote:
> > On 1/19/06, Pollard, Mike <mpollard(at)cincom(dot)com> wrote:
> >> Martijn van Oosterhout wrote:
> >>
> >> > Please provides natural keys for any of the following:
> >> >
> >> > - A Person
> >> > - A phone call: (from,to,date,time,duration) is not enough
> >> > - A physical address
> >> > - A phone line: (phone numbers arn't unique over time)
> >> > - An internet account: (usernames not unique over time either)
> >>
> >> Ahh, a challenge. Hmm, not sure about all of them, but here goes:
> >>
> >> A Person - well, you could use a bit map of their fingerprints, or maybe
> >> their retinal scan. Of course, that could change due to serious injury.
> >> Maybe some kind of representation of their DNA?
> >
> > Unless the person in question happens to be a chimera (yes, they do exist).
> >
> > ;-)
>
> Yeah, I saw that episode of CSI! :-)

Heh. I didn't realize they did that already. I was thinking of the
show "I Am My Own Twin" from the Discovery Health Channel.

Couldn't find a link from the official page, but:
http://www.globalspin.com/mt/archives/000547.html .

> --
> "cbbrowne","@","gmail.com"
> http://linuxdatabases.info/info/lsf.html
> "Cat's motto: No matter what you've done wrong, always try to make it
> look like the dog did it." -- Unknown
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

--
Mike Rylander
mrylander(at)gmail(dot)com
GPLS -- PINES Development
Database Developer
http://open-ils.org