Options
On the optimization of queries containing regular path expressions
Henrich, Andreas; Jamin, Stefan (1999): On the optimization of queries containing regular path expressions, in: Ron Y. Pinter, Shalom Tsur, Ron Y. Pinter, u. a. (Hrsg.), Next generation information technologies and systems : 4th international workshop, NGITS ’99, Zikhron-Yaakov, Israel, July 5 - 7, 1999 ; proceedings, Berlin u.a.: Springer, S. 58–75, doi: 10.1007/3-540-48521-X_6.
Faculty/Chair:
Author:
Title of the compilation:
Next generation information technologies and systems : 4th international workshop, NGITS '99, Zikhron-Yaakov, Israel, July 5 - 7, 1999 ; proceedings
Editors:
Pinter, Ron Y.
Tsur, Shalom
Conference:
4th international workshop, NGITS '99, July 5 - 7, 1999 ; Zikhron-Yaakov, Israel
Publisher Information:
Year of publication:
1999
Pages:
ISBN:
978-3-540-66225-9
978-3-540-48521-6
Series ; Volume:
Lecture Notes in Computer Science ; 1649
Language:
English
Abstract:
One of the main characteristics of object-oriented database management systems is the explicit representation of relationships between objects. A simple example for a query addressing these relationships arises, if we assume the object types Company, and Division with the relationship has_division from Company to Division. In this case a query might ask for the companies which have a division called "strategy". The query might start with the companies and navigate to the divisions which can be reached via the has_division relationship. Finally the query has to check if the name attribute of the Division object is "strategy". Since there is no direct condition for the companies in the query, this query execution will be costly. If we assume that there is a reverse relationship division_of from Division to Company, an alternative execution plan might start with the "strategy" divisions and follow this reverse relationship. In this case an index structure for the name attribute of the Division objects can be exploited to speed up query processing. In the present paper we describe a query optimizer which exploits this potential invertibility of navigational operations in queries. Our approach is based on, but not limited to the context of the ISO and ECMA standard PCTE and P-OQL.
GND Keywords: ;  ;  ; 
Datenbank
Objektorientierung
Abfragesprache
Regulärer Ausdruck
Keywords:
regular path expressions
DDC Classification:
RVK Classification:
Type:
Conferenceobject
Activation date:
July 13, 2015
Versioning
Question on publication
Permalink
https://fis.uni-bamberg.de/handle/uniba/36047