Re: Database Foreign key constraints vs Application Maintained Constraints
Date: Mon, 20 Apr 2009 22:19:46 +0200
Since data integrity violations should not occur, I guess that one can as safely assume that their should never be any bug in the middle tier java API, that nobody will ever mistype anything, and that all distributed transactions will always safely complete and that nothing will ever keep hanging in limbo.
Brave new world ...
If I were you I wouldn't let your developers refactor their schema, with or without FKs. Don't know why, not feeling fully confident.
HTH S Faroult
> I'm looking for thoughts / feedback / experiences of :
> - applications that leave enforcement of foreign key relationships to the application (or simply assume that those relationships will not be violated) in an OLTP system
> - any considerations when creating foreign key constraints between tables in different schemas.
> The background to this request follows below for those interested.