Options
On the optimization of queries containing regular path expressions
Henrich, Andreas; Jamin, Stefan (2025): On the optimization of queries containing regular path expressions, in: Bamberg: Otto-Friedrich-Universität, S. 58–75.
Faculty/Chair:
Author:
Publisher Information:
Year of publication:
2025
Pages:
Series ; Volume:
Source/Other editions:
Ron Y. Pinter und Shalom Tsur (Hrsg.), Next generation information technologies and systems : 4th international workshop, NGITS ’99, Zikhron-Yaakov, Israel, July 5 - 7, 1999 ; proceedings, Berlin u.a.: Springer, 1999, S. 58–75, ISBN: 978-3-540-66225-9, 978-3-540-48521-6
Year of first publication:
1999
Language:
English
Licence:
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:
June 3, 2025
Permalink
https://fis.uni-bamberg.de/handle/uniba/106991