Re: [GENERAL] pervasiveness of surrogate (also called synthetic) keys

2011-05-02 Thread Jim Irrer
I've been carefully reading all of the comments with great interest. Thanks very much for the thoughtful responses - very enlightening. - Jim (the topic originator) Jim Irrer ir...@umich.edu (734) 647-4409 University of Michigan Hospital Radiation Oncology 519 W. Willi

[GENERAL] pervasiveness of surrogate (also called synthetic) keys

2011-04-28 Thread Jim Irrer
A colleague of mine insists that using surrogate keys is the common practice by an overwhelming margin in relational databases and that they are used in 99 percent of large installations. I agree that many situations benefit from them, but are they really as pervasive as he claims? Thanks, - Jim