Re: Is relational theory irrelevant?
Date: Wed, 19 Nov 2003 08:50:18 -0500
Message-ID: <bpfsbs$dc6$1_at_hanover.torolab.ibm.com>
But now I sendemail only if the table of addresses is updated.
That's most certainly not what I want.
INSERT INTO log SELECT user,
Triggers are tables specific business logic, what we need to model here
is an application process.
As a user I want to send email to all my Windows 2000 users to warn them
of the newest virus. So I clearly need to exploit predicates.
Once the email has been send I want to log that in an audit table so I
can prove I (IT security) did my job:
sendmail('Beware of virus x', user) as success
FROM inventory
WHERE os = 'W2K';
Note that log is a generic table. It does not know about emails. Tomorrow it will record other activities, such as which machines were upgraded to Linux ;-)
Cheers
Serge
-- Serge Rielau DB2 SQL Compiler Development IBM Toronto LabReceived on Wed Nov 19 2003 - 14:50:18 CET