Well said...
posted by Thomas Kyte at 9:48 AM
Thursday, December 16, 2010
About Me
- Name: Thomas Kyte
- Location: Round Hill, Virginia
The views expressed are my own and not necessarily those of Oracle and its affiliates. The views and opinions expressed by visitors to this blog are theirs and do not necessarily reflect mine. I've been using Oracle since 1988. I've been working at Oracle since 1993 (version 7.0). I spend way too much time working on asktom.oracle.com...
Previous Posts
- A tiny challenge...
- A follow up...
- I might have to move...
- I'm #2....
- Mr Trace...
- Another SQL*Plus thing I learned...
- I learned I don't think I like this...
- What I learned about deadlines...
- What I learned about "Security"
- A SQLNet thing I probably forgot about...
5 Comments:
Yes, very well said indeed, thanks for the link Tom
- gord irish
Yes, very sad indeed, thanks for the link Tom.
From the previous Why I Do Not Use ORM post:
"...to allow for implementing business logic... the best permforming and safest method is to use triggers."
word: gorprays
Joel:
If I were to rewrite that today I would say, "...to allow for implementing 2nd Order Business Logic, triggers provide the tightest possible encapsulation of code and data."
My use of the term "best performing" means, for the same amount of disk activity, the fewest round trips, though I am sure that was not clear in the original post.
My use of the term "safest" means least subvertible. While a super-user can always do anything he wants, if he is following the rule not to use a super-user account for regular access, he can actually directly manipulate the data at the console and not frack up the biz rules.
But even as a trigger hawk I would never code a single trigger manually. IMHO they can express far more power than most people appreciate, but only if generated, so that dependencies can be properly sequenced.
Tom, thanks very much for the very flattering link. I continue to receive more hits from your blog day over day than any other source. You must have the most widely read blog in the database world.
If you ever feel so inclined, drop me a line at kdowns@downsfam.net, would love to argue^H^H^H^H^H discuss triggers with you.
POST A COMMENT
<< Home