Oracle-L: RE: Database Design: unique PK across all tables

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Thu, 31 Oct 2002 15:04:54 -0800
Message-ID: <F001.004F933E.20021031150454@fatcity.com>

Sorry, I have never used it. We do have one system which uses a uuid, but not one generated by Oracle. The function did not exist when that system was implemented.

Ian

-----Original Message-----
Sent: Thursday, October 31, 2002 11:41 AM To: Multiple recipients of list ORACLE-L

Thanks Ian, I don't recall every playing with that function.

Have you ever done any performance testing on it?

Jared

"MacGregor, Ian A." <ian_at_SLAC.Stanford.EDU> Sent by: root_at_fatcity.com
10/31/2002 09:13 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: Database Design: unique PK across all tables

If you want to use globally unique identifiers Oracle has a sys_guid function to provide this. There should never be any "additional meaning" placed in keys.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu
-----Original Message-----
Sent: Thursday, October 31, 2002 5:33 AM To: Multiple recipients of list ORACLE-L

Our developers are proposing a database design for an OLTP application in which each table has a PK of the same type and size. In addition, each possible PK value can belong to at most one table. Each table insert would require a call to the a single function to get the next PK value and an additional table would be used to store the current set of values. (The developers want to put some additional meaning into a PK value and a sequence would not be sufficient, hence the need for the PK generating function and current value table). I've never seen this done before and I would think this application would suffer greatly from contention when performing a large number of concurrent inserts.
Has anyone ever encountered a design like this? Is this a bad design? Thanks.
Brian

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Jared.Still_at_radisys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: MacGregor, Ian A.
INET: ian_at_SLAC.Stanford.EDU

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------