DB2 Index Extensions by example and in detail

Knut Stolze (stolze@de.ibm.com), Information Integration Development, IBM Germany

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, Senior Technical Consultant for DB2 and WebSphere, IBM Germany

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.

Summary: This article will demonstrate in detail how to use DB2 Index Extensions as well as quering Interval Trees and filtering by User-defined Predicates.

Tag this!

Date: 18 Dec 2003
Level: Introductory
Activity: 803 views

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

Information about download methods Get Adobe® Reader®

About the authors

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.

Comments (Undergoing maintenance)

Trademarks | My developerWorks terms and conditions

Close [x]

Help: Update or add to My dW interests

What's this?

This little timesaver lets you update your My developerWorks profile with just one click! The general subject of this content (AIX and UNIX, Information Management, Lotus, Rational, Tivoli, WebSphere, Java, Linux, Open source, SOA and Web services, Web development, or XML) will be added to the interests section of your profile, if it's not there already. You only need to be logged in to My developerWorks.

And what's the point of adding your interests to your profile? That's how you find other users with the same interests as yours, and see what they're reading and contributing to the community. Your interests also help us recommend relevant developerWorks content to you.

View your My developerWorks profile

Return from help

Close [x]

Help: Remove from My dW interests

What's this?

Removing this interest does not alter your profile, but rather removes this piece of content from a list of all content for which you've indicated interest. In a future enhancement to My developerWorks, you'll be able to see a record of that content.

View your My developerWorks profile

Return from help

static.content.url=http://www.ibm.com/developerworks/js/artrating/

SITE_ID=1

Zone=Information Management

ArticleID=86728

ArticleTitle=DB2 Index Extensions by example and in detail

publish-date=12182003

author1-email=stolze@de.ibm.com

author1-email-cc=

author2-email=TORSTEN@de.ibm.com

author2-email-cc=