Applying Cosine Series to XML Structural Join Size Estimation

  • Cheng Luo
  • Zhewei Jiang
  • Wen-Chi Hou
  • Qiang Zhu
  • Chih-Fang Wang
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4080)


As XML has become the de facto standard for data presentation and exchanging on the Web, XML query optimization has emerged as an important research issue. It is widely accepted that structural joins, which evaluate the containment (ancestor-descendant) relationships between XML elements, are important to the XML query processing. Estimating structural join size accurately and quickly thus becomes crucial to the success of XML query plan selection. In this paper, we propose to apply Cosine transform to structural join size estimation. Our approach captures structural information of XML data using mathematical functions, which are then approximated by the Cosine series. We derive a simple formula to estimate the structural join size using the Cosine series. Theoretical analyses and extensive experiments have been performed. The experimental results show that, compared with state-of-the-art IM-DA-Est method, our method is several order faster, requires less memory, and yields better or comparable estimates.


Disk Access Ancestor Node Path Expression Descendant Node Cosine Series 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Aboulnaga, A., Alameldeen, A.R., Naughton, J.F.: Estimating the selectivity of XML path expressions for internet scale applications. In: Proceedings of 27th International Conference on Very Large Data Bases, pp. 591–600 (2001)Google Scholar
  2. 2.
    Al-Khalifa, S., Jagadish, H.V., Koudas, N., Patel, J.M., Srivastava, D., Wu, Y.: Structural joins: A primitive for efficient XML query pattern matching. In: ICDE, pp. 141–152 (2002)Google Scholar
  3. 3.
    Chamberlin, D., Florescu, D., Robie, J., Simeon, J., Stefanescu, M.: XQuery 1.0: An XML Query Language. W3C Working Draft (2004),
  4. 4.
    Chen, Z., Jagadish, H.V., Korn, F., Koudas, N., Muthukrishnan, S., Ng, R.T., Srivastava, D.: Couting twig matches in a tree. In: Proceedings of the 17th International Conference on Data Engineering, pp. 595–604 (2001)Google Scholar
  5. 5.
    Clark, J., DeRose, S.: XML Path Language (XPath). W3C Working Draft (1999),
  6. 6.
  7. 7.
    Freire, J., Haritsa, J.R., Ramanath, M., Roy, P., Siméon, J.: Statix: making XML count. In: Proceedings of the 2002 ACM SIGMOD International Conference on Management of Data, pp. 181–191 (2002)Google Scholar
  8. 8.
    Issacson, E., Keller, H.B.: Analysis of Numerical Methods Theorem 3, p. 238. Dover Publications, Mineola (1994)Google Scholar
  9. 9.
    Li, Q., Moon, B.: Indexing and querying XML data for regular path expressions. In: VLDB 2001, pp. 361–370 (2001)Google Scholar
  10. 10.
    Luo, C., Jiang, Z., Hou, W-C., Zhu, Q., Wang, C-F.: Applying the Cosine Series to XML Structural Join Size Estimation at,
  11. 11.
    McHugh, J., Widom, J.: Optimizing branching path expressions. In: VLDB, pp. 315–326 (1999)Google Scholar
  12. 12.
    Paparizos, S., Al-Khalifa, S., Chapman, A., Jagadish, H.V., Lakshmanan, L.V.S., Nierman, A., Patel, J.M., Srivastava, D., Wiwatwattana, N., Wu, Y., Yu, C.: TIMBER: A Native System for Querying XML. VLDB J. 11(4), 274–291 (2002)MATHCrossRefGoogle Scholar
  13. 13.
    Polyzotis, N., Garofalakis, M.N.: Statistical synopses for graph-structured XML databases. In: Proceedings of the 2002 ACM SIGMOD International Conference on Management of Data, pp. 358–369 (2002)Google Scholar
  14. 14.
    Schmidt, A., Waas, F., Kersten, M., Florescu, D., Manolescu, L., Carey, M.J., Busse, R.: The XML benchmark project. Technical report CWI (2001)Google Scholar
  15. 15.
    Wang, W., Jiang, H., Lu, H., Yu, J.X.: Containment join size estimation: models and methods. In: Proceedings of the 2003 ACM SIGMOD International Conference on Management of Data, pp. 145–156 (2003)Google Scholar
  16. 16.
    Wu, Y., Patel, J.M., Jagadish, H.V.: Estimating answer sizes for XML queries. In: Jensen, C.S., Jeffery, K., Pokorný, J., Šaltenis, S., Bertino, E., Böhm, K., Jarke, M. (eds.) EDBT 2002. LNCS, vol. 2287, pp. 590–608. Springer, Heidelberg (2002)CrossRefGoogle Scholar
  17. 17.
    Zhang, C., Naughton, J.F., DeWitt, D.J., Luo, Q., Lohman, G.M.: On supporting containment queries in relational database management systems. In: SIGMOD (2001)Google Scholar
  18. 18.
    Jiang, H., Lu, H., Wang, W., Ooi, B.: XR-Tree: Indexing XML Data for Efficient Structural Join. In: Proc. of ICDE, India, pp. 253–264 (2003)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Cheng Luo
    • 1
  • Zhewei Jiang
    • 1
  • Wen-Chi Hou
    • 1
  • Qiang Zhu
    • 2
  • Chih-Fang Wang
    • 1
  1. 1.Computer Science Department in Southern Illinois University CarbondaleCarbondaleU.S.A.
  2. 2.Computer and Information Science Department in University of MichiganDearbornU.S.A.

Personalised recommendations