Open-Source Components for Informix Dynamic Server 9.x

Open-Source Components for Informix Dynamic Server 9.x

By (author)  , By (author)  , By (author)  , By (author) 

List price: US$58.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks


A practical guide to open-source components for the Informix Dynamic Server 9.x (IDS 9.x). It describes a set of useful open-source components that, after installation into IDS 9.x, provide increased functionality. All the possibilities provided by the IDS 9.x technology are covered.
show more

Product details

  • Mixed media product | 512 pages
  • 178.3 x 233.2 x 35.6mm | 988.84g
  • Prentice Hall
  • Upper Saddle River, United States
  • English
  • 0130428272
  • 9780130428271

Table of contents



1. Taking Advantage of Database Extensibility.

Software Extensibility. How Do We Call It? IDS 9.x Object-Relational Features. Usage Examples. A New Approach to Problem Solving. What's Next?

2. Solving Hierarchical Problems with the Node Component.

Node and Hierarchies. Node versus Relational Implementation. Hierarchical Problems. Functions Overview. Indexing and SQL Statements. Client Access. Installation. Limitations and Improvements. Node Component Location. Acknowledgments.

3. Time Is on Our Side: Temporal Extensions to SQ.

Introduction to Temporal Data Management. Shortcomings of SQL-92 and Goals of the Period Bladelet. Overview of Period Bladelet. UDTs in Period Bladelet. UDFs for Temporal Operations. UDA. Statistics and Selectivity. Summary and Conclusions.

4. Accessing External Files through SQL.

RDBMS Characteristics. The VTI Interface. VTI Description. The Flat-File Interface. Creating an Access Method. Creating a Table. Using the Table. Supported Types. Installation. Registration. Removal. Limitations and Improvements. Flat-File Component Location. Acknowledgments. Reference.

5. SQL as a Data Type.

Overview of the Exec SQL Bladelet. Drawbacks and Limitations. Implementation Details for Exec SQL Bladelet. Application Example Using Exec SQL Bladelet. Summary and Conclusions.

6. Managing a World of Shapes.

The Problem That Shapes Solves. Shape Data Types. Functions Overview. Indexing and SQL Statements. Client Access. Installation. Limitations. Shapes Bladelet Location. Acknowledgments.

7. Whose SQL Is It?

How Do Nonstandard Features Come About? Why Not Stick to Standards? Solving the Portability Problem. Example 1: Oracle Compatibility. Example 2: IBM Compatibility. Conclusion. Obtaining SqlLib and Iutil. Acknowledgments.

8. Manipulating Text with Regular Expressions.

Regular Expressions. Regexp SQL Routines Overview. Built-in SQL Functions Overview. Regexp versus Built-In SQL Functions. Performance. Installation. Limitations and Improvements. Regexp Bladelet Location. Acknowledgments.

9. Removing the LVARCHAR Size Limit.

The Problem That mrLvarchar Solves. Candidate Data Types. Functions Overview. Inserting Data. Selecting and Searching Data. Extracting Substrings. Modifying Data. System Administration. Indexing and SQL Statement. Client Access. Installation. Limitations. mrLvarchar Bladelet Location. Acknowledgments.

10. Images Are Data, Too.

Using BLOBs in Image-Enabled Applications. The JPEG Image Format. The LLD Module. JPGImage Bladelet Features. Using the JPGImage Bladelet. Conclusion. JPGImage Bladelet Locatio. Acknowledgments.

11. Multiple Versions of Your Data.

Using VTable. Limitations and Future Enhancements. Where to Get the VTable Distribution. Acknowledgments.

Appendix A: Node Bladelet Functions Reference.

Appendix B: Period Bladelet Functions Reference.

Appendix C: Flat-File Interface Functions Reference.

Appendix D: Exec SQL Bladelet Functions Reference.

Appendix E: Shapes Bladelet Functions Reference.

Appendix F: SqlLib Bladelet Functions Reference.

Appendix G: IUtil Functions Reference.

Appendix H: Regexp Bladelet Functions Reference.

Appendix I: mrLvarchar Bladelet Functions Reference.

Appendix J: JPGImage Bladelet Functions Reference.

Appendix K: VTable Functions Reference.

Appendix L: Building and Deploying DataBlade Executable Objects.

show more

About Jean T. Anderson

JACQUES ROY, one of Informix' leading evangelists on database extensibility, is author of Informix Dynamic Server.2000: Server-Side Programming in C (Prentice Hall PTR).

WILLIAM W. WHITE, senior engineer at Informix, works with DataBlade Partners and internal engineers on projects related to database extensibility, and is a frequent contributor to the Informix Developers Network (IDN).

JEAN ANDERSON is a Senior Engineer in Informix Datablade Partner Engineering specializing in helping developers implement server extensions. She has authored many technical notes and projects at IDN's DataBlade Corner.

PAUL G. BROWN of Informix Labs is a prominent object-relational evangelist and author of Object-Relational Database Development, a Plumber's Guide (Prentice Hall PTR).
show more