Abstract
This paper describes some concepts for the evaluation and optimization of ODMG-OQL queries. We present a logical object algebra for the internal representation of OQL queries. Different optimization techniques are sketched: factorization of common subexpressions, dependency-based optimization, and query rewriting. Afterwards, our physical algebra is presented and a complex example of the optimization process is given. We describe our implementation and the present investigations using search strategies to find the best execution plan. In contrast to previous studies on the evaluation of object-oriented queries, we use a logical and a physical algebra in the process of evaluation and optimization of OQL queries, thus achieving logical data independence. Other basic ideas of our work are the integration of different optimization techniques into one approach and the use of cost functions especially valid for the object-oriented database system ObjectStore.
Preview
Unable to display preview. Download preview PDF.
References
K. Aberer and G. Fischer. Semantic Query Optimization for Methods in Object-Oriented Database Systems. In Proc. of the 11th ICDE, Taipei, Taiwan, 1995.
R. Asmus. Concept and Implementation of an Optimized OQL Query Processor on Top of ObjectStore. Master's thesis, CS Dept., University of Rostock, 1995. In german.
J.A. Blakeley, W.J. McKenna, and G. Graefe. Experiences Building the Open OODB Query Optimizer. In Proc. of the ACM SIGMOD Conf., Washington DC, USA, 1993.
R.G.G. Cattell, editor. The Object Database Standard: ODMG-93. Morgan Kaufmann, San Mateo, CA, 1994.
S. Cluet and C. Delobel. A General Framework for the Optimization of Object-Oriented Queries. In Proc. of the ACM SIGMOD Conf., San Diego, CA, 1992.
R. L. Cole and G. Graefe. Optimization of Dynamic Query Evaluation Plans. In Proc. of the ACM SIGMOD 23,2, 1994.
S. Cluet and G. Moerkotte. Nested Queries in Object Bases. In Proc. of the 4th Int'l Workshop on DBPL — Object Models and Languages, NY, 1994. Springer, London.
L. Fegaras and D. Maier. Towards an Effective Calculus for Object Query Languages. In Proc. of the ACM SIGMOD Conf., San Jose, CA, 1995.
L. Fegaras, D. Maier, and T. Sheard. Specifying Rule-based Query Optimizers in a Reflective Framework. In Proc. of the 3rd DOOD, New York, 1993. Springer.
D. Gluche, T. Grust, H. Riedel, M. H. Scholl, A. Asmus, A. Heuer, and J. Kröger. The CROQUE project: Object Queries Dressed for Success. 1996. In preparation.
Torsten Grust and Marc H. Scholl. Translating OQL into Monoid Comprehensions — Stuck with Nested Loops? Technical Report 3/1996, Dept. of Mathematics and CS, University of Konstanz, 1996.
A. Heuer, J. Fuchs, and U. Wiebking. OSCAR: An Object-Oriented Database System with a Nested Relational Kernel. In Proc. of the 9th Int. Conf. on Entity-Relationship Approach, Lausanne. Elsevier, 1990.
A. Heuer and J. Kröger. Query Optimization in the CROQUE Project (extended version). Preprint CS-05-96, CS Dept., University of Rostock, 1996.
Z. Jiao and P. M. D. Gray. Optimisation of Methods in a Navigational Query Language. In LNCS 566, Proc. of the 2nd DOOD, 1991.
A. Kemper and G. Moerkotte. Access Support in Object Bases. In Proc. of the ACM SIGMOD Conf. on Management of Data, Atlantic City, NJ, 1990.
T. W. Leung, G. Mitchell, B. Subramanian, B. Vance, S. L. Vandenberg, and S. B. Zdonik. The AQUA Data Model and Algebra. In Proc. of the 4th Int'l Workshop on DBPL, New York, 1993. Springer.
C. Laasch and M. H. Scholl. A Functional Object Database Language. In Proc. of the 4th Int'l Workshop on DBPL, New York, 1993. Springer.
Object Design Inc. ObjectStore C++ Performance Release 4, 1995.
J. Orenstein, S. Haradhvala, B. Margulies, and D. Sakahara. Query Processing in the ObjectStore Database System. In Proc. ACM SIGMOD Conf. on Management of Data, 1992.
A. Poulovassilis and C. Small. Investigation of Algebraic Query Optimisation for Database Programming Languages. In Proc. of the 20th VLDB Conf., Santiago, Chile, 1994.
C. Rich and M.H. Scholl. Query Optimization in an OODBMS. In Proc. of the GI-Conf. on Database Systems “in Büro, Technik und Wissenschaft (BTW)”. Springer, Informatik aktuell, 1993.
H. Riedel and M. H. Scholl. The CROQUE-Model: Formalization of the Data Model and Queries. 1996. In preparation.
H. J. Steenhagen, P. M. G. Apers, and H. M. Blanken. Optimization of Nested Queries in a Complex Object Model. In Proc. of the EDBT, Cambridge, 1994.
P. Trinder. Comprehensions, a Query Notation for DBPLs. In Proc. of the 3rd Int'l Workshop on DBPL, Nafplion, Greece, 1991.
P. Trinder and P. Wadler. Improving List Comprehension Database Queries. In Proc. of TENCON'89, Bombay, India, 1989.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1996 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Heuer, A., Kröger, J. (1996). Query optimization in the CROQUE project. In: Wagner, R.R., Thoma, H. (eds) Database and Expert Systems Applications. DEXA 1996. Lecture Notes in Computer Science, vol 1134. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0034704
Download citation
DOI: https://doi.org/10.1007/BFb0034704
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-61656-6
Online ISBN: 978-3-540-70651-9
eBook Packages: Springer Book Archive