Article

Locking-aware structural join operators for XML query processing

Authors:

Christian Mathis,

Michael HausteinAuthors Info & Claims

SIGMOD '06: Proceedings of the 2006 ACM SIGMOD international conference on Management of data

Pages 467 - 478

https://doi.org/10.1145/1142473.1142526

Published: 27 June 2006 Publication History

Abstract

As observed in many publications so far, the matching of twig pattern queries (i.e., queries that contain only the child and the descendant axis) is a core operation in XML database management systems (XDBMSs) for which the structural join and the holistic twig join algorithms were proposed. In a single-user environment, especially the latter algorithm provides a good evaluation strategy. However, when it comes to multi-user access to a single XML document, it may lead to extensive blocking situations: The XDBMS has to ensure data consistency and, therefore, has to prevent concurrent modification operations from changing elements in the input sequences, a holistic twig algorithm accesses while operating. To circumvent this problem, we propose a set of new locking-aware operators for twig pattern query evaluation that rely on stable path labels (SPLIDs) as well as document and element set indexes. Furthermore, by running extensive tests on our own XDBMS, we show that their performance is comparable to existing approaches in a single-user environment, and leads to higher throughput rates in the case of multi-user access.

References

[1]

Al-Khalifa, S., Jagadish, H. V., Patel, J. M., Wu, Y., Koudas, N., and Srivastava, D. Structural Joins: A Primitive for Efficient XML Query Pattern Matching. In Proc. ICDE: 141--152 (2002)

Digital Library

[2]

Beyer, K. S., Cochrane, R., Josifovski, V., Kleewein, J., Lapis, G, Lohman, G. M., Lyle, B., Ozcan, F., Pirahesh, H., Seemann, N., Truong, T. C., Van der Linden, B., Vickery, B., and Zhang, C. System RX: One Part Relational, One Part XML. In Proc. SIGMOD Conference: 347-358 (2005)

Digital Library

[3]

Böhme, T., and Rahm, E. Supporting Efficient Streaming and Insertion of XML Data in RDBMS. In Proc. 3rd DIWeb Workshop: 70--81 (2004)

[4]

Bruno, N., Koudas, N., and Srivastava, D. Holistic twig joins: optimal XML pattern matching. In Proc. SIGMOD Conference: 310-321 (2002)

Digital Library

[5]

Christophides, V., Plexousakis, D., Scholl, M., and Tourtounis, S. On Labeling Schemes for the Semantic Web. In Proc. 12th Int. WWW Conference: 544--555 (2003)

Digital Library

[6]

Dewey, M. Dewey Decimal Classification System. http://www.mtsu.edu/~vvesper/dewey.html

[7]

Cohen, E., Kaplan, H., and Milo, T. Labeling Dynamic XML Trees.In Proc. PODS Conference: 271--281 (2002)

Digital Library

[8]

Fontoura, M., Josifovski, V., Shekita, E., and Yang, B. Optimizing Cursor Movement in Holistic Twig Joins, In Proc. 14th CIKM: 784--791 (2005)

Digital Library

[9]

Gottlob, G., Koch, C., Pichler, R. Efficient Algorithms for Processing XPath Queries, In Proc. VLDB Conference: 95--106 (2002)

Digital Library

[10]

Gray, J. and Reuter, A. Transaction Processing: Concepts and Techniques. Morgan Kaufmann (1993)

Digital Library

[11]

Härder, T., Haustein, M., Mathis, C., and Wagner, M. Node Labeling Schemes for Dynamic XML Documents Reconsidered, Data & Knowl. Engineering, Elsevier (2006)

[12]

Haustein, M. Fine-Ganular Transaction Isolation in Native XML DBS (in German). Ph.D. Thesis, Univ. Kaiserslautern (2005)

[13]

Haustein, M., and Härder, T. Adjustable Transaction Isolation in XML Database Management Systems. In Proc. 2nd Int. XML Database Symposium: 173--188, LNCS 3186, Springer (2004)

[14]

Haustein, M., Herder, T., Mathis, C., and Wagner, M. Dew-eyIDs-The Key to Fine-Grained Management of XML Documents. In Proc. 20th Brasilian Symposium on Databases: 85--99 (2005)

[15]

Jiang, H., Wang, W., Lu, H., and Xu Yu, J. Holistic Twig Joins on Indexed XML Documents. In Proc. VLDB Conference: 273--284 (2003)

Digital Library

[16]

Jiang, H., Lu, H., and Wang, W. Efficient Processing of XML Twig Queries with OR-Predicates. In Proc. SIGMOD Conference: 59--70 (2004)

Digital Library

[17]

Mohan, C. ARIES/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes. In Proc. VLDB Conference: 392--405 (1990)

Digital Library

[18]

O'Neil, P. E., O'Neil, E. J., Pal, S., Cseri, I., Schaller, G., and Westbury, N. ORDPATHs: Insert-Friendly XML Node Labels. In Proc. SIGMOD Conference: 903--908 (2004)

Digital Library

[19]

Schmidt, A. R., Waas, F., Kersten, M. L., Carey, M. J., Manolescu, I., and Busse, R. XMark: A Benchmark for XML Data Management. In Proc. VLDB Conference: 974--985 (2002)

Digital Library

[20]

Tatarinov, I., Viglas, S., Beyer, K. S., Shanmugasundaram, J., Shekita, E. J., and Zhang, C. Storing and Querying Ordered XML Using a Relational Database System. In Proc. SIGMOD Conference: 204--215 (2002)

Digital Library

[21]

W3C Recommendations. http://www.w3c.org (2004)

[22]

Zhang, C., Naughton, J., DeWitt, D., Luo, Q., and Lohmann, G M. On Supporting Containment Queries in Relational Database Management Systems. In Proc. SIGMOD Conference: 425--436 (2001)

Digital Library

Cited By

Ma ZLiu JYan L(2011)Matching twigs in fuzzy XMLInformation Sciences: an International Journal10.1016/j.ins.2010.09.001181:1(184-200)Online publication date: 1-Jan-2011
https://dl.acm.org/doi/10.1016/j.ins.2010.09.001
Machdi IAmagasa TKitagawa H(2010)Parallel holistic twig joins on a multi‐core systemInternational Journal of Web Information Systems10.1108/174400810110531316:2(149-177)Online publication date: 22-Jun-2010
https://doi.org/10.1108/17440081011053131
Feng JLiu LLi GLi JSun Y(2010)An efficient parallel pathstack algorithm for processing XML twig queries on multi-core systemsProceedings of the 15th international conference on Database Systems for Advanced Applications - Volume Part I10.1007/978-3-642-12026-8_22(277-291)Online publication date: 1-Apr-2010
https://dl.acm.org/doi/10.1007/978-3-642-12026-8_22
Show More Cited By

Index Terms

Locking-aware structural join operators for XML query processing
1. Information systems
  1. Data management systems
    1. Data structures
      1. Data access methods

Recommendations

Efficient structural query processing in xml databases
Combining Joint and Semi-Join Operations for Distributed Query Processing

The application of a combination of join and semi-join operations to minimize the amount of data transmission required for distributed query processing is discussed. Specifically, two important concepts that occur with the use of join operations as ...
Processing XPath queries with XML summaries
CIKM '05: Proceedings of the 14th ACM international conference on Information and knowledge management

Range labeling and structural joins are well-studied techniques for efficiently processing XPath queries. However, when XPath queries become long, many times of structural joins are required. To solve this problem, we developed a method to reduce the ...

Comments

Information & Contributors

Information

Published In

cover image ACM Conferences

SIGMOD '06: Proceedings of the 2006 ACM SIGMOD international conference on Management of data

June 2006

830 pages

ISBN:1595934340

DOI:10.1145/1142473

General Chairs:
Clement Yu
University of Illinois at Chicago
,
Peter Scheuermann
Northwestern University
,
Program Chair:
Surajit Chaudhuri
Microsoft Research

Copyright © 2006 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: 27 June 2006

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Author Tags

Qualifiers

Article

Conference

SIGMOD/PODS06

Sponsor:

SIGMOD/PODS06: International Conference on Management of Data and Symposium on Principles Database and Systems

June 27 - 29, 2006

IL, Chicago, USA

Acceptance Rates

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

13
Total Citations
View Citations
619
Total Downloads

Downloads (Last 12 months)3
Downloads (Last 6 weeks)1

Reflects downloads up to 10 Feb 2025

Other Metrics

View Author Metrics

Citations

Cited By

Ma ZLiu JYan L(2011)Matching twigs in fuzzy XMLInformation Sciences: an International Journal10.1016/j.ins.2010.09.001181:1(184-200)Online publication date: 1-Jan-2011
https://dl.acm.org/doi/10.1016/j.ins.2010.09.001
Machdi IAmagasa TKitagawa H(2010)Parallel holistic twig joins on a multi‐core systemInternational Journal of Web Information Systems10.1108/174400810110531316:2(149-177)Online publication date: 22-Jun-2010
https://doi.org/10.1108/17440081011053131
Feng JLiu LLi GLi JSun Y(2010)An efficient parallel pathstack algorithm for processing XML twig queries on multi-core systemsProceedings of the 15th international conference on Database Systems for Advanced Applications - Volume Part I10.1007/978-3-642-12026-8_22(277-291)Online publication date: 1-Apr-2010
https://dl.acm.org/doi/10.1007/978-3-642-12026-8_22
Machdi IAmagasa TKitagawa HKotsis GTaniar DPardede E(2009)Executing parallel TwigStack algorithm on a multi-core systemProceedings of the 11th International Conference on Information Integration and Web-based Applications & Services10.1145/1806338.1806376(176-184)Online publication date: 14-Dec-2009
https://dl.acm.org/doi/10.1145/1806338.1806376
Härder TMathis CBächle SSchmidt KWeiner A(2009)Essential Performance Drivers in Native XML DBMSsProceedings of the 36th Conference on Current Trends in Theory and Practice of Computer Science10.1007/978-3-642-11266-9_3(29-46)Online publication date: 8-Dec-2009
https://dl.acm.org/doi/10.1007/978-3-642-11266-9_3
Wang HLi JLiu XLuo J(2009)Query Optimization for Complex Path Queries on XML DataProceedings of the 14th International Conference on Database Systems for Advanced Applications10.1007/978-3-642-00887-0_35(389-404)Online publication date: 16-Mar-2009
https://dl.acm.org/doi/10.1007/978-3-642-00887-0_35
Mathis CWeiner AHärder THoppen C(2008)XTCcmpProceedings of the VLDB Endowment10.14778/1454159.14541831:2(1400-1403)Online publication date: 1-Aug-2008
https://dl.acm.org/doi/10.14778/1454159.1454183
Liu LFeng JLi GQian QLi J(2008)Parallel Structural Join Algorithm on Shared-Memory Multi-Core SystemsProceedings of the 2008 The Ninth International Conference on Web-Age Information Management10.1109/WAIM.2008.11(70-77)Online publication date: 20-Jul-2008
https://dl.acm.org/doi/10.1109/WAIM.2008.11
Li GFeng JZhang YZhou L(2007)Efficient holistic twig joins in leaf-to-root combining with root-to-leaf wayProceedings of the 12th international conference on Database systems for advanced applications10.5555/1783823.1783913(834-849)Online publication date: 9-Apr-2007
https://dl.acm.org/doi/10.5555/1783823.1783913
Son SShin HXu Z(2007)Structural Semi-Join: A light-weight structural join operator for efficient XML path query pattern matching11th International Database Engineering and Applications Symposium (IDEAS 2007)10.1109/IDEAS.2007.4318109(233-240)Online publication date: Sep-2007
https://doi.org/10.1109/IDEAS.2007.4318109
Show More Cited By

View Options

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.

Figures

Tables

Media

View Table of Conten