Gesellschaft für Informatik e.V.

Lecture Notes in Informatics

BTW 2003, Datenbanksysteme für Business, Technologie und Web, Tagungsband der 10. BTWKonferenz, 26.-28. Februar 2003, Leipzig. P-26, 285-304 (2003).

GI, Gesellschaft für Informatik, Bonn


Gerhard Weikum (ed.), Harald Schöning (ed.), Erhard Rahm (ed.)

Copyright © GI, Gesellschaft für Informatik, Bonn


The paradigm of relational indexing: A survey

Hans-Peter Kriegel , Martin Pfeifle , Marco Pötke and Thomas Seidl


In order to achieve efficient execution plans for queries comprising userdefined data types and predicates, the database system has to be provided with appropriate index structures, query processing methods, and optimization rules. Although available extensible indexing frameworks provide a gateway to seamlessly integrate user-defined access methods into the standard process of query optimization and execution, they do not facilitate the actual implementation of the access method itself. An internal enhancement of the database kernel is usually not an option for database developers. The embedding of a custom block-oriented index structure into concurrency control, recovery services and buffer management would cause extensive implementation efforts and maintenance cost, at the risk of weakening the reliability of the entire system. The server stability can be preserved by delegating index operations to an external process, but this approach induces severe performance bottlenecks due to context switches and inter-process communication. Therefore, we present in this paper the paradigm of relational access methods that perfectly fits to the common relational data model and is highly compatible with the extensible indexing frameworks of existing object-relational database systems.

Full Text: PDF

GI, Gesellschaft für Informatik, Bonn
ISBN 3-88579-355-5

Last changed 04.10.2013 17:56:36