research-article

Pruning nested XQuery queries

Authors:

Talel Abdessalem,

Emmanuel WallerAuthors Info & Claims

CIKM '08: Proceedings of the 17th ACM conference on Information and knowledge management

Pages 541 - 550

https://doi.org/10.1145/1458082.1458154

Published: 26 October 2008 Publication History

Abstract

We present in this paper an approach for XQuery optimization that exploits minimization opportunities raised in composition-style nesting of queries. More precisely, we consider the simplification of XQuery queries in which the intermediate result constructed by a subexpression is queried by another subexpression. Based on a large subset of XQuery, we describe a rule-based algorithm that recursively prunes query expressions, eliminating useless intermediate results. Our algorithm takes as input an XQuery expression that may have navigation within its subexpressions and outputs a simplified, equivalent XQuery expression, and is thus readily usable as an optimization module in any existing XQuery processor. We demonstrate by experiments the impact of our rewriting approach on query evaluation costs and we prove formally its correctness.

References

[1]

S. Abiteboul, O. Benjelloun, B. Cautis, I. Manolescu, T. Milo, and N. Preda. Lazy query evaluation for Active XML. In SIGMOD Conf, 2004.

Digital Library

[2]

V. Benzaken, G. Castagna, D. Colazzo, and K. Nguyen. Type-based XML projection. In VLDB Conf, 2006.

Digital Library

[3]

M. Brantner, C.-C. Kanne, and G. Moerkotte. Let a Single FLWOR Bloom (to improve XQuery plan generation). In XSym Workshop, 2007.

Digital Library

[4]

M. J. Carey, J. Kiernan, J. Shanmugasundaram, E. J. Shekita, and S. N. Subramanian. Xperanto: Middleware for publishing object-relational data as XML documents. In VLDB Conf, 2000.

Digital Library

[5]

A. Deutsch, Y. Papakonstantinou, and Y. Xu. The NEXT Logical Framework for XQuery. In VLDB Conf, 2004.

[6]

X. Dong, A. Y. Halevy, and I. Tatarinov. Containment of nested XML queries. In VLDB Conf, 2004.

Digital Library

[7]

D. Draper, P. Fankhauser, M. F. Fernández, A. Malhotra, K. Rose, M. Rys, J. Siméon, and P. Wadler. XQuery 1.0 and XPath 2.0 Formal Semantics. W3C Recommendation, 2007.

[8]

M. F. Fernández, Y. Kadiyska, D. Suciu, A. Morishima, and W. C. Tan. Silkroute: A framework for publishing relational data in XML. ACM Trans. Database Syst., 27(4), 2002.

Digital Library

[9]

M. F. Fernández and J. Siméon. The Galax System "The XQuery Implementation for Discriminating Hackers" Version 0.7.2, 2007.

[10]

M. Grinev. XQuery Optimizing Based on Rewriting. In ADBIS, 2004.

[11]

B. Gueni, T. Abdessalem, B. Cautis, and E. Waller. Pruning Nested XQuery Queries. Technical report, Telecom ParisTech, http://www.tsi.enst.fr/publications/enst/techreport-2008-8307.pdf, 2008.

Digital Library

[12]

L. M. Haas, M. A. Hernández, H. Ho, L. Popa, and M. Roth. Clio grows up: from research prototype to industrial tool. In SIGMOD Conf, 2005.

Digital Library

[13]

C. Koch. On the role of Composition in XQuery. In WebDB Workshop, 2005.

[14]

A. Malhotra, J. Melton, and N. Walsh. XQuery 1.0 and XPath 2.0 Functions and Operators. W3C Recommendation, 2007.

[15]

I. Manolescu, D. Florescu, and D. Kossmann. Answering XML queries on heterogeneous data sources. In VLDB Conf, 2001.

Digital Library

[16]

A. Marian and J. Siméon. Projecting XML Documents. In VLDB Conf, 2003.

Digital Library

[17]

P. Michiels. XQuery Optimization. In VLDB PhD Workshop, 2003.

[18]

P. Michiels, G. A. Mihaila, and J. Siméon. Put a tree pattern in your algebra. In ICDE Conf, 2007.

[19]

P. Ramanan. Efficient Algorithms for Minimizing Tree Pattern Queries. In SIGMOD Conf, 2002.

Digital Library

[20]

A. Schmidt, F. Waas, M. Kirsten, M. J. Carey, I. Manolescu, and R. Busse. XMark: A Benchmark for XML Data Management. In VLDB Conf, 2002.

Digital Library

[21]

J. Shanmugasundaram, J. Kiernan, E. J. Shekita, C. Fan, and J. Funderburk. Querying XML Views of Relational Data. In VLDB Conf, 2001.

Digital Library

[22]

I. Tatarinov and A. Y. Halevy. Efficient Query Reformulation in Peer-Data Management Systems. In SIGMOD Conf, 2004.

Digital Library

Cited By

Kato HIshihara YGrust TRompf TAlexandrov A(2017)DDO-Free XQueryProceedings of The 16th International Symposium on Database Programming Languages10.1145/3122831.3122832(1-13)Online publication date: 1-Sep-2017
https://dl.acm.org/doi/10.1145/3122831.3122832
KATO HHIDAKA SHU ZNAKANO KISHIHARA Y(2014)Context-preserving XQuery fusionMathematical Structures in Computer Science10.1017/S096012951300008X25:4(916-941)Online publication date: 10-Nov-2014
https://doi.org/10.1017/S096012951300008X
Shaw MDetwiler LBrinkley JSuciu D(2012)A dataflow graph transformation language and query rewriting system for RDF ontologiesProceedings of the 24th international conference on Scientific and Statistical Database Management10.1007/978-3-642-31235-9_36(544-561)Online publication date: 25-Jun-2012
https://dl.acm.org/doi/10.1007/978-3-642-31235-9_36
Show More Cited By

Index Terms

Pruning nested XQuery queries
1. Information systems
  1. Data management systems
    1. Query languages

Recommendations

Optimization of XQuery Queries Including FOR Clauses
ICIW '07: Proceedings of the Second International Conference on Internet and Web Applications and Services

XML has been established as a format for data exchange on the Internet, which has a large volume scale. By the increase of the volume of XML data, applications need to have a standard query language for efficient retrieving and integrating XML data. ...
XML Processing and Data Integration with XQuery

Most Web applications exchange data as XML, but they create and process this data with languages that don't have native support for XML. With appropriate middleware, XQuery can dramatically simplify this process, treating all data sources as though they ...
Enabling Schema-Free XQuery with meaningful query focus

The widespread adoption of XML holds the promise that document structure can be exploited to specify precise database queries. However, users may have only a limited knowledge of the XML structure, and may be unable to produce a correct XQuery ...

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

CIKM '08: Proceedings of the 17th ACM conference on Information and knowledge management

October 2008

1562 pages

ISBN:9781595939913

DOI:10.1145/1458082

General Chair:
James G. Shanahan
Church and Duncan Group Inc, USA
,
Program Chairs:
Sihem Amer-Yahia
Yahoo! Research, USA
,
Ioana Manolescu
INRIA, France
,
Yi Zhang
University of California, Santa Cruz, USA
,
David A. Evans
JustSystems Evans Research, USA
,
Alek Kolcz
Microsoft Live Labs, USA
,
Key-Sun Choi
KAIST, Korea
,
Abdur Chowdury
Twitter, USA

Copyright © 2008 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]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 26 October 2008

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Research-article

Conference

CIKM08

Sponsor:

CIKM08: Conference on Information and Knowledge Management

October 26 - 30, 2008

California, Napa Valley, USA

Acceptance Rates

Overall Acceptance Rate 1,861 of 8,427 submissions, 22%

Upcoming Conference

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

6
Total Citations
View Citations
258
Total Downloads

Downloads (Last 12 months)2
Downloads (Last 6 weeks)0

Reflects downloads up to 30 Aug 2024

Other Metrics

View Author Metrics

Citations

Cited By

Kato HIshihara YGrust TRompf TAlexandrov A(2017)DDO-Free XQueryProceedings of The 16th International Symposium on Database Programming Languages10.1145/3122831.3122832(1-13)Online publication date: 1-Sep-2017
https://dl.acm.org/doi/10.1145/3122831.3122832
KATO HHIDAKA SHU ZNAKANO KISHIHARA Y(2014)Context-preserving XQuery fusionMathematical Structures in Computer Science10.1017/S096012951300008X25:4(916-941)Online publication date: 10-Nov-2014
https://doi.org/10.1017/S096012951300008X
Shaw MDetwiler LBrinkley JSuciu D(2012)A dataflow graph transformation language and query rewriting system for RDF ontologiesProceedings of the 24th international conference on Scientific and Statistical Database Management10.1007/978-3-642-31235-9_36(544-561)Online publication date: 25-Jun-2012
https://dl.acm.org/doi/10.1007/978-3-642-31235-9_36
Almendros-Jimenez JSilva JTamarit S(2011)XQuery optimization based on program slicingProceedings of the 20th ACM international conference on Information and knowledge management10.1145/2063576.2063794(1525-1534)Online publication date: 24-Oct-2011
https://dl.acm.org/doi/10.1145/2063576.2063794
Kato HHidaka SHu ZNakano KIshihara Y(2010)Context-preserving XQuery fusionProceedings of the 8th Asian conference on Programming languages and systems10.5555/1947873.1947897(255-270)Online publication date: 28-Nov-2010
https://dl.acm.org/doi/10.5555/1947873.1947897
Kato HHidaka SHu ZNakano KIshihara Y(2010)Context-Preserving XQuery FusionProgramming Languages and Systems10.1007/978-3-642-17164-2_18(255-270)Online publication date: 2010
https://doi.org/10.1007/978-3-642-17164-2_18

View Options

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

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Media

Figures

Other

Tables

View Table of Contents