|  | Level: Introductory Knut Stolze (stolze@de.ibm.com), Information Integration Development, IBM Germany
Torsten Steinbach, Senior Technical Consultant for DB2 and WebSphere, IBM Germany
18 Dec 2003 This article will demonstrate in detail how to use DB2 Index Extensions as well as quering Interval Trees and filtering by User-defined Predicates.
Introduction
DB2® Universal Database™ offers a wide variety of extensibility mechanisms, including user-defined functions, stored procedures, user-defined types (structured types) and others. Structured types are used to represent complex, application specific objects as single (scalar) values in the database.
Topics covered include:
- Index Processing and Management in DB2
- An Introduction to Interval Trees
- Index Maintenance (Key Generator)
- Index Scans (Range Producer)
- Index Extension and User-defined Predicates
- Defining and Using an Interval Tree Index
Downloads | Description | Name | Size | Download method |
|---|
| Download zip file | interval_tree.zip | 5.7KB | FTP|HTTP |
|---|
| DB2 Index Extensions | 0312stolze.pdf | 395KB | FTP|HTTP |
|---|
About the authors | 
| | Knut Stolze started his work with DB2 when he joined IBM as a visiting scientist at the Silicon Valley Lab where he worked on the DB2 Image Extender. He moved on to the DB2 Spatial Extender Version 8 and was responsible for several enhancements to improve the usability, the performance, and the standard-conformance of the Extender for more than two years.
Currently, he works as a teaching assistant at the University of Jena, Germany, and continues his work for IBM in the area of federated databases. He can be reached through the newsgroups comp.databases.ibm-db2 and ibm.software.db2.udb.spatial or at stolze@de.ibm.com. |
| 
| | Torsten Steinbach
works as a Senior Technical Consultant for DB2 and WebSphere® for IBM Partner Enablement in EMEA. He can be contacted at torsten@de.ibm.com. |
Rate this page
| |
|
