Alco-Haul: We move spirits.
Demented Deliberations of a Dilettante
Alco-Haul: We move spirits.
Demented Deliberations of a Dilettante
42
A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
Alco-Haul: We move spirits.
Demented Deliberations of a Dilettante
42
<a href="http://www-306.ibm.com/software/rational/bios/ambler.html" target="_blank" rel="nofollow">Scott W. Ambler</a><br />Practice Leader Agile Development, IBM Rational<br /> <br />Now available: <a href="http://www.ambysoft.com/books/refactoringDatabases.html" target="_blank" rel="nofollow">Refactoring Databases: Evolutionary Database Design</a>
Originally posted by Scott Ambler:
At Implementing Referential Integrity and Shared Business Logic I overview several implementation options, including stored procedures, and present their trade-offs. I suspect that it's one of the more balanced discussions on the web regarding this topic. Feedback would be appreciated.
Alco-Haul: We move spirits.
Demented Deliberations of a Dilettante
Scott - aside from a very few typos, it is indeed a well-written article. I understand that you have stayed away from specific technologies as it is meant to cover the concepts (that remain relevant across technologies).
I have a technology specific question. What is the consensus (if any) on Java Stored Procedures? Is there any standardization on them yet, or is each vendor providing their own flavor? JSPs seem to be a much better approach than using any one vendor's programming language extensions to SQL.
<a href="http://www-306.ibm.com/software/rational/bios/ambler.html" target="_blank" rel="nofollow">Scott W. Ambler</a><br />Practice Leader Agile Development, IBM Rational<br /> <br />Now available: <a href="http://www.ambysoft.com/books/refactoringDatabases.html" target="_blank" rel="nofollow">Refactoring Databases: Evolutionary Database Design</a>
Originally posted by Scott Ambler:
Thanks. In private, could you let me know what typos you found if you still remember? I'd like to fix them. Thanks.
I posted a note for you.
I suspect it's not taking off well -- the Oracle DBAs that I know are still writing PL/SQL for example.
That is to be expected. People tend to continue to use what they are comfortable with.
My advice about using vendor-specific features is always the same -- If you do it, be aware that the performance features you're getting are locking you into the vendor, making it that more difficult to port away from them if you have to. However, bottom line is that few companies change DB vendors these days. Once a DB2 shop, always a DB2 shop.
Thanks for the info, I quite agree. Being familiar with Java, I would prefer to be able to use that for my stored procs as well
Alco-Haul: We move spirits.
Demented Deliberations of a Dilettante
Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters? |