Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
skip to main content
10.1145/1866480.1866491acmconferencesArticle/Chapter ViewAbstractPublication PagesideasConference Proceedingsconference-collections
research-article

An integrative approach to query optimization in native XML database management systems

Published: 16 August 2010 Publication History

Abstract

Even though an effective cost-based query optimizer is of utmost importance for the efficient evaluation of XQuery expressions in native XML database systems, such a component is currently out of sight, because former approaches do not pay attention to the latest advances in the area of physical operators (e. g., Holistic Twig Joins and advanced indexes) or just focus only on some of them.
To support the development of native XML query optimizers, we introduce an extensible cost-based optimization framework that integrates the cutting-edge XML query evaluation operators into a single system. Using the well-known plan generation techniques from the relational world and a novel set of plan equivalences---which allows for the generation of alternative query plans consisting of Structural Joins, Holistic Twig Joins, and numerous indexes (especially path indexes and content-and-structure indexes)---our optimizer can now benefit from the knowledge on native XML query evaluation to speed-up query execution significantly.

References

[1]
}}J. Aguiar Moraes Filho and T. Härder. EXsum---An XML Summarization Framework. In Proc. IDEAS, pages 139--148, 2008.
[2]
}}S. Al-Khalifa et al. Structural Joins: A Primitive for Efficient XML Query Pattern Matching. In Proc. ICDE, pages 141--154, 2002.
[3]
}}A. Balmin et al. Cost-based Optimization in DB2 XML. IBM Systems Journal, 45(2):299--320, 2006.
[4]
}}N. Bruno et al. Holistic Twig Joins: Optimal XML Pattern Matching. In Proc. SIGMOD, pages 310--321, 2002.
[5]
}}D. Che, K. Aberer, and M. T. Özsu. Query optimization in xml structured-document databases. VLDB Journal, 15(3):263--289, 2006.
[6]
}}B. F. Cooper et al. A Fast Index for Semistructured Data. In Proc. VLDB, pages 341--350, 2001.
[7]
}}H. Georgiadis et al. Cost Based Plan Selection for XPath. In Proc. SIGMOD, pages 603--614, 2009.
[8]
}}R. Goldman and J. Widom. DataGuides: Enabling Query Formulation and Optimization in Semistructured Databases. In Proc. VLDB, pages 436--445, 1997.
[9]
}}G. Graefe. The Cascades Framework for Query Optimization. IEEE Data Eng. Bull., 18(3):19--29, 1995.
[10]
}}G. Graefe and D. J. DeWitt. The EXODUS Optimizer Generator. In Proc. SIGMOD, pages 160--172, 1987.
[11]
}}G. Graefe and W. J. McKenna. The Volcano Optimizer Generator: Extensibility and Efficient Search. In Proc. ICDE, pages 209--218, 1993.
[12]
}}H. Jiang et al. Holistic Twig Joins on Indexed XML Documents. In Proc. VLDB, pages 273--284, 2003.
[13]
}}N. Kabra and D. J. DeWitt. OPT++: An Object-Oriented Implementation for Extensible Database Query Optimization. VLDB Journal, 8(1):55--78, 1999.
[14]
}}R. S. G. Lanzelotte and P. Valduriez. Extending the Search Strategy in a Query Optimizer. In Proc. VLDB, pages 363--373, 1991.
[15]
}}C. Mathis. Storing, Indexing, and Querying XML Documents in Native XML Database Management Systems. PhD thesis, Univ. of Kaiserslautern, 2009.
[16]
}}J. McHugh and J. Widom. Query Optimization for XML. In Proc. VLDB, pages 315--326, 1999.
[17]
}}T. Milo and D. Suciu. Index Structures for Path Expressions. In Proc. ICDT, pages 277--295, 1999.
[18]
}}P. E. O'Neil et al. ORDPATHs: Insert-Friendly XML Node Labels. In Proc. SIGMOD, pages 903--908, 2004.
[19]
}}H. Pirahesh et al. Extensible/Rule Based Query Rewrite Optimization in Starburst. In Proc. SIGMOD, pages 39--48, 1992.
[20]
}}A. Schmidt et al. XMark: A Benchmark for XML Data Management. In Proc. VLDB, pages 974--985, 2002.
[21]
}}K. Schmidt and T. Härder. On The Use of Query-Driven XML Auto-Indexing. In Proc. ICDE SMDB Workshop, 2010.
[22]
}}P. G. Selinger et al. Access Path Selection in a Relational Database Management System. In Proc. SIGMOD, pages 23--34, 1979.
[23]
}}A. M. Weiner et al. Rules for Query Rewrite in Native XML Databases. In Proc. EDBT DataX Workshop, pages 21--26, 2008.
[24]
}}A. M. Weiner and T. Härder. Using Structural Joins and Holistic Twig Joins for Native XML Query Optimization. In Proc. ADBIS, LNCS 5739, pages 149--163, 2009.
[25]
}}Y. Wu et al. Structural Join Order Selection for XML Query Optimization. In Proc. ICDE, pages 443--454, 2003.
[26]
}}N. Zhang et al. Statistical Learning Techniques for Costing XML Queries. In Proc. VLDB, pages 289--300, 2005.

Cited By

View all

Recommendations

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences
IDEAS '10: Proceedings of the Fourteenth International Database Engineering & Applications Symposium
August 2010
282 pages
ISBN:9781605589008
DOI:10.1145/1866480
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: 16 August 2010

Permissions

Request permissions for this article.

Check for updates

Qualifiers

  • Research-article

Conference

IDEAS '10
Sponsor:
  • ACM
  • Concordia University

Acceptance Rates

Overall Acceptance Rate 74 of 210 submissions, 35%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)2
  • Downloads (Last 6 weeks)0
Reflects downloads up to 20 Jan 2025

Other Metrics

Citations

Cited By

View all

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media