article

Free access

Evaluating queries with generalized path expressions

Authors:

Vassilis Christophides,

Guido MoerkotteAuthors Info & Claims

ACM SIGMOD Record, Volume 25, Issue 2

Pages 413 - 422

https://doi.org/10.1145/235968.233358

Published: 01 June 1996 Publication History

Abstract

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.

References

[1]

D. Batory. Extensible cost models and quely optimization in Genesis. IEEE Database Engneerzng, 10(4), November 1987.

[2]

E. Bertino. I~sues in indexing techniques for object-oriented databases. In Proc. of Advanced Database,System Sgmpos~um, pages 151-160, 1989.

[3]

E. Bertino and P. Foscoli. An analytical cost model of object-oriented queiy costs In Proc. Pers,stent Object Systems, pages 151-160, 199'2.

[4]

J. Blaketey, \V. McKenna, and G graefe. Experiences building the Open GOD}3 query optimizer. In Proc. o,f the A CM,5IGAfOD gaul, on Management oJ Data, pages 287-295, 1993.

Digital Library

[5]

E. BettinG, F. Rabitti, and S. Gibbs. Query Processing in a Multimedia Document System. A CM Transact~on~ on Office Information Sgstem~, 6(1)'1-41, January 1988.

Digital Library

[6]

V. Christophides, S. Abiteboul, S. Cluet, and M. Schoi1. From structured documents to novel query facilities. In Proc. of the A 6'M SIGMOD Conf. on Management of Data, pages 3t3-324, Minneapolis, Minnesota, May 1994.

Digital Library

[7]

S. Cluet and G Moerkotte. ChLssifica~tion amd optimization of nested queries in object, b~ses. Technical Report 95-6, RWTH Aachen, 1995.

[8]

S. Chet and G. Moerkotte. Query optimization techmques exploiting class hierarchies. Technical Report 95-7, R\~TH-Aachen, 1995.

[9]

G. Graefe and D. DeWitt. The EXODUS optimizer generator In Proc. of the A CM SIGMOD Conj, on Management of Data, pa.ges 160-172, San Francisco, 1987.

Digital Library

[10]

G. Grade and W McI(enna. The Volcano optimizer generator. Tech. Report 563, University of Colorado, Boulder, 1991.

[11]

G. Graefe and K. Ward. Dynamic query evaluation plans In Proc. of the ACM SIGMOD Conf on Management of Data, pages,358-366, 1989.

Digital Library

[12]

L. M. Haas, J.C. Freytag, G.M. Lohman, emd H. Pirahesh. Extensible query processing in Starburst. In Proc. of the A CM SIGMOD Conf. on Management of Data, pages 377-388, 1989.

Digital Library

[13]

P. Jenq, D. Woelk, W. Kiin, and W. Lee. Query processing in distributed ORION. In Proc. Int Conf. on Extended Database Technology (EDBT), pages 169-187, Venice, 1990.

Digital Library

[14]

MI(ifer, \\:. I<im, and Y. Sagiv. Qumymg object-oriented databases. In Proc. of the ACM,5'IGMOD Conf. on 3{anogemer~t of Data, pages 393-402, 199'2.

Digital Library

[15]

A. Kemper and G. Moerkotte. Access suppmt in object bases. In Proc. of the A CM SIGMOD Conf. on :lganagement of Data., pages 364-374, 1990.

Digital Library

[16]

A. Kemper and G. Moerkotte. Query optimization m object bases: Exploiting relational techniques. In Proc. Dagatuhl Workshop on Query Optimization (J.-C. Freytag, D. Maier und G. Vossen (ads.)). Morgan-Kaufman, 1993.

[17]

A. Kemper, G. Moerkotte, and K. Peithner. A blackboard architecture for query optimization in object bases. In Proc. Int. Conf. on Very Large Data Bases (VLDB), pages 543-554, t993.

Digital Library

[18]

G.M. Lohman. Grammar-like functional rules for representing query optimization alternatives. In Proc. of the A CM SIGMOD Conf. on Management of Data, pages 18-27, 1988.

Digital Library

[19]

G. Mitchell, S. Zdonik, and U. Dayal An architecture for query processing in persistent object stores. In Proc. of the Hawaiian Conf. on Computer and System Sc2enee~, pa.ges 787-798, 1992.

[20]

D. Quass, A. Rajaraman, Y. Sagiv, J. Ullman, and J. Widom. Querying semistructured heterogeneous information. In Proc. Int. Conf. on Deductive and Object-Oriented Databases (DOOD), pages 319-344, Dec. 1995.

Digital Library

[21]

J. Sim4on. Recherche en texte intdgrM et bases de donn4es orient~es-objet.Master's thesis, Universit4 de Nancy I, 1995

Cited By

García RAngles R(2024)Path Querying in Graph Databases: A Systematic Mapping StudyIEEE Access10.1109/ACCESS.2024.337197612(33154-33172)Online publication date: 2024
https://doi.org/10.1109/ACCESS.2024.3371976
Li DHan LDing Y(2010)SQL Query Optimization Methods of Relational Database SystemProceedings of the 2010 Second International Conference on Computer Engineering and Applications - Volume 0110.1109/ICCEA.2010.113(557-560)Online publication date: 19-Mar-2010
https://dl.acm.org/doi/10.1109/ICCEA.2010.113
Bailey JBry FFurche TSchaffert S(2005)Web and semantic web query languagesProceedings of the First international conference on Reasoning Web10.1007/11526988_3(35-133)Online publication date: 25-Jul-2005
https://dl.acm.org/doi/10.1007/11526988_3
Show More Cited By

Index Terms

Evaluating queries with generalized path expressions
1. Information systems
  1. Data management systems
    1. Database management system engines
      1. Database query processing
2. Theory of computation
  1. Theory and algorithms for application domains
    1. Database theory
      1. Database query processing and optimization (theory)

Recommendations

Evaluating queries with generalized path expressions
SIGMOD '96: Proceedings of the 1996 ACM SIGMOD international conference on Management of data

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 ...
Rewriting of Regular Expressions and Regular Path Queries

Recent work on semi-structured data has revitalized the interest in path queries, i.e., queries that ask for all pairs of objects in the database that are connected by a path conforming to a certain specification, in particular to a regular expression. ...
View-based query processing for regular path queries with inverse
PODS '00: Proceedings of the nineteenth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems

View-based query processing is the problem of computing the answer to a query based on a set of materialized views, rather than on the raw data in the database. The problem comes in two different forms, called query rewriting and query answering, ...

Comments

Information & Contributors

Information

Published In

cover image ACM SIGMOD Record

ACM SIGMOD Record Volume 25, Issue 2

June 1996

557 pages

ISSN:0163-5808

DOI:10.1145/235968

Chairman:
T. H. Merrett
McGill Univ.
,
Editors:
H. V. Jagadish,
Inderpal Singh Mumick

Issue’s Table of Contents

SIGMOD '96: Proceedings of the 1996 ACM SIGMOD international conference on Management of data
June 1996
560 pages
ISBN:0897917944
DOI:10.1145/233269
Editor:
Jennifer Widom
Stanford Univ., Stanford, CT

Copyright © 1996 ACM.

Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 June 1996

Published in SIGMOD Volume 25, Issue 2

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

54
Total Citations
View Citations
407
Total Downloads

Downloads (Last 12 months)23
Downloads (Last 6 weeks)6

Reflects downloads up to 12 Aug 2024

Other Metrics

View Author Metrics

Citations

Cited By

García RAngles R(2024)Path Querying in Graph Databases: A Systematic Mapping StudyIEEE Access10.1109/ACCESS.2024.337197612(33154-33172)Online publication date: 2024
https://doi.org/10.1109/ACCESS.2024.3371976
Li DHan LDing Y(2010)SQL Query Optimization Methods of Relational Database SystemProceedings of the 2010 Second International Conference on Computer Engineering and Applications - Volume 0110.1109/ICCEA.2010.113(557-560)Online publication date: 19-Mar-2010
https://dl.acm.org/doi/10.1109/ICCEA.2010.113
Bailey JBry FFurche TSchaffert S(2005)Web and semantic web query languagesProceedings of the First international conference on Reasoning Web10.1007/11526988_3(35-133)Online publication date: 25-Jul-2005
https://dl.acm.org/doi/10.1007/11526988_3
Sipani SVerma KMiller JAleman-Meza B(2004)Designing a high-performance database engine for the 'Db4XML' native XML database systemJournal of Systems and Software10.1016/S0164-1212(03)00077-369:1-2(87-104)Online publication date: 1-Jan-2004
https://dl.acm.org/doi/10.1016/S0164-1212%2803%2900077-3
Bertino EHacid MToumani F(2003)Retrieval of Semistructured Web DataIntelligent Exploration of the Web10.1007/978-3-7908-1772-0_19(304-323)Online publication date: 2003
https://doi.org/10.1007/978-3-7908-1772-0_19
Płodzień JKraken A(2001)Object Query Optimization in the Stack-Based ApproachAdvances in Databases and Information Systems10.1007/3-540-48252-0_23(304-316)Online publication date: 29-Mar-2001
https://doi.org/10.1007/3-540-48252-0_23
Yoon JSungrim Kim (2000)Schema extraction for multimedia XML document retrievalProceedings of the First International Conference on Web Information Systems Engineering10.1109/WISE.2000.882867(113-120)Online publication date: 2000
https://doi.org/10.1109/WISE.2000.882867
Flesca SGreco SZumpano E(2000)Modeling and querying XML-dataProceedings 2000 International Database Engineering and Applications Symposium (Cat. No.PR00789)10.1109/IDEAS.2000.880587(275-283)Online publication date: 2000
https://doi.org/10.1109/IDEAS.2000.880587
Iocchi L(1999)The Web-OEM approach to Web information extractionJournal of Network and Computer Applications10.1006/jnca.1999.009522:4(259-269)Online publication date: 1-Oct-1999
https://dl.acm.org/doi/10.1006/jnca.1999.0095
Fernandez MSuciu D(1998)Optimizing regular path expressions using graph schemasProceedings 14th International Conference on Data Engineering10.1109/ICDE.1998.655753(14-23)Online publication date: 1998
https://doi.org/10.1109/ICDE.1998.655753
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

Media

Figures

Other

Tables

View Issue’s Table of Contents