Re: You have my sympathies

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 15 Mar 2000 15:40:47 -0600
Message-ID: <8ap00v$dbl$1@garnet.tc.umn.edu>

The database does NOT duplicate the code 'built in to the business layer'. The 'business layer' should not duplicate constraints taken care of by the database.

Any application enforced constraint must be enforced by every app that touches the data. Much duplication.

Change the way you look at architecture and understand the importance of data
integrity as everyone else in this thread does.

Questions like this have been answered decades ago.

Some dude wrote:

>The fact that the business layer will only
>allow orders to go in if a related customer
>exists is not a piece of information that
>the database needs to know.
>
>(And, of course, if the only code to insert
>and delete data comes from the business
>layer, (as it no doubt will ;) then the business
>rules about customers will say that a
>customer may only be removed from the
>business if they have placed no orders.
>So the database does not need to
>duplicate the code built in to the
>business layer).

Steven Hauser
email: hause011@tc.umn.edu URL: http://www.tc.umn.edu/~hause011

Received on Wed Mar 15 2000 - 15:40:47 CST