Stored Procedures and Triggers and the Object-Oriented Project
Client/server server technology really began to take shape in the late 1980s and early 1990s. One technology that boosted its credibility was the stored procedure and trigger. Initially offered by Sybase in its SQL Server product, the technology today is supported by most major database vendors.
Stored procedures and triggers gained wide acceptance for several reasons:
They provide for the precompilation of SQL and procedural programming logic (if...then...else) into a tightly bound database object that can be invoked from a client or another server that is acting as a client to yet another server.
They provide performance advantages over dynamic SQL (i.e., SQL that originates at the ...
Get Developing Applications with Java™ and UML now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
