Re: theory and practice: ying and yang

On Tue, 31 May 2005 04:21:16 GMT, "mountain man" <hobbit_at_southern_seaweed.com.op> wrote:

>The relational model speaks about data and its schema but is mute
>about the application software layer,

Correct.

>which has been sitting in the
>s/w protocol stack above the DBMS software, since the year dot.

???

>My observation is that, since the emergence of addressable stored
>procedures within the (R)DBMS layer, systems are using this
>approach more and more.

But the stored procedures are a part of the "schema".

>Essentially you can generalise this observation, with reference to
>the protocol stack and say that industry is following an increasing
>trend in that the (application) code is being migrated from the
>(client and/or server) application software layer, and into the
>(R)DBMS layer.
>
>My thesis is that if you take this migration to its logical
>conclusion there may be achievable an optimal stage in
>which *all* application software in internal to the DBMS
>in the form of stored procedures.

Declarative code should be favoured over procedural code.

Stored procedures should be used as a last resort to implement business rules.

End of story. Received on Tue May 31 2005 - 14:09:23 CEST