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

Home -> Community -> Usenet -> comp.databases.theory -> Re: The wisdom of the object mentors (Was: Searching OO Associations with RDBMS Persistence Models)

Re: The wisdom of the object mentors (Was: Searching OO Associations with RDBMS Persistence Models)

From: Erwin <e.smout_at_myonline.be>
Date: 2 Jun 2006 06:17:20 -0700
Message-ID: <1149254240.389759.144630@y43g2000cwc.googlegroups.com>

> I'm arguing that the design of application programs should be decoupled from the
> details of the DBMS.

And you have failed to explain (read : define) *PRECISELY* what it is exactly that you mean by "decoupling", and what exactly those "details of the dbms" are.

You have claimed that it is better for integrity and consistency checking to be done by the application programs, and not by the dbms. Are you aware that, in doing so, you have actually pleaded against the usage of keys in a database ? Yes, a key is nothing more than just a particular type of database constraint.

Do you honestly believe that application code is a better place to check and enforce uniqueness of a key on a relation ? Do you honestly believe that the average application programmer (and even the above-average, for that matter !) can get his code as failproof as a dbms can to enforce key uniqueness (e.g. also protect against concurrent threads each trying to insert a different customer with the same customer number) ?

Get real. Received on Fri Jun 02 2006 - 08:17:20 CDT

Original text of this message

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