Abstract
One of the most important factors for success of native XML database systems is a powerful query optimizer. Surprisingly, little has been done to develop cost models to enable cost-based optimization in such systems. Since the entire optimization process is so complex, only a stepwise approach will lead to a satisfying (future) solution. In this work, we are paving the way for cost-based XML query optimization by developing cost formulae for two important join operators, which allow to perform join reordering and join fusion in a cost-aware way, and, therefore, make joint application of Structural Joins and Holistic Twig Joins possible.
Financial support by the Research Center (CM)2 of the University of Kaiserslautern is acknowledged (http://cmcm.uni-kl.de)
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Aguiar Moraes Filho, J., Härder, T.: EXsum—An XML Summarization Framework. In: Proc. IDEAS Conference, pp. 139–148 (2008)
Al-Khalifa, S., Jagadish, H.V., Patel, J.M., Wu, Y., Koudas, N., Srivastava, D.: Structural Joins: A Primitive for Efficient XML Query Pattern Matching. In: Proc. ICDE Conference, pp. 141–154 (2002)
Balmin, A., Eliaz, T., Hornibrook, J., Lim, L., Lohman, G.M., Simmen, D.E., Wang, M., Zhang, C.: Cost-based Optimization in DB2 XML. IBM Systems Journal 45(2), 299–320 (2006)
Bruno, N., Koudas, N., Srivastava, D.: Holistic Twig Joins: Optimal XML Pattern Matching. In: Proc. SIGMOD Conference, pp. 310–321 (2002)
Härder, T., Haustein, M.P., Mathis, C., Wagner, M.: Node Labeling Schemes for Dynamic XML Documents Reconsidered. Data & Knowledge Engineering 60(1), 126–149 (2007)
Haustein, M., Härder, T.: An Efficient Infrastructure for Native Transactional XML Processing. Data & Knowledge Engineering 61(3), 500–523 (2007)
Ioannidis, Y.E., Wong, E.: Query Optimization by Simulated Annealing. In: Proc. SIGMOD Conference, pp. 9–22 (1987)
Jiang, H., Wang, W., Lu, H., Yu, J.X.: Holistic Twig Joins on Indexed XML Documents. In: Proc. VLDB Conference, pp. 273–284 (2003)
McHugh, J., Widom, J.: Query Optimization for XML. In: Proc. VLDB Conference, pp. 315–326 (1999)
Polyzotis, N., Garofalakis, M.N.: Structure and Value Synopses for XML Data Graphs. In: Proc. VLDB Conference, pp. 466–477 (2002)
Schmidt, A., Waas, F., Kersten, M.L., Carey, M.J., Manolescu, I., Busse, R.: XMark: A Benchmark for XML Data Management. In: Proc. VLDB Conference, pp. 974–985 (2002)
Selinger, P.G., Astrahan, M.M., Chamberlin, D.D., Lorie, R.A., Price, T.G.: Access Path Selection in a Relational Database Management System. In: Proc. SIGMOD Conference, pp. 23–34 (1979)
Wang, W., Jiang, H., Lu, H., Yu, J.X.: Bloom Histogram: Path Selectivity Estimation for XML Data with Updates. In: Proc. VLDB Conference, pp. 240–251 (2004)
Weiner, A.M.: Framework-Based Development and Evaluation of Cost-Based Native XML Query Optimization Techniques. Appears in: Proc. VLDB PhD Workshop (2009)
Weiner, A.M., Mathis, C., Härder, T.: Rules for Query Rewrite in Native XML Databases. In: Proc. EDBT DataX Workshop, pp. 21–26 (2008)
Wu, Y., Patel, J., Jagadish, H.: Structural Join Order Selection for XML Query Optimization. In: Proc. ICDE Conference, pp. 443–454 (2003)
Zhang, N., Haas, P.J., Josifovski, V., Lohman, G.M., Zhang, C.: Statistical Learning Techniques for Costing XML Queries. In: Proc. VLDB Conference, pp. 289–300 (2005)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Weiner, A.M., Härder, T. (2009). Using Structural Joins and Holistic Twig Joins for Native XML Query Optimization. In: Grundspenkis, J., Morzy, T., Vossen, G. (eds) Advances in Databases and Information Systems. ADBIS 2009. Lecture Notes in Computer Science, vol 5739. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-03973-7_12
Download citation
DOI: https://doi.org/10.1007/978-3-642-03973-7_12
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-03972-0
Online ISBN: 978-3-642-03973-7
eBook Packages: Computer ScienceComputer Science (R0)