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: not using foreign keys?

Re: not using foreign keys?

From: bugbear <bugbear_at_trim_papermule.co.uk_trim>
Date: Wed, 06 Jun 2007 12:37:15 +0100
Message-ID: <46669c6b$0$8744$ed2619ec@ptn-nntp-reader02.plus.net>


spacemarine_at_mailinator.com wrote:
> hello,
>
> i have a question -- is the practice of using FKs to maintain
> referential integrity an argued (for/against) practice? im now on an
> enterprise banking project, and the db designer does not use FKs, he
> feels it creates a "closed system", and prefers to have the coders
> manage constraints via procs.
>
> id never seen this before, but he said its an age-old argument (w/
> merits) and one he adheres to. is this so, or is it an unusual
> personal preference?

Without causing major privacy issues, what can you tell us about this "db designer"?

Background?
Age?
Training?

Because this (as others have said) is MOST ODD.

   BugBear Received on Wed Jun 06 2007 - 06:37:15 CDT

Original text of this message

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