Re: Database Foreign key constraints vs Application Maintained Constraints
Date: Wed, 22 Apr 2009 10:42:42 -0400
Oracle will use the fks for star transformations if you have that enabled.
Having the business rules in the database makes the data application independent. People can use the tool of their choice and access is not limited to the single applicataion. This adds value to the database.
Developers hate foreign keys because they can't just cram data into the persistent store (database) and get on with unit testing. With fks the developers have to understand the data and develop error handling routines for when bad data is entered.
If the business rules change, is it easier to change a fk in the database or to re-code and re-release the application?Received on Wed Apr 22 2009 - 09:42:42 CDT