Abstract
Rule-based query optimizers are recognized as particularly valuable for extensible and object-oriented database management systems by providing a high flexibility in adapting query optimization strategies to nonstandard application needs. On the other hand rule-based optimizers are problematic with regard to run-time behavior for more complex queries as the generation of query plans based on a declarative rule base tends to be difficult to control. In this paper we show that this is not a fundamental problem of rule-based optimizers, but rather a question of careful design of the rule system. We exemplify this for one fundamental optimization problem, namely join enumeration for linear queries. There, a rule-based optimization strategy can achieve the theoretically optimal complexity. The design principles used to achieve this have been derived from and are used in the design of the VODAK query optimizer developed at GMD-IPSI.
Preview
Unable to display preview. Download preview PDF.
References
Aberer, K., Fischer, G.. Semantic Query Optimization for Methods in Object-Oriented Database Systems. In Proc. of 11th IEEE International Conference on Data Engineering, pp. 70–79, Taipei, Taiwan, March 6–10, 1995.
Aberer, K., Hemm, K. Semantic Optimization of Biomolecular Queries in Object-oriented Database Systems, Meeting on the Interconnection of Molecular Biology Databases (MIMBD) '95, Cambridge, UK, 1995.
Batory, D.S., Barnett, J.F., Garza, J.F., Smith, K.P., Tsukuda, K., Twichell, B.,C, and Wise, T.E. GENESIS: An extensible database management system. IEEE Trans. Softw. Eng. 14, 11(Nov. 1988), 1711–1730.
Becker, L., Guting, R.H. Rule-based Optimization and Query Processing in an Extensible Geometric Database System. In ACM Transaction on Database Systems, Vol. 17, No. 2, June 1992, pp. 247–303.
Blakeley, J., McKenna, W., and Graefe, G. 1993. Experiences building the Open OODB query optimizer. In Proc. ACM SIGMOD Int. Conf. On Management of Data, 287–296.
Böhm, K., Aberer, K., Neuhold, E. J. and Yang, X. Structured Document Storage and Refined Declarative and Navigational Access Mechanisms in HyperStorM. Accepted for publication in VLDB Journal, 1997.
Cattell, R.G.G. (ed). The Object Database Standard: ODMG-93, Release 1.2. Morgan Kaufmann Publishers, Inc., San Francisco, California, 1993.
Derrett, N., and Shan, M.-C. Rule-based query optimization in IRIS. In Proc. of the 17th Annual ACM computer Science Conference (Louisville, Kentucky Feb., 1989) pp. 78–86.
Dogac, A., Altinel, M., Ozkan, C., Durusoy I. Implementation Aspects of an Object-Oriented DBMS. In SIGMOD RECORD, Vol. 24, No. 1, March 1995.
Dogac, A., Ozkan, C, Arpinar, B., Okay, T., and Evrendilek, C. 1994. METU object-oriented DBMS. In Advances in Object-Oriented Database Systems, A. Dogac, M.T. Ozsu, A. Biliris, T. Sellis, Eds. Springer-Verlag.
Finance, B., Gardarin, G. A rule-based query optimizer with multiple search strategies. In Data & Knowledge Engineering 13 (1994) 1–29.
Freytag, J. 1987. A rule-based view of query optimization. In Proc. ACM SIGMOD Int. Conf. On Management of Data, 173–180.
Graefe, G. and DeWitt, D. The EXODUS optimizer generator. In Proc. ACM SIGMOD Int. Conf. On Management of Data, pp. 160–172, May 1997.
Graefe, G. Query Evaluation Techniques for Large Databases, ACM Computing Survey,Vol. 25, No. 2, pp. 73–170, June 1993.
Graefe, G., McKenna, W.J. The Volcano Optimizer Generator: Extensibility and Efficient Search. Proc. 9th ICDE, pp. 209–218, Vienna, Austria, April 19–23, 1993.
Guting, R.H. Gral: An extensible relational database system for geometric applications. In proc. of the 15th International Conference on Very Large Databases (Amsterdam 1989), pp. 33–44.
Haas, L., Cody, W., Freytag, J., Lapis, G., Lindsay, B., Lohman, G., Ono, K., and Pirahesh, H. 1989. Extensible query processing in Starburst. In Proc. ACM SIGMOD Int. Conf. On Management of Data, 377–388.
Hass, L.M., Chang, W., Lohman, G.M., McPHERSON J., Wilms, P.F., Lapis, G., Lindsay, B., Pirahesh, H., Carey, M.J., Shekita, E. Starburst Mid-flight: As the Dust Clears. In IEEE Transaction on Knowledge and Data Engineering, Vol. 2, No. 1, March, 1990.
Ibaraki, T., Kameda, T. Optimal nesting for computing N-relational joins. ACM Trans. on Database systems, 9(3): 482–502. 1984.
Lanzelotte, R. and Valduriez, P. Extending the search strategy in a query optimizer. In Proc. of 17th Int. conf. on Very Large Databases, pp. 363–373, 1991.
Mitchell, G., Zdonik, S.B., and Dayal, U. An Architecture for Query Processing in Persistent Object Stores. In Proc. of the Hawaii International Conference on System Sciences, Vol. II, pp. 787–798, January 1992.
Ono, K., Lohman, G. Measuring the Complexity of Join Enumeration in Query Optimization. Proc. of the 16th VLDB Conference, Brisbane, Australia 1990.
Ozkan, C., Evrendilek, C., Dogac, A., Gesli. T. Design and Implementation of Object-Oriented SQL Query Processor with an Optimizer. Technical Report, 1993, Software Research and Develop Center, Scientific and Technical Research Council of Turkiye Middle East Technical University.
Ozsu, M.T., and Blakeley, J.A. Query Processing in Object-Oriented Database Systems. In Modern Database Management — Object-oriented and Multidatabase Technologies, W.Kim (ed.), Addison-Wesley/ACM Press, 1994, pp. 146–174.
Ozsu, M.T., Munoz, A., Szafron, D. An Extensible Query Optimizer for an Objectbase Management System. In Proc. of the 4th Int. Conf. on Information and Knowledge Management (CIKM'95), November 1995, pp. 188–196.
Pellenkoft, A., Galindo-Legaria, C.A., Kersten, M., Duplicate-free Generation of Alternatives in Transformation-based Optimizers, Proc. of the Fifth International Conference on Database Systems for Advanced Applications, Australia, April 1997.
Stonebraker, M., and Rowe, L.A. The design of POSTGRES. In Proceedings of the ACM SIGMOD Conference (Washington, DC, May 1986), pp. 340–355.
VODAK V4.0 User Manual, GMD Technical Report No. 910, Sankt Augustin, April 1995.
Wolfram, S. Mathematica, A System for Doing Mathematics by Computer, Addison Wesley, 1988.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1997 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Aberer, K., Che, D., Böhm, K. (1997). Rule-based generation of logical query plans with controlled complexity. In: Bry, F., Ramakrishnan, R., Ramamohanarao, K. (eds) Deductive and Object-Oriented Databases. DOOD 1997. Lecture Notes in Computer Science, vol 1341. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-63792-3_28
Download citation
DOI: https://doi.org/10.1007/3-540-63792-3_28
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-63792-9
Online ISBN: 978-3-540-69647-6
eBook Packages: Springer Book Archive