Re: theory and practice: ying and yang

From: Paul <paul_at_test.com>
Date: Sun, 05 Jun 2005 01:32:55 +0100
Message-ID: <42a24837$0$1704$ed2e19e4@ptn-nntp-reader04.plus.net>

mountain man wrote:

>>Having business logic in the form of stored procedures offers no
>>advantage (with respect to data integrity) over having the business
>>logic held externally, if both are managed by the same person.

>
> There is an advantage. In the traditional manner, with the logic
> held externally it is essentially being held in another software
> that is separate to the RDBMS software.
>
> Examine the redundancies caused by definitions (especially of
> data schemas, and changes thereto) that are effectively held in
> two separate softwares. Each redundancy costs money, every
> single time it is visited. More costly though, and quite unseen,
> are the behind the scenes coordination exercises that are required
> to effectively manage changes to these two separate software
> locations.

but even if your business logic is held in stored procedures, you still in effect have two separate areas to update when schemas change. If you change the table designs, you also have to change the stored procedures to reflect those changes. The fact that they are stored in the database rather than externally is a minor point, is it not?

Paul. Received on Sat Jun 04 2005 - 19:32:55 CDT