Evaluating queries with generalized path expressions

In the past few years, query languages featuring generalized path expressions have been proposed. These languages allow the interrogation of both data and structure. They are powerful and essential for a number of applications. However, until now, their evaluation has relied on a rather naive and inefficient algorithm.In this paper, we extend an object algebra with two new operators and present some interesting rewriting techniques for queries featuring generalized path expressions. We also show how a query optimizer can integrate the new techniques.

[1]  Guido Moerkotte,et al.  Query Optimization Techniques Exploiting Class Hierarchies , 1995 .

[2]  Elisa Bertino,et al.  Query processing in a multimedia document system , 1988, TOIS.

[3]  Won Kim,et al.  Indexing Techniques for Object-Oriented Databases , 1989, Object-Oriented Concepts, Databases, and Applications.

[4]  Darrell Woelk,et al.  Query Processing in Distributed ORION , 1990, EDBT.

[5]  Guido Moerkotte,et al.  Access support in object bases , 1990, SIGMOD '90.

[6]  Don Batory,et al.  Extensible Cost Models and Query Optimization in GENESIS. , 1986 .

[7]  Hamid Pirahesh,et al.  Extensible query processing in starburst , 1989, SIGMOD '89.

[8]  Goetz Graefe,et al.  The Volcano Optimizer Generator , 1991, ICDE 1991.

[9]  Serge Abiteboul,et al.  From structured documents to novel query facilities , 1994, SIGMOD '94.

[10]  Michael Kifer,et al.  Querying object-oriented databases , 1992, SIGMOD '92.

[11]  Guido Moerkotte,et al.  Classification And Optimization of Nested Queries in Object Bases , 1994, BDA.

[12]  Stanley B. Zdonik,et al.  An architecture for query processing in persistent object stores , 1992, Proceedings of the Twenty-Fifth Hawaii International Conference on System Sciences.

[13]  Guido Moerkotte,et al.  A Blackboard Architecture for Query Optimization in Object Bases , 1993, VLDB.

[14]  Guy M. Lohman,et al.  Grammar-like functional rules for representing query optimization alternatives , 1988, SIGMOD '88.

[15]  Jennifer Widom,et al.  Querying Semistructured Heterogeneous Information , 1995, J. Syst. Integr..

[16]  Goetz Graefe,et al.  Experiences building the open OODB query optimizer , 1993, SIGMOD Conference.

[17]  Karen Ward,et al.  Dynamic query evaluation plans , 1989, SIGMOD '89.

[18]  Guido Moerkotte,et al.  Query Optimization in Object Bases: Exploiting Relational Techniques , 1991, Query Processing for Advanced Database Systems.

[19]  David J. DeWitt,et al.  The EXODUS optimizer generator , 1987, SIGMOD '87.