Re: Surrogate Key Semantics
Date: 12 Nov 2005 23:10:55 -0800
Message-ID: <1131865855.158377.237530_at_g44g2000cwa.googlegroups.com>
Thanks for the response...I guess.
>>>Let's get back to the basics of an RDBMS. Your questions are all based
What should the "mental model" be?
>>>on the wrong mental model.
>>Read some of Dr. Codd's stuff on this.
All the data, nothing but the data...blah, blah. I want practical answers.
>>BY DEFINITION, you cannot name a surrogate key because it is hidden from you.
Yeah, you can. A.ID is a made-up key for table A. I call it a surrogate key.
>>>Rows are not records; fields are not columns; tables are not files.
Yeah, they are.
>>>RDBMS uses the terms "referenced" and "referencing" tables. And it
>>>does not say HOW that referencing is done. So anything like what you
>>>call a surrogate will depend on the implementation, not on RDBMS.
What? Databases define relationships with primary and foreign keys?