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: integer id columns for all tables

Re: integer id columns for all tables

From: -CELKO- <jcelko212_at_earthlink.net>
Date: 28 Aug 2006 13:56:50 -0700
Message-ID: <1156798610.100816.100020@b28g2000cwb.googlegroups.com> 





In addition to what Bob mentioned, you have no validation or
verification on those numbers.  Since they are generated by the
hardware at insertion time, they are not part of a relational data
model.



Most of the programmers doing this are mimicing a sequential  file
system or an OID rather usng a proper relational key.  At best, with
careful triggers and other code, you can make them into a stable
redundancy.
Received on Mon Aug 28 2006 - 15:56:50 CDT












Original text of this message













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