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: Newbie question

Re: Newbie question

From: DM Unseen <dm.unseen_at_gmail.com>
Date: 21 Jun 2005 01:39:51 -0700
Message-ID: <1119343191.797060.167730@g44g2000cwa.googlegroups.com>


maybe an "order number" does not equal an "order id"?

order id= some information that uniquely indentifies an order. It might be of any type/value (i.e. a surrogate key) order number= represents an natural number N that shows that the order was the Nth order comitted to the system.

This is not a made up number, because it has real meaning (in the UoD), but still could be useful as an order id since it is unique (given that a system cannot commit 2 orders at exactly the same time, which would give us a tie)

Note that this is not a surrogate key, since a surrogate key has no correspondence in the UoD. Also for surrogate keys it is not mandatory to be
- Natural Numbers

Received on Tue Jun 21 2005 - 03:39:51 CDT

Original text of this message

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