Using Stored Procedures, Views, and Triggers
Server-side processing, which is when you let a server process your queries and the like, is probably a concept you have heard of and it’s the very topic of this chapter. Well, to some extent anyway. I discuss three specific ways of doing server-side processing: stored procedures, triggers, and views. The good thing about server-side processing is that you can use the power and resources of your server for doing purely data-related processing and thus leave your client free to do other stuff, and your network clearer of data that the client doesn’t want. It’s not always appropriate to do so, but in many cases you can benefit from it.
KeywordsBusiness Rule Database Program Output Argument Input Argument Store Procedure
Unable to display preview. Download preview PDF.