Strategies for query unnesting in XML databases

ACM Transactions on Database Systems

Volumn 31, Issue 3, 2006, Pages 968-1013

  May, Norman ^a,c   Helmer, Sven ^b,d   Moerkotte, Guido ^a,c  

^a UNIVERSITY OF MANNHEIM   (Germany)

^b UNIVERSITY OF LONDON   (United Kingdom)

^c Department of Practical Computer Science III B6 29 ^*  (Germany)

^d UNIVERSITY OF LONDON   (United Kingdom)

Author keywords

Nested queries; Query decorrelation; Query optimization; XML; XQuery

Indexed keywords

NESTED QUERIES; QUERY DECORRELATION; QUERY OPTIMIZATION; XQUERY;

ALGEBRA; OPTIMIZATION; PROGRAM TRANSLATORS; QUERY LANGUAGES; STRATEGIC PLANNING; XML;

DATABASE SYSTEMS;

EID: 33750200740     PISSN: 03625915     EISSN: 03625915     Source Type: Journal    
DOI: 10.1145/1166074.1166081     Document Type: Conference Paper

References (54)

1. ASTRAKAN, M. M. AND CHAMBERLIN, D. D. 1975. Implementation of a structured English query language. Commun. ACM 18, 10, 580-588.
2. BEERI, C. AND TZABAN, Y. 1999. SAL: An algebra for semistructured data and XML. In Informal Proceedings of the International Workshop on the Web and Databases (WebDB '99), Philadelphia, PA. 37-42.
3. BEYER, K., CHAMBERLIN, D., COLBY, L., ÖZCAN, P., PIRAHESH, H., AND XU, Y. 2005. Extending XQuery for analytics. In SIGMOD '05: Proceedings of the 2005 ACM SIGMOD International Conference on Management of Data. ACM Press, New York, NY, 503-514.
4. BEYER, K. S., COCHRANE, R., COLBY, L. S., OZCAN, F., AND PIRAHESH, H. 2004. XQuery for analytics: Challenges and requirements. In Informal Proceedings of the 〈XIME-P/〉. Paris, France, 3-8.
5. BHARGAVA, G., GOEL, P., AND IYER, B. 1995. Hypergraph based reorderings of outer join queries with complex predicates. In SIGMOD '95: Proceedings of the 1995 ACM SIGMOD International Conference on Management of Data. ACM Press, New York, NY, 304-315.
6. BORKAR, V. AND CAREY, M. 2004. Extending XQuery for grouping, duplicate elimination, and outer joins. In Proceedings of XML 2004.
7. BRANTNER, M., KANNE, C.-C., HELMER, S., AND MOERKOTTE, G. 2005. Full-fledged algebraic XPath processing in Natix. In Proceedings of the 21st International Conference on Data Engineering (ICDE '05, Tokyo, Japan). IEEE Computer Society Press, Los Alamitos, CA, 705-716.
8. BRY, F. 1989. Towards an efficient evaluation of general queries: quantifier and disjunction processing revisited. In SIGMOD '89: Proceedings of the 1989 ACM SIGMOD International Conference on Management of Data. ACM Press, New York, NY, 193-204.
9. CHATZIANTONIOU, D., AKINDE, M., JOHNSON, T., AND KIM, S. 2001. The MD-Join: An Operator for Complex OLAP. In ICDE '01: Proceedings of the 17th International Conference on Data Engineering. IEEE Computer Society Press, Los Alamitos, CA, 524-533.
10. CLAUSSEN, J., KEMPER, A., AND KOSSMANN, D. 1998. Order-preserving hash joins: Sorting (almost) for free. Technical rep. MIP-9810. University of Passau, Passau, Germany.
11. CLAUSSEN, J., KEMPER, A., MOERKOTTE, G., AND PEITHNER, K. 1997. Optimizing queries with universal quantification in object-oriented and object-relational databases. In Proceedings of the International Conference on Very Large Data Bases (VLDB). Morgan Kaufmann, San Francisco, CA, 286-295.
12. CLUET, S. AND DELOBEL, C. 1992. A general framework for the optimization of object-oriented queries. In SIGMOD '92: Proceedings of the 1992 ACM SIGMOD International Conference on Management of Data. ACM Press, New York, NY, 39-48.
13. CLUET, S. AND MOERKOTTE, G. 1994. Nested queries in object bases. In DBLP-4: Proceedings of the Fourth International Workshop on Database Programming Languages - Object Models and Languages. Springer-Verlag, London, U.K, 226-242.
14. CLUET, S. AND MOERKOTTE, G. 1995. Classification and optimization of nested queries in object bases. Technical rep. 95-6. RWTH Aachen, Aachen, Germany.
15. CLUET, S. AND MOERKOTTE, G. 1996. Efficient evaluation of aggregates on bulk types. In DBLP-5: Proceedings of the Fifth International Workshop on Database Programming Languages. Springer-Verlag, London, U.K., 8.
16. DAYAL, U. 1987. Of nests and trees: A unified approach to processing queries that contain nested subqueries, aggregates, and quantifiers. In Proceedings of the International Conference on Very Large Data Bases (VLDB). Morgan Kaufmann, San Francisco, CA, 197-208.
17. DEUTSCH, A., PAPAKONSTANTMOU, Y., AND XU, Y. 2004. The NEXT logical framework for XQuery. In Proceedings of the International Conference on Very Large Data Bases (VLDB). Morgan Kaufmann, San Francisco, CA 94022, 168-179.
18. DRAPER, D., FHANKHAUSER, P., FEHNANDEZ, M., MALHOTRA, A., ROSE, K., RYS, M., SIMEON, J., AND WADLER, P. 2005. XQuery 1.0 and XPath 2.0 formal semantics. W3C Candidate Recommendation. Nov. Go online to www.w3c.org.
19. FEGARAS, L. 1998. Query unnesting in object-oriented databases. In SIGMOD '98: Proceedings of the 1998 ACM SIGMOD International Conference on Management of Data. ACM Press, New York, NY, 49-60.
20. FEGARAS, L., LEVINE, D., BOSE, S., AND CHALUVADI, V. 2002. Query processing of streamed XML data. In CIKM '02: Proceedings of the Eleventh International Conference on Information and Knowledge Management. ACM Press, New York, NY, 126-133.
21. FEGARAS, L. AND MAIER, D. 2000. Optimizing object queries using an effective calculus. ACM Trans. Database Syst. 25, 4, 457-516.
22. FIEBIG, T. AND MOERKOTTE, G. 2001. Algebraic XML construction and its optimization in Natix. WWW J. 4, 3, 167-187.
23. FUSHIMI, S., KITSUREGAWA, M., AND TANAKA, H. 1986. An overview of the systems software of a parallel relational database machine: GRACE. In Proceedings of the International Conference on Very Large Data Bases (VLDB). Morgan Kaufmann, San Francisco, CA, 209-219.
24. GALINDO-LEGARIA, C. AND JOSHI, M. 2001. Orthogonal optimization of subqueries and aggregation. In SIGMOD'01: Proceedings of the 2001 ACM SIGMOD International Conference on Management of Data. ACM Press, New York, NY, 571-581.
25. GALINDO-LEGARIA, C. AND ROSENTHAL, A. 1997. Outerjoin simplification and reordering for query optimization. ACM Trans. Database Syst. 22, 1 (Mar.), 43-73.
26. GANSKI, R. A. AND WONG, H. K. T. 1987. Optimization of nested SQL queries revisited. In SIGMOD '87: Proceedings of the 1987 ACM SIGMOD International Conference on Management of Data. ACM Press, New York, NY, 23-33.
27. GOTTLOB, G., KOCH, C., AND PICHLER, R. 2002. Efficient algorithms for processing XPath queries. In Proceedings of the International Conference on Very Large Data Bases (VLDB). VLDB Endowment, Hong Kong, China, 95-106.
28. GOTTLOB, G., KOCH, C., AND PICHLER, R. 2003. XPath query evaluation: Improving time and space efficiency. In Proceedings of the IEEE Conference on Data. Engineering. IEEE Computer Society Press, Los Alamitos, CA, 379-390.
29. GRAEFE, G. 1993. Query evaluation techniques for large databases. ACM Comput. Surv. 25, 2 (Jun.), 73-170.
30. GRAEFE, G. 2003. Executing nested queries. In Proceedings of BTW 2003. GI, Leipzig, Germany, 58-77.
31. GRUST, T., SAKR, S., AND TEUBNER, J. 2004. XQuery on SQL hosts. In Proceedings of the International Conference on Very Large Data Bases (VLDB). 252-263.
32. GURAVANNAVAR, R., RAMANUJAM, H. S., AND SUDARSHAN, S. 2005. Optimizing nested queries with parameter sort orders. In Proceedings of the International Conference on Very Large Data Bases (VLDB). VLDB Endowment, Trondheim, Norway, 481-492.
33. JARKE, M. AND KOCH, J. 1984. Query optimization in database systems. ACM Comput. Surv. 16, 2 (Jun.), 111-152.
34. KIESSLING, W. 1984. SQL-like and Quel-like correlation queries with aggregates revisited. ERL/UCB Memo 84/75, University of California, Berkeley, Berkeley, CA.
35. KIM, W. 1982. On optimizing an SQL-like nested query. ACM Trans. Database Syst. 7, 3 (Sept.), 443-469.
36. KLUG, A. 1982. Equivalence of relational algebra and relational calculus query languages having aggregate functions. J. ACM 29, 3, 699-717.
37. LIU, Z. H., KRISHNAPRASAD, M., AND ARORA, V. 2005. Native XQuery processing in Oracle XMLDB. In Proceedings of the ACM SIGMOD Conference on Management of Data. ACM Press, New York, NY, 828-833.
38. MAY, N., HELMER, S., KANNE, C.-C., AND MOERKOTTE, G. 2004a. XQuery processing in Natix with an emphasis on join ordering. In Informal Proceedings of the First International Workshop on XQuery Implementation, Experience and Perspectives (XIME-P '04, Paris, France). 49-54.
39. MAY, N., HELMER, S., AND MOERKOTTE, G. 2003. Nested queries and quantifiers in an ordered context. Tech. rep. TR-03-002. Department for Mathematics and Computer Science, University of Mannheim, Mannheim, Germany.
40. MAY, N., HELMER, S., AND MOERKOTTE, G. 2004b. Nested queries and quantifiers in an ordered context. In ICDE '04: Proceedings of the 20th International Conference on Data Engineering. IEEE Computer Society Press, Los Alamitos, CA, 239.
41. MAY, N. AND MOERKOTTE, G. 2005. Main memory implementations for binary grouping. In Proceedings of the 3rd International XML Database Symposium (XSym 2005), Trondheim, Norway. Springer-Verlag, London, U.K., 162-176.
42. MUMICK, I. S., FINKELSTEIN, S. J., PIRAHESH, H., AND RAMAKRISHNAN, R. 1990. Magic is relevant. In Proceedings of the 1990 ACM SIGMOD International Conference on Management of Data, ACM Press, New York, NY, 247-258.
43. MURALIKRISHNA, M. 1989. Optimization and dataflow algorithms for nested tree queries. In Proceedings of the International Conference on Very Large Data Bases (VLDB). Morgan Kaufmann, San Francisco, CA, 77-85.
44. MUHALIKRISHNA, M. 1992. Improved unnesting algorithms for join aggregate SQL queries. In Proceedings of the International Conference on Very Large Data Bases (VLDB). Morgan Kaufmann, San Francisco, CA, 91-102.
45. NAKANO, R. 1990. Translation with optimization from relational calculus to relational algebra having aggregate functions. ACM Trans. Database Syst. 15, 4, 571-581.
46. PAL, S., CSERI, I., SEELIGER, O., RYS, M., SCHALLER, G., YU, W., TOMIC, D., BARAS, A., BERG, B., CHURIN, D., AND KOGAN, E. 2005. XQuery implementation in a relational database system. In Proceedings of the International Conference on Very Large Data Bases (VLDB). VLDB Endowment, Trondheim, Norway, 1175-1186.
47. PAPARIZOS, S., AL-KHALIFA, S., JAGADISH, H. V., LAKSHMANAN, L. V. S., NIERMAN, A., SRIVASTAVA, D., AND WU, Y. 2002. Grouping in XML. In EDBT '02: Proceedings of the Worshops XMLDM, MDDE, and YRWS on XML-Based Data Management and Multimedia Engineering-Revised Papers, Springer-Verlag, London, U.K., 128-147.
48. PIRAHESH, H., HELLERSTEIN, J. M., AND KASAN, W. 1992. Extensible/rule based query rewrite optimization in Starburst. In SIGMOD '92: Proceedings of the 1992 ACM SIGMOD International Conference on Management of Data. ACM Press, New York, NY, 39-48.
49. ROSENTHAL, A. AND GALINDO-LEGARIA, C. 1990. Query graphs, implementing trees, and freely-reorderable outerjoins. In SIGMOD '90: Proceedings of the 1990 ACM SIGMOD International Conference on Management of Data. ACM Press, New York, NY, 291-299.
50. SESHADRI, P., HELLERSTEIN, J. M., PIRAHESH, H., LEUNG, T. Y. C., RAMAKIRSHNAN, R., SRIVASTAVA, D., STUCKEY, P. J., AND SUDARSHAN, S. 1996a. Cost-based optimization for magic: Algebra and implementation. In SIGMOD '96: Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data. ACM Press, New York, NY, 435-446.
51. SESHADRI, P., PIRAHESH, H., AND LEUNG, T. Y. C. 1996b. Complex query decorrelation. In ICDE'96: Proceedings of the Twelfth International Conference on Data Engineering, IEEE Computer Society Press, Los Alamitos, CA, 450-458.
52. STEENHAGEN, H. J. 1995. Optimization of object query languages. Ph.D. dissertation. University of Twente, Enschede, The Netherlands.
53. STEENHAGEN, H. J., APERS, P. M. G., BLANKEN, H. M., AND DE BY, R. A. 1994. From nested-loop to join queries in OODB. In Proceedings of the International Conference on Very Large Data Bases (VLDB). Morgan Kaufmann, San Francisco, CA, 618-629.
54. YAN, W. P. AND LARSON, P.-Å. 1994. Performing group-by before join. In Proceedings of the Tenth International Conference on Data Engineering. IEEE Computer Society Press, Los Alamitos, CA, 89-100.