Skip to main content
Springer Nature Link
Log in

Optimization of nonrecursive queries in OODBs

  • Conference paper
  • First Online:
Deductive and Object-Oriented Databases (DOOD 1991)

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

Included in the following conference series:

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 to check access.

Access this chapter

Log in via an institution

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Similar content being viewed by others

References

  1. S. Abiteboul: “Towards a Deductive Object-Oriented Database Language”, Journal of Data and Knowledge Engineering, Vol. 5, N∘ 4, October 1990.

    Google Scholar 

  2. 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.

    Google Scholar 

  3. 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.

    Google Scholar 

  4. C. Beeri, Y. Kornatsky: “Algebraic Optimization of Object-Oriented Query Languages”, In Proceedings International Conference on Database Theory, Paris, France, December 1990.

    Google Scholar 

  5. G. Copeland: “The Decomposition Storage Model”, In Proceedings ACM SIGMOD International Conference on Management of Data, May 1985.

    Google Scholar 

  6. 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.

    Google Scholar 

  7. G. Graefe, D.J. Dewitt:“The EXODUS Optimizer Generator”, In Proceedings ACM SIGMOD International Conference on Management of Data, 1987.

    Google Scholar 

  8. Y.E. Ioannidis, E. Wong: “Query Optimization by Simulated Annealing”, In Proceedings ACM SIGMOD International Conference on Management of Data, San Francisco, USA, 1987.

    Google Scholar 

  9. 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.

    Google Scholar 

  10. W. Kim et al.: “Features of the ORION Object-Oriented Database System”, MCC Technical Report n∘ACA-ST-308-87, 1987.

    Google Scholar 

  11. W. Kim: “A Model of Queries in Object Oriented Databases”, In Proceedings 15th International Conference on Very Large Data Bases, Amsterdam, 1989.

    Google Scholar 

  12. R. Krishnamurty, H. Boral, C. Zaniolo: “Optimization of Nonrecursive Queries”, In Proceedings 12th International Conference on Very Large Data Bases, Kyoto, August 1986.

    Google Scholar 

  13. 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.

    Google Scholar 

  14. 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.

    Google Scholar 

  15. 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.

    Google Scholar 

  16. G. Lohman: “Grammar-like Functional Rules for Representing Query Optimization Alternatives”, In Proceedings ACM SIGMOD International Conference on Management of Data, 1988.

    Google Scholar 

  17. D. Maier, J. Stein: “Indexing in an Object-Oriented DBMS”, In Proceedings International Workshop on Object-Oriented Database Systems, Asilomar, California, September 1986.

    Google Scholar 

  18. 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.

    Google Scholar 

  19. 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.

    Google Scholar 

  20. 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.

    Google Scholar 

  21. P. Valduriez, S. Khoshafian, G. Copeland: “Implementation Techniques of Complex Objects”, In Proceedings 12th International Conference on Very Large Data Bases, Kyoto, August 1986.

    Google Scholar 

  22. P. Valduriez: “Join Indices”, ACM Transactions on Database Systems, Vol. 12, N∘ 2, June 1987.

    Google Scholar 

  23. 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.

    Google Scholar 

  24. 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.

    Google Scholar 

  25. E. Wong, K. Youssefi: “Decomposition — A Strategy for Query Processing”, ACM Transactions on Database Systems, Vol. 1, N∘ 3, September 1976.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. INRIA, Rocquencourt, France

    Rosana S. G. Lanzelotte, Patrick Valduriez, Mikal Ziane & Jean-Pierre Cheiney

  2. Bull Research Center, Les Clayessous-Bois

    Mikal Ziane

  3. Ecole Nationale Supérieure des Télécommunications (ENST), Paris

    Jean-Pierre Cheiney

Authors
  1. Rosana S. G. Lanzelotte
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Patrick Valduriez
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Mikal Ziane
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Jean-Pierre Cheiney
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

C. Delobel M. Kifer Y. Masunaga

Rights and permissions

Reprints 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

Publish with us

Policies and ethics