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: RM's Canonical database

Re: RM's Canonical database

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Sat, 01 Jul 2006 18:33:58 GMT
Message-ID: <qezpg.4696$pu3.108809@ursa-nb00s0.nbnet.nb.ca>


Marshall wrote:
> Michael Gaab wrote:
>

>>"mAsterdam" <mAsterdam_at_vrijdag.org> wrote in message news:44a63f88$0$31653$e4fe514c_at_news.xs4all.nl...
>>
>>>Robert Martin wrote:
>>>
>>>>... business rules don't belong in the database.
>>>
>>>What, in your opinion, does belong in the database?
>>
>>Imagine that your database is used by multiple applications where
>>each application has different business rules. IMO, this is one reason
>>why one should not include business rules in a db. So the answer to
>>your question is *data*.

>
> [speaking in terms of the enterprise dbms]
>
> I reject your argument on simple definitional grounds.
>
> Given a business with a set of applications A and a database
> D managed by a dbms M.
>
> Consider a given rule R.
>
> If for all a in A R holds, then R is a business rule, and should be
> managed by M.
>
> --otherwise--
>
> If there exists a in A where R holds, then R is an application rule
> and should be managed by a.
>
> I am completely unwilling to consider something a "business rule" if it
> isn't true for the business. Something that's required for application
> a
> but does not hold for application b is a rule of application a, and
> decidedly *not* a business rule.

Even in that case, the most effective way to enforce R or to deliver R is through the application view provided by M for A. Received on Sat Jul 01 2006 - 13:33:58 CDT

Original text of this message

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