Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Surrogate Key Semantics

Re: Surrogate Key Semantics

From: -CELKO- <jcelko212_at_earthlink.net>
Date: 12 Nov 2005 09:30:25 -0800
Message-ID: <1131816625.610272.96100@f14g2000cwb.googlegroups.com> 





Let's get back to the basics of an RDBMS.  Your questions are all based
on the wrong mental model.



Read some of Dr. Codd's stuff on this.  BY DEFINITION, you cannot name
a surrogate key because it is hidden from you.  Rows are not records;
fields are not columns; tables are not files.



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.
Received on Sat Nov 12 2005 - 11:30:25 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US