Abstract
An important problem of OODB query optimization is to perform efficiently path traversals expressed in queries involving complex objects. Most optimizers consider a restricted search space with only traversals starting at either end of the path. In this paper, we propose a general framework for optimizing OODB queries including overlapping path traversals and explicit joins. This makes it possible to explore any traversal of a path supported by the target execution system. Furthermore, our approach enables the application of deterministic search strategies.
This work was partially funded by the Esprit project EDS.
Visiting ENST and INRIA, on leave from Pontificia Universidade Catolica do Rio de Janeiro (PUC-RIO).
This is a preview of subscription content, log in via an institution.
Preview
Unable to display preview. Download preview PDF.
References
S. Abiteboul: “Towards a Deductive Object-Oriented Database Language”, Journal of Data and Knowledge Engineering, Vol. 5, N∘ 4, October 1990.
F. Bancilhon, R. Ramakrishnan: “An Amateur's Introduction to Recursive Query Processing Strategies”, In Proceedings ACM SIGMOD International Conference on Management of Data, Washington DC, USA, May 1986.
F. Bancilhon, S. Cluet, C. Delobel: “Query Languages for object-oriented database systems: the O2 proposal”, In Proceedings International Conference on Database Programming Languages, Salishan Lodge, Oregon, June 1989.
C. Beeri, Y. Kornatsky: “Algebraic Optimization of Object-Oriented Query Languages”, In Proceedings International Conference on Database Theory, Paris, France, December 1990.
G. Copeland: “The Decomposition Storage Model”, In Proceedings ACM SIGMOD International Conference on Management of Data, May 1985.
G. Gardarin, P. Valduriez: “ESQL, an Extended SQL with Deductive and Object Capabilities”, In Proceedings International Conference on Database and Expert System Applications, Vienna, September 1990.
G. Graefe, D.J. Dewitt:“The EXODUS Optimizer Generator”, In Proceedings ACM SIGMOD International Conference on Management of Data, 1987.
Y.E. Ioannidis, E. Wong: “Query Optimization by Simulated Annealing”, In Proceedings ACM SIGMOD International Conference on Management of Data, San Francisco, USA, 1987.
A. Kemper, G. Moerkotte: “Advanced Query Processing in Object Bases Using Access Support Relations”, In Proceedings 16th International Conference on Very Large Data Bases, Brisbane, Australia, 1990.
W. Kim et al.: “Features of the ORION Object-Oriented Database System”, MCC Technical Report n∘ACA-ST-308-87, 1987.
W. Kim: “A Model of Queries in Object Oriented Databases”, In Proceedings 15th International Conference on Very Large Data Bases, Amsterdam, 1989.
R. Krishnamurty, H. Boral, C. Zaniolo: “Optimization of Nonrecursive Queries”, In Proceedings 12th International Conference on Very Large Data Bases, Kyoto, August 1986.
R.S.G. Lanzelotte: “OPUS: an extensible Optimizer for Up-to-date database Systems”, Ph. D. Thesis, Computer Science, PUC-RIO, 1990, available at INRIA, Rocquencourt, n∘ TU-127.
R.S.G. Lanzelotte, P. Valduriez: “Extending the Search Strategy in a Query Optimizer”, In Proceedings 17th International Conference on Very Large Data Bases, Barcelona, 1991.
R.S.G. Lanzelotte, J.-P. Cheiney: “Adapting Relational Optimisation Technology to Deductive and Object-oriented Declarative Database Languages”, In Proceedings 3rd International Workshop on Database Programming Languages, Nafplion, Greece, August 1991.
G. Lohman: “Grammar-like Functional Rules for Representing Query Optimization Alternatives”, In Proceedings ACM SIGMOD International Conference on Management of Data, 1988.
D. Maier, J. Stein: “Indexing in an Object-Oriented DBMS”, In Proceedings International Workshop on Object-Oriented Database Systems, Asilomar, California, September 1986.
P.G. Selinger et al.: “Access path selection in a relational database management system”, In Proceedings ACM SIGMOD International Conference on Management of Data, Boston, May 1979.
D.D. Straube, T. Oszu: “Queries and Query Processing in Object-Oriented Database Systems”, ACM Transactions on Office Information Systems, Vol. 8, N∘ 4, October 1990.
A. Swami: “Optimization of Large Join Queries: combining Heuristics and Combinatorial Techniques”, In Proceedings ACM SIGMOD International Conference on Management of Data, Portland, USA, 1989.
P. Valduriez, S. Khoshafian, G. Copeland: “Implementation Techniques of Complex Objects”, In Proceedings 12th International Conference on Very Large Data Bases, Kyoto, August 1986.
P. Valduriez: “Join Indices”, ACM Transactions on Database Systems, Vol. 12, N∘ 2, June 1987.
P. Valduriez, S. Danforth: “Query Optimization in Database Programming Languages”, In Proceedings 1st International Conference on Deductive and Object-Oriented Databases, Kyoto, Japan, December 1989.
P.F. Wilms, P.M. Schwarz, H.-J. Schek, L.M. Haas: “Incorporating Data Types in an Extensible Database Architecture”, In Proceedings 3rd International Conference on Data and Knowledge Bases, Jerusalem, June 1988.
E. Wong, K. Youssefi: “Decomposition — A Strategy for Query Processing”, ACM Transactions on Database Systems, Vol. 1, N∘ 3, September 1976.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1991 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Lanzelotte, R.S.G., Valduriez, P., Ziane, M., Cheiney, JP. (1991). Optimization of nonrecursive queries in OODBs. In: Delobel, C., Kifer, M., Masunaga, Y. (eds) Deductive and Object-Oriented Databases. DOOD 1991. Lecture Notes in Computer Science, vol 566. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-55015-1_1
Download citation
DOI: https://doi.org/10.1007/3-540-55015-1_1
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-55015-0
Online ISBN: 978-3-540-46646-8
eBook Packages: Springer Book Archive