Re: VAT rate or VAT amount as a column?

From: Kenneth Downs <knode.wants.this_at_see.sigblock>
Date: Sun, 06 Aug 2006 11:41:16 -0400
Message-Id: <c6fhq3-r32.ln1@pluto.downsfam.net>

Emily Jones wrote:

> A view isn't the same as a base table though is it? Materialised or not.

Right.

My point is that if we allow system controlled derived data, and we trust the values we are given because we trust the db server, what does it matter if we put the values in a view (materialized or not), or into the base table? Further, putting them into the base table is just plain simpler and more convenient.

The trigger is the mechanism that lets us accomplish a system-controlled derived value, and to put it where it is easiest to use: directly into the base table.

> 
> "Kenneth Downs" <knode.wants.this_at_see.sigblock> wrote in message
> news:q0heq3-ghe.ln1_at_pluto.downsfam.net...

>> Emily Jones wrote:
>>
>>>
>>> I thought a table with a derived column in it ISN'T normalised.
>>> Functionaly dependent not on the Primary Key, or something. No?
>>>
>>>
>>
>> Correct. But neither is the data in many views. Both are system
>> controlled
>> (if you go triggers) so whatever theory allows views allows the
>> materialized columns.
>>
>> --
>> Kenneth Downs
>> Secure Data Software, Inc.
>> (Ken)nneth@(Sec)ure(Dat)a(.com)

-- 
Kenneth Downs
Secure Data Software, Inc.
(Ken)nneth@(Sec)ure(Dat)a(.com)

Received on Sun Aug 06 2006 - 10:41:16 CDT