Re: Surrogate Keys
Date: 27 Sep 2000 09:13:52 -0500
Message-ID: <39d1f290_3_at_dilbert.ic.sunysb.edu>
Additionally, use them when you are designing data warehouses as well. Do NOT use primary keys when building your schemas.
Joe Trubisz
Dept. of Computer Science
SUNY Stony Brook
Stony Brook, NY 11794
Jan Lenders (J.Lenders_at_Betuwe.net) wrote:
: In article <8qrd0t$n9j$1_at_nnrp1.deja.com>,
: dhussein_at_my-deja.com wrote:
: > Hi,
: >
: > I need to know your opinion on using Surrogate
: > Keys. Would you use them always? Only when needed?
: > What are the pros and cons from your experience?
: >
: > Thanks in advance.
: >
: DO NOT use them always.
: Surrogate keys can be used in a relational database;
: - if there are no candidate keys.
: - if there are no candidate keys for which the value is 100% fixed.
: - ((if the inherited (foreign) primary keys no longer contribute to
: distincly identify an object.))
: Sent via Deja.com http://www.deja.com/
: Before you buy.
Received on Wed Sep 27 2000 - 16:13:52 CEST