Skip to main content
SpringerLink
Log in
Book cover

International Conference on Extending Database Technology

EDBT 1992: Advances in Database Technology — EDBT '92 pp 534–549Cite as

Optimizing object-oriented database queries using cost-controlled rewriting

  • Conference paper
  • First Online:

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 580))

Abstract

Declarative languages for Object-oriented DBMSs combine navigational accesses, expressed as path traversals, to associative ones. Works on query optimization for OODBs usually focus on optimizing one of the aspects (e.g., path traversals) neglecting others (e.g., associative joins). This work proposes a rule-based approach for optimizing uniformly all features encountered in queries in OODBs. Queries and rules are expressed using an easily readable functional formalism, functional symbols providing a natural way to represent both path traversals and method calls. Cost estimations are assigned to each functional equation. This enables the application of transformation rules on systems of equations under the control of deterministic cost-based search strategies, such as Iterative Improvement or Simulated Annealing.

on leave from PUC-RIO, Brazil

This article was processed using the LaTEX macro package with LMAMULT style

This is a preview of subscription content, log in via an institution.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. C. Beeri, Y. Kornatzky: ”Algebraic Optimization of Object-Oriented Query Languages”, In Proc. Int. Conf. on Database Theory, Paris, France, December 1990.

    Google Scholar 

  2. B. Finance, G. Gardarin: ”A Rule-Based Query Rewriter in an Extensible DBMS”, In Proc. 7th IEEE Int. Conf. on Data Engineering, Kyoto, Japan, 1991.

    Google Scholar 

  3. J.C. Freytag: ”A Rule-Based View of Query Optimization”, In Proc. ACM SIGMOD Int. Conf. on Management of Data, 1987.

    Google Scholar 

  4. G. Gardarin: ”Magic Functions: A Technique to Optimize Extended Datalog Recursive Programs”, In Proc. 13th Int. Conf. on Very Large Data Bases, Brighton, England, 1987.

    Google Scholar 

  5. G. Gardarin, P. Valduriez: ”ESQL2, an Extended SQL with F-Logic Semantics”, In Proc. 8th IEEE Int. Conf. on Data Engineering, Salt Lake City, USA, 1992.

    Google Scholar 

  6. G. Graefe, D.J. Dewitt: ”The EXODUS Optimizer Generator”, In Proc. ACM SIGMOD Int. Conf. on Management of Data, 1987.

    Google Scholar 

  7. Y.E. Ioannidis, E. Wong: ”Query Optimization by Simulated Annealing”, In Proc. ACM SIGMOD Int. Conf. on Management of Data, San Francisco, USA, 1987.

    Google Scholar 

  8. Y.E. Ioannidis, Y. Cha Kang: ”Randomized Algorithms for Optimizing large join queries”, In Proc. ACM SIGMOD Int. Conf. on Management of Data, USA, 1990.

    Google Scholar 

  9. A. Kemper, G. Moerkotte: ”Access Support in Object Bases”, In Proc. ACM SIGMOD Int. Conf. on Management of Data, USA, 1990.

    Google Scholar 

  10. A. Kemper, G. Moerkotte: ”Advanced Query Processing in Object Bases Using Access Support Relations”, In Proc. 16th Int. Conf. on Very Large Data Bases, Brisbane, Australia, 1990.

    Google Scholar 

  11. R.S.G. Lanzelotte, P. Valduriez: ”Extending the Search Strategy in a Query Optimizer”, In Proc. 17th Int. Conf. on Very Large Data Bases, Barcelona, Spain, 1991.

    Google Scholar 

  12. R.S.G. Lanzelotte, J.-P. Cheiney: ”Adapting Relational Optimization Technology to Deductive and Object-oriented Declarative Database Languages”, In Proc. 3rd Int. Workshop on Database Programming Languages, Nafplion, Greece, 1991.

    Google Scholar 

  13. K.M. Lee, J.C. Freytag, G.M. Lohman: ”Implementing an Interpreter for Functional Rules in a Query Optimizer”, In Proc. 14th Int. Conf. on Very Large Data Bases, Los Angeles, 1988.

    Google Scholar 

  14. D. Maier, J. Stein: ”Indexing in an Object-Oriented DBMS”, In Proc. Int. Workshop on Object-Oriented Database Systems, Asilomar, California, September 1986.

    Google Scholar 

  15. E. Sciore, J. Sieg Jr.: ”A Modular Query Optimizer Generator”, In Proc. 6th IEEE Int. Conf. on Data Engineering, Los Angeles, 1990.

    Google Scholar 

  16. D.W. Shipman: ”The Functional Data Model and the Data Language DAPLEX”, ACM Transactions on Database Systems, Vol. 6, N. 1, March 1981.

    Google Scholar 

  17. A. Swami: ”Optimization of Large Join Queries: combining Heuristics and Combinatorial Techniques”, In Proc. ACM SIGMOD Int. Conf. on Management of Data, Portland, USA, 1989.

    Google Scholar 

  18. P. Valduriez, S. Khoshafian, G. Copeland: ”Implementation Techniques of Complex Objects”, In Proc. 12th Int. Conf. on Very Large Data Bases, Kyoto, August 1986.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. MASI CNRS University P-M CURIE, 78000, Versailles, France

    Georges Gardarin

  2. INRIA Rocquencourt, 78153, Le Chesnay, France

    Rosana S. G. Lanzelotte

Authors
  1. Georges Gardarin
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Rosana S. G. Lanzelotte
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Alain Pirotte Claude Delobel Goerg Gottlob

Rights and permissions

Reprints and permissions

Copyright information

© 1992 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Gardarin, G., Lanzelotte, R.S.G. (1992). Optimizing object-oriented database queries using cost-controlled rewriting. In: Pirotte, A., Delobel, C., Gottlob, G. (eds) Advances in Database Technology — EDBT '92. EDBT 1992. Lecture Notes in Computer Science, vol 580. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0032453

Download citation

  • DOI: https://doi.org/10.1007/BFb0032453

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-55270-3

  • Online ISBN: 978-3-540-47003-8

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation