XQuery rewriting at the relational algebra level

Computer Systems Science and Engineering

Volumn 18, Issue 5, 2003, Pages 241-262

  Zhang, Hui ^a   Tompa, Frank ^a  

^a UNIVERSITY OF WATERLOO   (Canada)

Author keywords

Relational algebra level; XML; XQuery

Indexed keywords

ALGORITHMS; CORRELATION METHODS; DATABASE SYSTEMS; GRAPH THEORY; OPTIMIZATION; QUERY LANGUAGES;

QUERY PROCESSORS; RELATIONAL ALGEBRA LEVEL; XQUERY;

XML;

EID: 3042761211     PISSN: 02676192     EISSN: None     Source Type: Journal    
DOI: None     Document Type: Article

References (60)

1. IBM DB2XML Extender. http://www-4.ibm.com/software/data/db2/extenders
2. Extensible Markup Language (XML) 1.0. http://www.w3.org/XML/, Feb. 10 1998.
3. XML Path Language (XPath) 2.0. http://www.w3.org/TR/xpath20. April 30 2002.
4. XQuery 1.0 and XPath 2.0 Functions and Operators. http://www.w3.org/TR/ xquery-operators. Nov. 15 2002.
5. XML Query Use Cases. http://www.w3.org/TR/xmlquery-use-cases, May 2 2003.
6. XQuery 1.0: An XML Query Language. http://www.w3.org/TR/xquery, May 2 2003.
7. XQuery 1.0 and XPath 2.0 Formal Semantics. http://www.w3.org/TR/query- semantics, May 2 2003.
8. S. Al-Khalifa, H. V. Jagadish, N. Koudas, J. Patel, D. Srivastava, and Y. Wu. Structural joins: A primitive for efficient XML query pattern matching. Proc. of the 18th Int. Conf. on Data Engineering, pp. 141-152. San Jose, Feb. 2002.
9. S. Amer-Yahia, S. Cho, L. V. S. Lakshmanan, and D. Srivasta-va. Minimization of tree pattern queries. Proc. of the ACM SIGMOD Int. Conf. on Management of Data, pp. 497-508, Santa Barbara, CA. May 2001.
10. J. A. Blakeley, W. J. Mckenna, and G. Graefe. Experiences building the open OODB query optimizer. Proc. of the ACM SIGMOD Int. Conf. on Management of Data, pp. 287-296. Washington. DC, May 1993.
11. K. Boehm, K. Gayer, T. Özsu, and K. Aberer. Query optimization for structured documents based on knowledge on the document type definition. Proc. of the Advances in Digital Libraries Conf., pp. 196-205, 1998.
12. P. Bohannon, J. Freire, P. Roy, and J. Simeon. From XML schema to relations: A cost-based approach to XML storage. Proc. of the 19th Int. Conf. on Data Engineering, pp. 64-75. San Jose, Feb. 2002.
13. L. J. Brown, M. P. Consens, I. J. Davis, C. R. Palmer, and F. W. Tompa. A structured text ADT for object-relational databases. Theory and Practice of Object Systems (TAPOS), 4(4): 227-244, 1998.
14. N. Bruno, N. Koudas, and D. Srivastava, Holistic twig joins: Optimal XML pattern matching. Proc. of the ACM SIGMOD Int. Conf. on Management of Data, pp. 310-321, Madison, WI, June 2002.
15. P. Buneman, S. Davidson, G. Hillebrand, and D. Suciu. A query language and optimization techniques for unstructured data. Proc. of the ACM SIGMOD Int. Conf. on Management of Data, pp. 505-516, Montréal, Canada, June 1996.
16. S. Chaudhuri. An overview of query optimization in relational systems. Proc. of the 17th ACM SIGACT-SIGMOD-SIGART Symp. on Principles of Database Systems, pp. 34-43, Seattle, WA, June 1998.
17. S. Chaudhuri and K. Shim. Including group-by in query optimization. Proc. of the 20th Int. Conf. on Very Large Data Bases, pp. 354-366. Santiago, Chile, Sept. 1994.
18. S. Chaudhuri and K. Shim. Optimization of queries with userdefined predicates. Proc. of the 22nd Int. Conf. on Very Large Data Bases, pp. 87-98. Bombay, India, 1996.
19. V. Christophides, S. Cluet, and G. Moerkotte. Evaluating queries with generalized path expressions. Proc. of the ACM SIGMOD Int. Conf. on Management of Data. pp. 413-422. Montréal, Canada, June 1996.
20. V. Christophides, S. Cluet, and J. Simeon. On wrapping query languages and efficient XML integration. Proc. of the ACM SIGMOD Int. Conf. on Management of Data, pp. 141-152. Dallas, Texas, May 2000.
21. C. L. A. Clarke, G. V. Cormack, and F. J. Burkowski. An algebra for structured text search and a framework for its implementation. The Computer Journal, 38(l):43-56, 1995.
22. U. Dayal. Of nests and trees: A unified approach to processing queries that contain nested subqueries, aggregates, and quantifiers. Proc. of the 13th Int. Conf. on Very Large Data Bases, pp. 197-208. Brighton, England, Sept. 1987.
23. D. DeHaan, D. Toman, M. P. Consens, and T. Özsu. A comprehensive XQuery to SQL translation using dynamic interval encoding. Proc. of the ACM SIGMOD Int. Conf. on Management of Data, pp. 623-634, San Diego, CA, June 2003.
24. A. Deutsch, M. F. Fernandez, and D. Suciu. Storing semistructured data with STORED. Proc. of the ACM SIGMOD Int. Conf. on Management of Data, pp. 431-442. Philadelphia, June 1999.
25. M. Fernandez and D. Suciu. Optimizing regular path expressions using graph schemas. Proc. of the 14th Int. Conf. on Data Engineering, pp. 14-23, Orlando, Florida, Feb. 1998.
26. T. Fiebig and G. Moerkotte. Algebraic XML construction and its optimization in Natix. World Wide Web Journal. 4(3): 167-187, 2001.
27. D. Florescu and D. Kossmann. Storing and querying XML data using an RDMBS. IEEE Data Engineering Bulletin, 22(3):27-34, Sept. 1999.
28. R. A. Ganski and H. K. T. Wong. Optimization of nested queries revisited. Proc. of ACM SIGMOD Int. Conf. on Management of Data, pp. 23-33, San Francisco, CA, May 1987.
29. G. Gardarin, J. Gruser, and Z. Tan. Cost-based selection of path expression processing algorithms in object-oriented databases. Proc. of the 22nd Int. Conf. on Very Large Data Bases, pp. 390-401, Bombay, India, Sept. 1996.
30. R. Goldman and J. Widom. DataGuides: Enabling query formulation and optimization in semistructured databases. Proc. of the 23rd Int. Conf. on Very Large Data Bases, pp. 436-445, Athens, Greece, Aug. 1997.
31. G. H. Gonnet and F. W. Tompa. Mind your grammar: A new approach to modeling text. Proc. of the 13th Int. Conf. on Very Large Data Bases, pp. 339-346, Brighton, England, Sept. 1987.
32. J. M. Hellerstein. Practical predicate placement. Proc. of the ACM SIGMOD Int. Conf. on Management of Data, pp. 325-334, Minneapolis, MN, May 1994.
33. J. M. Hellerstein and J. F. Naughton. Query execution techniques for caching expensive methods. Proc. of the ACM SIGMOD Int. Conf. on Management of Data, pp. 423-434, Montréal, Canada, June 1996.
34. J. M. Hellerstein and M. Stonebraker. Predicate migration: Optimizing queries with expensive predicates. Proc. of the ACM SIGMOD Int. Conf. on Management of Data, pp. 267-276. Washington, DC, May 1993.
35. H. V. Jagadish, S. Al-Khalifa, A. Chapman, L. V. S. Lakshmanan, A. Nierman, S. Paparizos, J. Patel, D. Srivastava, N. Wiwatwattana, Y. Wu, and C. Yu, TIMBER: A native XML database. VLDB Journal, 11 (4):274-291, 2002.
36. C. C. Kanne and G. Moerkotte. Efficient relational storage and retrieval of XML documents. Technical report, University of Mannheim, Germany, 1999.
37. C. C. Kanne and G. Moerkotte. Efficient storage of XML data. Proc. of the 17th Int. Conf. on Data Engineering, page 198, San Diego, CA, March 2000.
38. W. Kim. On optimizing an SQL-like nested query. ACM Transactions on Database Systems, 7(3):443-469, Sept. 1982.
39. I. Manolescu, D. Flurescu, and D. Kossmann. Answering XML queries on heterogeneous data sources. Proc. of the 27th Int. Conf. on Very Large Data Bases, pp. 241-250, Rome, Sept. 2001.
40. J. McHugh and J. Widom. Compile-time path expansion in Lore. Workshop on Query Processing for Semistructured Data and NonStandard Data Formats, Jerusalem, Israel, Jan. 1999.
41. J. McHugh and J. Widom. Optimizing branching path expressions. Technical report, Stanford University, June 1999.
42. J. McHugh and J. Widom. Query optimization for XML. Proc. of the 25th Int. Conf. on Very Large Data Bases, pp. 315-326, Edinburgh, Scotland, Sept. 1999.
43. I. S. Mumick, S. J. Finkelstein, H. Pirahesh, and R. Ramakrishnan. Magic is relevant. Proc. of the ACM SIGMOD Int. Conf. on Management of Data, pp. 247-258, Atlantic City. NJ, May 1990.
44. I. S. Mumick and H. Pirahesh. Implementation of magic-sets in a relational database system. Proc. of the ACM SIGMOD Int. Conf. on Management of Data, pp. 103-114, Minneapolis. MN, May 1994.
45. I. S. Mumick, H. Pirahesh, and R. Ramakrishnan. The magic of duplicates and aggregates. Proc. of the 16th Int. Conf. on Very Large Data Bases, pp. 264-277, Brisbane, Australia, Aug. 1990.
46. M. Muralikrishna. Improved unnesting algorithms for join aggregate SQL queries. Proc. of the 18th Int. Conf. on Very Large Data Bases, pp. 91-102, Vancouver, Canada, Aug. 1992.
47. D. Olteanu, H. Meuss, T. Furche, and F. Bry. XPath: Looking forward. Proc. of the EDBT Workshop on XML Data Management (XMLDM), pp. 109-127. Prague, Czech Rep., March 2002.
48. M. T. Özsu and J. A. Blakeley. Query optimization and processing in object-oriented database systems. Modem Database Management - Object-Oriented and Multidatabase Technologies, W. Kim (ed.), pp. 146-174, Addison-Wesley/ACM Press, 1994.
49. G. N. Paulley. Exploiting functional dependence in query optimization. PhD thesis. Dept. of Computer Science. University of Waterloo, Ontario, Canada, April 2000.
50. H. Pirahesh, J. M. Hellerstein, and W. Hasan. Extensible/rule based query rewrite optimization in Starburst. Proc. of the ACM SIGMOD Int. Conf. on Management of Data, pp. 39-48, San Diego, June 1992.
51. H. Schoning. Tamino - A DBMS designed for XML. Proc. of the 17th Int. Conf. on Data Engineering, pp. 149-154, Heidelberg, Germany, April 2001.
52. P. G. Selinger, M. M. Astrahan, D. D. Chamberlin, R. A. Lorie, and T. G. Price. Access path selection in a relational database management systems. Proc. of the ACM SIGMOD Int. Conf. on Management of Data, pp. 23-34, Boston, May 1979.
53. J. Shanmugasundaram, K. Tufte, G. He, C. Zhang, D. DeWitt, and J. Naughton. Relational databases for querying XML documents: Limitations and opportunities. Proc. of the 25th Int. Conf. on Very Large Data Bases, pp. 302-314, Edinburgh, Scotland, 1999.
54. H. J. Steenhagen, P. M. G. Apers, H. M. Blanken, and R. A. de By. From nested-loop to join queries in OODB. Proc, of the 20th Int. Conf. on Very Large Data Bases, pp. 618-629, Santiago, Chile, Sept. 1994.
55. P. T. Wood. Optimizing web queries using document type definitions. Proc. of the 2nd ACM Workshop on Web Information and Data Management (WIDM), pp. 28-32, 1999.
56. W. P. Van and P. A. Larson. Performing group-by before join. Proc. of the 10th Int. Conf. on Data Engineering, pp. 89-100, Houston, Texas, Feb. 1994.
57. W. P. Van and P. A. Larson. Eager aggregation and lazy aggregation. Proc. of the 21st Int. Conf. on Very Large Data Bases, pp. 345-357, Zurich, Switzerland, Sept. 1995.
58. C. Zhang, J. Naughton, D. DeWitt, Q. Luo, and G. Lohman. On supporting containment queries in relational database management systems. Proc. of the ACM SIGMOD Int. Conf. on Management of Data, pp. 425-436, Santa Barbara, CA, May 2001.
59. H. Zhang. XML query processing and optimization. PhD thesis, School of Computer Science. Univerisy of Waterloo, Ontario, Canada, 2003.
60. H. Zhang and F. W. Tompa. An XQuery canonical form and its translation to an extended relational algebra. Technical Report CS2002-40, School of Computer Science. University of Waterloo, Ontario, Canada, Oct. 2002.