News for hackers. Stuff that matters.
Re:Stop calling me NoSQL by davidmathers on Sunday October 25, 2009 @09:02PM (#902451)
What you describe is a pointer, but not a surrogate key.

http://en.wikipedia.org/wiki/Surrogate_key

"For example, table Staff may contain two rows for "John Smith", one row when he was employed between 1990 and 1999, another row when he was employed between 2001 and 2006. The surrogate key is identical (non-unique) in both rows however the primary key will be unique."

There are no comments on this comment yet.