Re: Do you have an interesting Trigger application?

[Quoted] Eric Hanson wrote:
>
> I'm a researcher working on the development of improved database trigger
> systems. Can any of you tell me about how you're using triggers? In
> particular:
>
> * Do you think the Oracle trigger system is scalable enough?
YES - we have not run into probs with triggers (sometimes the code within them)

> * Is it fast enough?

YES
> * Have you run into limits where you wanted to be able to define more
> triggers than you were able to?
NO - there is no limit to my knowledge (7.3+)

> * Would you be interested in being able to test trigger conditions and run
> trigger actions in a separate transaction from the original update, to
> improve update response time?
This is possible fropm 8i onwards via autonomous transactions

> * How satisfied are you with the trigger system in Oracle? What do you
> like/not like about it?
I like the before/after concept better than SQL Server

> * If you were able to define thousands of triggers, could you use that
> capability?
Doubtful

> * Would you be interested in using triggers on how a value in the database
> changes over an extended period of time (e.g. trigger if this field drops by
> 20% in a month)?
This would be interesting to play with - you could do it now with some coding
but a native ability to do the same would be interesting
>
> Thanks for any perspective you can give as a trigger user!
>
> Eric Hanson
> Associate Professor
> Computer and Information Science and Engineering Department
> University of Florida
> hanson_at_cise.ufl.edu

Answers are inline above

-- 
==============================================
Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..."