Skip to main content

Relational Index Support for XPath Axes

  • Conference paper
Database and XML Technologies (XSym 2005)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 3671))

Included in the following conference series:

Abstract

In this paper, we designed efficient indexing structure for XML documents so that each basic XPath axis step is supported. The indexing structure is built on top of the B + -tree which is available in practically all commercial relational database systems. For most of the basic axis steps, we are able to derive theoretical worst case execution time bounds. We also perform experimental evaluation to substantiate those bounds.

This research was fully supported by a grant from the Research Grants Council of the Hong Kong SAR, China [Project No. 9040906 (RGC Ref. No. CityU 1164/04E)].

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Al-Khalifa, S., Jagadish, H., Koudas, N., Patel, J.M., Srivastava, D., Wu, Y.: Structural joins: a primitive for efficient XML query pattern matching. In: 18th International Conference on Data Engineering, pp. 141–152 (2002)

    Google Scholar 

  2. Berglund, A., Boag, S., Chamberlin, D., Fernandez, M., Kay, M., Robie, J., Simeon, J.: XML Path Language (XPath) 2.0. Technical Report W3C Working Draft, Version 2.0, World Wide Web Consortium (August 2002)

    Google Scholar 

  3. Bruno, N., Koudas, N., Srivastava, D.: Holistic twig joins: optimal XML pattern matching. In: Proceedings of the 2002 ACM SIGMOD Conference on the Management of Data, pp. 310–321 (2002)

    Google Scholar 

  4. Chen, Y., Davidson, S.B., Zheng, Y.: BLAS: an efficient xpath processing system. In: Proceedings of the 2004 ACM SIGMOD Conference on the Management of Data, pp. 47–58 (2004)

    Google Scholar 

  5. Chien, S.-Y., Vagena, Z., Zhang, D., Tsotras, V.J., Zaniolo, C.: Efficient structural joins on indexed XML documents. In: Proceedings of the 29th International Conference on Very Large Data Bases, pp. 263–274 (2002)

    Google Scholar 

  6. W. W. W. Consortium. Extensible markup language (XML) 1.0 (second edition) – W3C recommendation (2000), Available at http://www.w3.org/TR/2000/WD-xml-2e-20000814

  7. Cooper, B.F., Sample, N., Franklin, M.J., Hjaltason, G.R., Shadmon, M.: A fast index for semistructured data. In: Proceedings of the 27th International Conference on Very Large Data Bases, pp. 341–350 (2001)

    Google Scholar 

  8. deHaan, D., Toman, D., Consens, M.P., Ozsu, M.T.: A comprehensive XQuery to SQL translation using dynamic interval encoding. In: Proceedings of the 2003 ACM SIGMOD Conference on the Management of Data, pp. 623–634 (2003)

    Google Scholar 

  9. Goldman, R., Widom, J.: DataGuides: enabling query formulation and optimization in semistructured databases. In: Proceedings of the 23th International Conference on Very Large Data Bases, pp. 436–445 (1997)

    Google Scholar 

  10. Gottlob, G., Koch, C., Pichler, R.: Efficient algorithms for processing XPath queries. In: Proceedings of the 29th International Conference on Very Large Data Bases, pp. 95–106 (2002)

    Google Scholar 

  11. Gottlob, G., Koch, C., Pichler, R.: The complexity of XPath query evaluation. In: Proceedings of the 22nd Annual ACM Symposium on Principles of Database Systems, pp. 179–190 (2003)

    Google Scholar 

  12. Gottlob, G., Koch, C., Pichler, R.: XPath query evaluation: improving time and space efficiency. In: 19th International Conference on Data Engineering, pp. 379–390 (2003)

    Google Scholar 

  13. Grust, T., van Keulen, M., Teubner, J.: Accelerating XPath evaluation in any RDBMS. ACM Transactions on Database Systems 29(1), 91–131 (2004)

    Article  Google Scholar 

  14. Jiang, H., Lu, H., Wang, W., Ooi, B.C.: XR-Tree: indexing XML data for efficient structural joins. In: 19th International Conference on Data Engineering, pp. 253–263 (2003)

    Google Scholar 

  15. Kaushik, R., Bohannon, P., Naughton, J., Korth, H.: Covering indexes for branching path queries. In: Proceedings of the 2002ACM SIGMOD Conference on the Management of Data, pp. 133–144 (2002)

    Google Scholar 

  16. Kaushik, R., Shenoy, P., Bohannon, P., Gudes, E.: Exploiting local similarity for efficient indexing of paths in graph structured data. In: 18th International Conference on Data Engineering, pp. 129–140 (2002)

    Google Scholar 

  17. Kha, D.D., Yoshikawa, M., Uemura, S.: A structural numbering scheme for XML data. In: EDBT Workshops, pp. 91–108 (2002)

    Google Scholar 

  18. Kriegel, H.-P., Potke, M., Seidl, T.: Managing intervals efficiently in objectrelational databases. In: Proceedings of the 26th International Conference on Very Large Data Bases, pp. 407–418 (2000)

    Google Scholar 

  19. Lee, Y.K., Yoo, S., Yoon, K., Berra, P.B.: Index structures for structured documents. In: Digital Libraries, pp. 91–99 (1996)

    Google Scholar 

  20. Li, Q., Moon, B.: Indexing and querying XML data for regular path expressions. In: Proceedings of the 27th International Conference on Very Large Data Bases, pp. 361–370 (2001)

    Google Scholar 

  21. Milo, T., Suciu, D.: Index structures for path expressions. In: 7th International Conference on Database Theory, pp. 277–295 (1999)

    Google Scholar 

  22. Rao, P., Moon, B.: PRIX: indexing and query XML using Prüfer sequences. In: 20th International Conference on Data Engineering, pp. 288–300 (2004)

    Google Scholar 

  23. Schmidt, A., Kersten, M., Windhouwer, M., Waas, F.: Efficient relational storage and retrieval of XML documents. In: Proceedings of the 3rd International Workshop on the Web and Databases, pp. 137–150 (2000)

    Google Scholar 

  24. Schmidt, A., Waas, F., Kersten, M., Carey, M., Manolescu, I., Busse, R.: XMark: a benchmark for XML data management. In: Proceedings of the 29th International Conference on Very Large Data Bases, pp. 974–985 (2002)

    Google Scholar 

  25. Tatarinov, I., Viglas, S.D., Beyer, K., Shanmugasundaram, J., Shekita, E., Zhang, C.: Storing and querying ordered XML using a relational database system. In: Proceedings of the 2002 ACM SIGMOD Conference on the Management of Data, pp. 204–215 (2002)

    Google Scholar 

  26. Wang, H., Park, S., Fan, W., Yu, P.S.: ViST: A dynamic index method for queryinh XML data by tree structures. In: Proceedings of the 2003 ACM SIGMOD Conference on the Management of Data, pp. 110–121 (2003)

    Google Scholar 

  27. Wang, W., Jiang, H., Lu, H., Yu, J.X.: PBiTree coding and efficient processing of containment joins. In: 19th International Conference on Data Engineering, p. 391 (2003)

    Google Scholar 

  28. Yoshikawa, M., Amagasa, T., Shimura, T., Uemura, S.: XRel: a path-based approach to storage and retrieval of XML documents using relational databases. ACM Transactions on Internet Technology 1(1), 110–141 (2001)

    Article  Google Scholar 

  29. Zhang, C., Naughton, J., DeWitt, D., Luo, Q., Lohman, G.: On supporting containment queries in relational database management systems. In: Proceedings of the 2001 ACM SIGMOD Conference on the Management of Data, pp. 425–436 (2001)

    Google Scholar 

  30. Zhang, N., Kacholia, V., Ozsu, M.T.: A succinct physical storage scheme for efficient evaluation of path queries in XML. In: 20th International Conference on Data Engineering, pp. 56–65 (2004)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2005 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Yuen, L., Poon, C.K. (2005). Relational Index Support for XPath Axes. In: Bressan, S., et al. Database and XML Technologies. XSym 2005. Lecture Notes in Computer Science, vol 3671. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11547273_7

Download citation

  • DOI: https://doi.org/10.1007/11547273_7

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-28583-0

  • Online ISBN: 978-3-540-31968-9

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics