Efficient Processing of Multiple Structural Join Queries

  • G. V. Subramanyam
  • P. Sreenivasa Kumar
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 3112)


XML is widely used for representing and exchanging hierarchical data and queries naturally specify hierarchical patterns to select relevant parts of an XML document. These patterns have a sequence of selection predicates connected by operators representing parent-child or ancestor-descendant relationships. In this context, the operation of structural join involves discovering pairs of nodes that are in ancestor-descendant relationship from the cross product of two sets of nodes. In this paper, we propose a novel way of solving queries with multiple structural joins by maintaining an extra piece of information for each element called nDesc, which specifies the number of descendants having same tag name as that of the element. An extensive experimental evaluation of our algorithms with datasets of varying nDesc value shows that our algorithms perform better than the currently existing join algorithms.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Al-khalifa, S., Jagadish, H.V., Koudas, N., Patel, J.M., Srivastava, D., Wu, Y.: Structural joins: A primitive for efficient XML query processing. In: ICDE, pp. 141–152 (2002)Google Scholar
  2. 2.
    Bruno, N., Koudas, N., Srivatsava, D.: Holistic twig joins: Optimal XML pattern Matching. In: SIGMOD. pp. 310–321 (2002)Google Scholar
  3. 3.
    Berglund, A., Boag, S., Chamberlin, D., Fernandez, M.F., Kay, M., Robie, J., Siméon, J.: XML Path Language (XPath) 2.0 Technical Report, W3C Working Draft (2001), Available at http://www.w3.org/TR/XPath20/
  4. 4.
    Chein, S.-Y., Vagena, Z., Zhang, D., Tsotras, V.J., Zanilo, C.: Efficient structural joins on Indexed XML Documents. In: VLDB, pp. 263–274 (2002)Google Scholar
  5. 5.
    Chamberlin, D., Robie, J., Florescu, D.: Quilt: An XML Query Language for Heterogeneous Data Sources. In: WebDB 2000 (2000)Google Scholar
  6. 6.
    Chamberlin, D., Florescu, D., Robie, J., Siméon, J., Stefenscu, M.: XQuery: A Query Language for XML. W3C Working Draft (2001), Available at http://www.w3.org/TR/XQuery
  7. 7.
    Dietz, P.F.: Maintaining order in a linked List. In: ACM Symposium on Theory of Computing, pp. 122–127 (1982)Google Scholar
  8. 8.
    Florescu, D., Kossman, D.: Storing and Querying XML data using RDBMS. IEEE Data Engineering Bulletin 22(3), 27–34 (1999)Google Scholar
  9. 9.
    Grust, T.: Accelerating XPath Location Steps. In: SIGMOD, pp. 109–120 (2002)Google Scholar
  10. 10.
    Jiang, H., Lu, H., Wang, W., Ooi, B.C.: XR-Tree: Indexing XML Data for Efficient Structural Joins. In: ICDE, pp. 253–264 (2003)Google Scholar
  11. 11.
    Bremer, J.-M., Gertz, M.: An Efficient XML Node Identification and Indexing Scheme. Technical Report CSE-2003-04. Department of Computer Science, University of California at Davis (January 2003)Google Scholar
  12. 12.
    Li, Q., Moon, B.: Indexing and Querying XML data for Regular Path Expressions. In: VLDB, pp. 361–370 (2001)Google Scholar
  13. 13.
    Shanmugasundaram, J., Tufte, K., He, G., Zhang, C., Dewit, D.J., Naughton, J.F.: Relational Databases for Querying XML Documents: Limitations and Opportunities. In: VLDB, pp. 302–314 (1999)Google Scholar
  14. 14.
    Tatarinov, I., Viglas, S., Beyer, K., Shanmugasundaram, J., Shekita, E., Zhang, C.: Storing and querying ordered XML using a relational database systems. In: SIGMOD, pp. 204–215 (2002)Google Scholar
  15. 15.
    Zhang, C., Naughton, J., Dewit, D., Luo, Q., Lohman, G.: On supporting containment queries in Relational database management systems. In: SIGMOD, pp. 425–436 (2001)Google Scholar
  16. 16.

Copyright information

© Springer-Verlag Berlin Heidelberg 2004

Authors and Affiliations

  • G. V. Subramanyam
    • 1
  • P. Sreenivasa Kumar
    • 1
  1. 1.Dept of Computer Science and EngineeringIndian Institute of TechnologyMadras, ChennaiIndia

Personalised recommendations