Re: theory and practice: ying and yang

From: Alexandr Savinov <savinov_at_host.com>
Date: Wed, 01 Jun 2005 10:53:52 +0200
Message-ID: <429d77ae$1_at_news.fhg.de>


Alfredo Novoa schrieb:
> Declarative code should be favoured over procedural code.

There exists a permanent fight between declarative and procedural approaches (actually modes of thinking). In RM declarative approach dominates but still is not able to get rid of procedural approach (for objective reasons rather than because of "incompetence of practicians" or "wrong DBMS design").

One major problem of declarative approach is that sets do not exist in reality. Another fundamental problem (as a consequence of the first one) is that humans used to think procedurally and in terms of objects, arrays etc.

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

Hm. Here again it is not so clear. There is an opposite wide spread opinion that the best way to design your database consists in implementing everything via stored procedures (which then may use SQL or other means to access data).

alex
http://conceptoriented.com Received on Wed Jun 01 2005 - 10:53:52 CEST

Original text of this message