| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database Design: unique PK across all tables
Just tell your developers that primary key on the tables leads to spiritual
enlightment
and will help them earn reward points for paradise. Creating tables without
a primary key
is a sure fire way to eternal damnation and that place where they have a
great, ongoing
party withj lots of controlled substances and without law enforcement or
moralists (that
was in the demo).
-----Original Message-----
Sent: Thursday, October 31, 2002 10:04 AM
To: Multiple recipients of list ORACLE-L
Haven't encountered it, but reading what your saying sounds like a performance problem waiting to happen.
-----Original Message-----
Sent: Thursday, October 31, 2002 2:33 PM
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: Gogala, Mladen
INET: MGogala_at_oxhp.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). Received on Thu Oct 31 2002 - 10:48:59 CST
 |
 |