Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: No foreign keys??? What the???

Re: No foreign keys??? What the???

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 2000/08/07
Message-ID: <8mn29m$9l6$1@garnet.tc.umn.edu>#1/1

Sybrand Bakker has the better view on constraints. Yes, enforce many constraints consistantly across the system at the database level.

Most developers have only their single report or application in mind. DBAs must take a global view, many reports and programs hit a database, and to have all developers enforce a consistent set of constraints in the spaghetti they call code is only possible in a few highly organized groups.

Most corporations and government development is done in chaos, with few groups able to consistantly develop reasonable code. To help developers with constraints removes some of the chaos from the system.

Remember, NASA programmers recently crashed a polar lander on Mars because a couple developer groups enforced different constraints on the same system.

-- 

---------------------------------------------------------
Steven Hauser email: hause011@tc.umn.edu URL: http://www.tc.umn.edu/~hause011
---------------------------------------------------------
Received on Mon Aug 07 2000 - 00:00:00 CDT

Original text of this message

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