Optimizing Object Queries Using an Effective Calculus

ACM Transactions on Database Systems

Volumn 25, Issue 4, 2000, Pages 457-516

  Fegaras, Leonidas ^a   Maier, David ^b  

^a The University of Texas at Arlington   (United States)

^b OREGON HEALTH AND SCIENCE UNIVERSITY   (United States)

Author keywords

Design; Experimentation; H.2.1 Database management : Logical design; Nested relations; Object oriented databases; Performance; Query decorrelation; Query optimization

Indexed keywords

EID: 0010385667     PISSN: 03625915     EISSN: None     Source Type: Journal    
DOI: 10.1145/377674.377676     Document Type: Article

References (55)

1. BEECH, D. 1993. Collections of objects in SQL3. In Proceedings of the Nineteenth International Conference on Very Large Data Bases (VLDB '93, Dublin, Ireland, Aug.). Morgan Kaufmann Publishers Inc., San Francisco, CA, 244-255.
2. BEERI, C. AND KORNATZKY, Y. 1990. Algebraic optimization of object-oriented query languages. In Proceedings of the Third International Conference on Database Theory (ICDT '90, Paris, France, Dec.), S. Abiteboul and P. C. Kanellakis, Eds. Springer Lecture Notes in Computer Science. Springer-Verlag, New York, NY, 72-88.
3. BELLANTONI, S. AND COOK, S. 1992. A new recursion-theoretic characterization of the polytime functions (extended abstract). In Proceedings of the 24th Annual ACM Symposium on Theory of Computing (STOC '92, Victoria, B. C., Canada, May 4-6), R. Kosaraju, M. Fellows, A. Wigderson, and J. Ellis, Chairs. ACM Press, New York, NY, 283-293.
4. BREAZU-TANNEN, V., BUNEMAN, P., AND NAQVI, S. 1992a. Structural recursion as a query language. In Proceedings of the Third International Workshop on Database Programming Languages: Bulk Types & Persistent Data (DBPL3, Nafplion, Greece, Aug. 27-30), P. Kanellakis and J. W. Schmidt, Eds. Morgan Kaufmann Publishers Inc., San Francisco, CA, 9-19.
5. BREAZU-TANNEN, V., BUNEMAN, P., AND WONG, L. 1992b. Naturally embedded query languages. In Proceedings of the 4th International Conference on Database Theory (LNCS 646, Berlin). Springer-Verlag, New York, NY.
6. BREAZU-TANNEN, V. AND SUBRAHMANYAM, R. 1991. Logical and computational aspects of programming with sets/bags/lists. In Proceedings of the 18th International Colloquium on Automata, Languages and Programming (Madrid, July 8-12), J. L. Albert, B. R. Artalejo, and B. Monien, Eds. Springer Lecture Notes in Computer Science. Springer-Verlag, New York, NY, 60-75.
7. BUNEMAN, P., LIBKIN, L., SUCIU, D., TANNEN, V., AND WONG, L. 1994. Comprehension syntax. SIGMOD Rec. 23, 1 (Mar.), 87-96.
8. BUNEMAN, P., NAQVI, S., TANNEN, V., AND WONG, L. 1995. Principles of programming with complex objects and collection types. Theor. Comput. Sci. 149, 1 (Sept. 18), 3-48.
9. CAREY, M. AND DEWITT, D. 1996. Of objects and databases: A decade of turmoil. In Proceedings of the 22nd International Conference on Very Large Data Bases (VLDB '96, Bombay, Sept.). Morgan Kaufmann Publishers Inc., San Francisco, CA, 3-14.
10. CAREY, M. J., DEWITT, D. J., FRANKLIN, M. J., HALL, N. E., MCAULIFFE, M. L., NAUGHTON, J. F., SCHUH, D. T., SOLOMON, M. H., TAN, C. K., TSATALOS, O. G., WHITE, S. J., AND ZWILLING, M. J. 1994. Shoring up persistent applications. SIGMOD Rec. 23, 2 (June), 383-394.
11. CATTELL, R., ED. 2000. The Object Data Standard: ODMG 3.0. Morgan Kaufmann, San Mateo, CA.
12. CHAN, D. AND TRINDER, P. 1994. Object comprehensions: A query notation for object-oriented databases. In Proceedings of the 12th British Conference on Databases (Guildford, UK, July). Morgan Kaufmann Publishers Inc., San Francisco, CA, 55-72.
13. CHERNIACK, M. AND ZDONIK, S. 1998a. Changing the rules: Transformations for rule-based optimizers. SIGMOD Rec. 27, 2, 61-72.
14. CHERNIACK, M. AND ZDONIK, S. 1998b. Inferring function semantics to optimize queries. In Proceedings of the 24th International Conference on Very Large Data Bases. 239-250.
15. 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 23rd International Conference on Very Large Data Bases (VLDB '97, Athens, Greece, Aug.). 286-295.
16. CLUET, S. AND DELOBEL, C. 1992. A general framework for the optimization of object-oriented queries. SIGMOD Rec. 21, 2 (June 1), 383-392.
17. CLUET, S. AND MOERKOTTE, G. 1995a. Efficient evaluation of aggregates on bulk types. Tech. Rep. 95-05. Aachen University of Technology, Aachen, Germany.
18. CLUET, S. AND MOERKOTTE, G. 1995b. Nested queries in object bases. In Proceedings of the Fifth International Workshop on Database Programming Languages (Gubbio, Italy, Sept.).
19. COLBY, L. S. 1989. A recursive algebra and query optimization for nested relations. SIGMOD Rec. 18, 2 (June), 273-283.
20. DANFORTH, S. AND VALDURIEZ, P. 1992. A FAD for data intensive applications. IEEE Trans. Knowl. Data Eng. 4, 1 (Feb.), 34-51.
21. DANIELS, S., GRAEFE, G., KELLER, T., MAIER, D., SCHMIDT, D., AND VANCE, B. 1991. Query optimization in revelation, an overview. Data Eng. 14, 2 (June), 58-62.
22. DEUX, O. 1990. The story of O2. IEEE Trans. Knowl. Data Eng. 2, 1, 91-108.
23. EISENBERG, A. AND MELTON, J. 1999. SQL1999, formerly known as SQL3. SIGMOD Rec. 28, 1 (Mar.), 131-138.
24. FEGARAS, L. 1993. Efficient optimization of iterative queries. In Proceedings of the International Workshop on Database Programming Languages (New York, NY). Morgan Kaufmann Publishers Inc., San Francisco, CA, 200-225.
25. FEGARAS, L. 1998a. A new heuristic for optimizing large queries. In Proceedings of the Ninth International Conference on DEXA (Vienna, Aug.). Springer-Verlag, Heidelberg, Germany, 726-735.
26. FEGARAS, L. 1998b. Query unnesting in object-oriented databases. SIGMOD Rec. 27, 2, 49-60.
27. FEGARAS, L. 1999a. Optimizing queries with object updates. J. Intell. Inf. Syst. 12, 219-242.
28. FEGARAS, L. 1999b. VOODOO: A visual object-oriented database language for ODMG OQL. In Proceedings of the First ECOOP Workshop on Object-Oriented Databases (Lisbon, Portugal, June). 61-72.
29. FEGARAS, L. AND MAIER, D. 1995. Towards an effective calculus for object query languages. In Proceedings of the 1995 ACM SIGMOD International Conference on Management of Data (SIGMOD '95, San Jose, CA, May 23-25), M. Carey and D. Schneider, Eds. ACM Press, New York, NY, 47-58.
30. FEGARAS, L., MAIER, D., AND SHEARD, T. 1993. Specifying rule-based query optimizers in a reflective framework. In Proceedings of the Conference on Deductive and Object-Oriented Databases (Phoenix, AZ, Dec.). Springer-Verlag, Vienna, Austria, 146-168.
31. FEGARAS, L., SRINIVASAN, C., RAJENDRAN, A., AND MAIER, D. 2000. λ-db: An odmg-based object-oriented dbms. In Proceedings of the ACM SIGMOD Conference on Management of Data (SIGMOD '2000, Dallas, TX, May). ACM Press, New York, NY.
32. GANSKI, R. A. AND WONG, H. K. T. 1987. Optimization of nested SQL queries revisited. SIGMOD Rec. 16, 3 (Dec.), 23-33.
33. KEMPER, A. AND MOERKOTTE, G. 1990. Advanced query processing in object bases using access support relations. In Proceedings of the 16th International Conference on Very Large Data Bases (VLDB, Brisbane, Australia, Aug. 13-16), D. McLeod, R. Sacks-Davis, and H. Schek, Eds. Morgan Kaufmann Publishers Inc., San Francisco, CA, 290-301.
34. KIM, W. 1982. On optimizing an SQL-like nested query. ACM Trans. Database Syst. 7, 3 (Sept.), 443-469.
35. LEIVANT, D. 1993. Stratified functional programs and computational complexity. In Proceedings of the 20th Annual ACM SIGPLAN-SIGACT Symposium on Principles of Programming Languages (POPL '93, Charleston, SC, Jan. 10-13), S. L. Graham, Ed. ACM Press, New York, NY, 325-333.
36. LEUNG, T., MITCHELL, G., SUBRAMANIAN, B., VANCE, B., VANDENBERG, S., AND ZDONIK, S. 1993. The AQUA data model and algebra. In Proceedings of the International Workshop on Database Programming Languages (New York, NY). Morgan Kaufmann Publishers Inc., San Francisco, CA, 157-175.
37. LEVY, A. Y., MUMICK, I. S., AND SAGIV, Y. 1994. Query optimization by predicate move-around. In Proceedings of the 20th International Conference on Very Large Data Bases (VLDB'94, Santiago, Chile, Sept.). VLDB Endowment, Berkeley, CA, 96-107.
38. LIBKIN, L., MACHLIN, R., AND WONG, L. 1996. A query language for multidimensional arrays: design, implementation, and optimization techniques. SIGMOD Rec. 25, 2, 228-239.
39. LIN, J. AND OZSOYOGLU, Z. M. 1996. Processing OODB queries by O-algebra. In Proceedings of the Fifth International Conference on Information and Knowledge Management (CIKM '96, Rockville, MD, Nov. 12-16), M. T. Özsu and K. Barker, Eds. ACM Press, New York, NY, 134-142.
40. MAIER, D. AND VANCE, B. 1993. A call to order. In Proceedings of the Twelfth ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (PODS, Washington, DC, May 25-28), C. Beeri, Chair. ACM Press, New York, NY, 1-16.
41. MEIJER, E., FOKKINGA, M., AND PATERSON, R. 1991. Functional programming with bananas, lenses, envelopes and barbed wire. In Proceedings of the Fifth ACM Conference on Functional Programming Languages and Computer Architecture (Cambridge, MA, Aug. 26-30), J. Hughes, Ed. Springer Lecturer Notes in Computer Science. Springer-Verlag, New York, NY, 124-144.
42. MUMICK, I. S., FINKELSTEIN, S. J., PIRAHESH, H., AND RAMAKRISHNAN, R. 1990. Magic is relevant. SIGMOD Rec. 19, 2 (June), 247-258.
43. MURALIKRISHNA, M. 1992. Improved unnesting algorithms for join aggregate SQL queries. In Proceedings of the 18th International Conference on Very Large Data Bases (Vancouver, B.C., Aug.). VLDB Endowment, Berkeley, CA, 91-102.
44. OZSOYOGLU, Z. AND WANG, J. 1992. A keying method for a nested relational database management system. In Proceedings of the Eighth International Conference on Data Engineering (Tempe, AZ, Feb.).
45. PEYTON, JONES, S. L. 1987. The Implementation of Functional Programming Languages. Prentice-Hall, New York, NY.
46. PIERCE, B. C. 1991. Basic Category Theory for Computer Scientists. Computing. MIT Press, CAmbridge, MA.
47. PISTOR, P AND TRAUNMUELLER, R. 1986. A database language for sets, lists and tables. Inf. Syst. 11, 4 (Oct.), 323-336.
48. SELINGER, P. G., ASTRAHAN, M. M., LORIE, R. A., AND PRICE, T. G. 1979. Access path selection in a relational database management system. In Proceedings of the ACM SIGMOD International Conference on Management of Data (SIGMOD '79, Boston, MA, May 30-June 1). ACM Press, New York, NY, 23-34.
49. STEENHAGEN, H. J., APERS, P. M. G., AND BLANKEN, H. M. 1994. Optimization of nested queries in a complex object model. In Proceedings of the Fourth International Conference on Extending Database Technology: Advances in Database Technology (EDBT '94, Cambridge, UK, Mar. 28-31), M. Jarke, J. Bubenko, and K. Jeffery, Eds. Springer Lecture Notes in Computer Science. Springer-Verlag, New York, NY, 337-350.
50. THOMPSON, S. 1998. Haskell: The Craft of Functional Programming. Reading, MA.
51. TRINDER, P. 1992. Comprehensions, a query notation for DBPLs. In Proceedings of the Third International Workshop on Database Programming Languages: Bulk Types & Persistent Data (DBPL3, Nafplion, Greece, Aug. 27-30), P. Kanellakis and J. W. Schmidt, Eds. Morgan Kaufmann Publishers Inc., San Francisco, CA, 55-68.
52. TRINDER, P. AND WADLER, P. 1989. Improving list comprehension database queries. In Proceedings of on TENCON'89 (Bombay, Nov.). 186-192.
53. WADLER, P. 1990. Comprehending monads. In Proceedings of the 1990 ACM Symposium on LISP and Functional Programming (Nice, France, June 27-29), G. Kahn, Chair. ACM Press, New York, NY, 61-78.
54. WONG, L. 1993. Normal forms and conservative properties for query languages over collection types. In Proceedings of the Twelfth ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (PODS, Washington, DC, May 25-28), C. Beeri, Chair. ACM Press, New York, NY, 26-36.
55. WONG, L. 1994. Querying nested collections. Ph.D. Dissertation. University of Pennsylvania, Philadelphia, PA.