This guide aims to help the reader understand Informix stored procedures, which can be used to improve the performance of SQL code, tighten security, reduce maintenance of permissions and maximize data integrity. The structure, program logic flow and control of stored procedures, as used in the Informix Stored Procedure Language (SPL) - Informix' version of middleware is included. Examples which show how to design and apply stored procedures of the right size and scope are also documented in the text. The author shows how stored procedures can be used to optimize code while improving security and data integrity. A comprehensive SPL syntax reference is included, as are more than 20 stored procedures that can be used or adapted by the reader.
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Maße
Höhe: 234 mm
Breite: 180 mm
Dicke: 7 mm
Gewicht
ISBN-13
978-0-13-206723-2 (9780132067232)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
Preface.
What You Need to Know before Starting. The Scope of This Handbook. Handbook Format. Chapter. Introduction. The Promise of Stored Procedures. The Balance between Database Independence and Data Integrity.
Chapter 2.
Defining Stored Procedures. What Is a Stored Procedure? What Can You Do with SPs? How Are SPL Objects Created? Where Are SPL Objects Stored? How Are SPs Executed?
Chapter 3.
Dissecting Stored Procedures. Paired PROCEDURE Statements. Returning Values. Stored Procedure Arguments. Defining Program Variables. Statement Blocks.
Chapter 4.
Controlling Stored Procedures. Invoking Stored Procedures. Flow Control. Error Trapping. Database Paths and SPL Objects.
Chapter 5.
Speeding Up with SPs. The Client/Server. An MIS Ritual. A Typical 4GL Data Manipulation Strategy. The Optimum Freight Object. The Efficiency of Encapsulation.
Chapter 6.
Fortifying Security. The Sphere of Security. Security GRANTs. Security and Stored Procedures.
Chapter 7.
Protecting Data Integrity. Transaction Logging. The Shotgun Approach to Transactions. The Rifle Approach to Transactions. Adherence to Business Rules.
Chapter 8.
Determining Right Size, Right Scope. Comparison Model. The Post-it Test. An Object Survey.
Chapter 9.
Applying Stored Procedures. "Loosely Coupled" Data Replication. Chronological Audit Archiving.
Appendix A. SPL Reference Manual Pages.
Appendix B. Stored Procedure Errors.
Appendix C. Orders-R-Us Database, Orders-R-Us Company Structure.
Appendix D. SPL Version Differences. Additional Features of Informix 6.x SPs. Additional Features of Informix 7.x SPs
Appendix E. SP Object Pack Review.
Function: Loosely Coupled Data Replication.
Function: Chronological Audit Archiving.
Function: Encryptor/Decryptor.
Function: Root Calculator.
Function: Stored Procedure Monitor.
Function: Stored Procedure Query.
Function: Stored Procedure Schema.
Key Word Glossary.
Index.
