Re: RM's Canonical database (was: Bob's 'Self-aggrandizing ignorant' Count)

On 3 Jul 2006 09:40:46 -0700, "Alfredo Novoa" <alfredono_at_gmail.com> wrote:

>> > In favor of putting a common rule in the DBMS is that it is centralized. The
>> > "Once and Only Once", or "DRY" principle suggests that it should be there.
>> >
>> > Another possibility for a location for such a rule is in a middle tier, where it
>> > can also meet the DRY principle.
>>
>> But then you lose the centralization.
>
>If "middle tier" has the usual meaning then the middle tier IS the
>DBMS.
This organization had APP -> Middle Tier Code -> DBMS. I find that to be a pretty common setup.

-- 
Ron Jeffries
www.XProgramming.com
I'm giving the best advice I have. You get to decide if it's true for you.