Skip to main content
SpringerLink
Log in

Nested Queries in Object Bases

  • Conference paper
Book cover Database Programming Languages (DBPL-4)

Part of the book series: Workshops in Computing ((WORKSHOPS COMP.))

Abstract

Many declarative query languages for object-oriented databases allow nested subqueries. This paper contains the first (to our knowledge) proposal to optimize them. A two-phase approach is used to optimize nested queries in the object-oriented context. The first phase—called dependency-based optimization—transforms queries at the query language level in order to treat common subexpressions and independent subqueries more efficiently. The transformed queries are translated to nested algebraic expressions. These entail nested loop evaluation which may be very inefficient. Hence, the second phase unnests nested algebraic expres­sions to allow for more efficient evaluation.

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. M. M. Astrahan and D. D. Chamberlin. Implementation of a structured English query language. Communications of the ACM, 18 (10): 580–588, 1975.

    Article  MATH  Google Scholar 

  2. F. Bancilhon, S. Cluet, and C. Delobel. A query language for the 02 object-oriented database system. In DBPL II, Salishan Lodge, Oregan, 1989.

    Google Scholar 

  3. D. Beech. A foundation for evolution from relational to object databases. In EDBT, 1988.

    Google Scholar 

  4. C. Beeri and Y. Kornatzky. Algebraic optimization of object-oriented query languages. In Proc. Int. Conf. on Database Theory (ICDT), pages 72–88, 1990.

    Google Scholar 

  5. M. Carey, D. DeWitt, and S. Vandenberg. A data model and query language for EXODUS. In Proc. of the ACM SIGMOD Conf. on Management of Data, pages 413–423, 1988.

    Google Scholar 

  6. S. Ceri and G. Gottlob. Translating SQL into relational algebra: Optimization, semantics and equivalence of SQL queries. IEEE Trans. on Software Eng., pages 324–345, 1985.

    Google Scholar 

  7. S. Cluet and C. Delobel. A general framework for the optimization of object-oriented queries. In Proc. of the ACM SIGMOD Conf. on Management of Data, pages 383–392, 1992.

    Google Scholar 

  8. U. Dayal. Of nests and trees: A unified approach to processing queries that contain nested subqueries, aggregates, and quantifiers. In VLDB, pages 197–208, 1987.

    Google Scholar 

  9. Deux. The story of o2. IEEE Transaction on Knowledge and Data Engineering, 2 (1), March 1989.

    Google Scholar 

  10. G. Lohman et al. Optimization of nested queries in a distributed relational database. In Proc. Int. Conf. on Very Large Data Bases (VLDB), 1984.

    Google Scholar 

  11. R. Ganski and H. Wong. Optimization of nested SQL queries revisited. In Proc. of the ACM SIGMOD Conf. on Management of Data, pages 23–33, 1987.

    Google Scholar 

  12. W. Hasan and H. Pirahesh. Query rewrite optimization in starburst. Research Report RJ6367, IBM, 1988.

    Google Scholar 

  13. P. Jenq, D. Woelk, W. Kim, and W. Lee. Query processing in distributed ORION. In Proc. Int. Conf. on Extended Database Technology (EDBT), Venice, 1990.

    Google Scholar 

  14. A. Kemper and G. Moerkotte. Advanced query processing in object bases using access support relations. In Proc. Int. Conf. on Very Large Data Bases, pages 294–305, 1990.

    Google Scholar 

  15. A. Kemper and G. Moerkotte. Query optimization in object bases: Exploiting relational techniques. In Proc. Dagstuhl Workshop on Query Optimization (J.-C. Freytag, D. M aier and G. Vossen (eds.)). Morgan-Kaufman, to appear 1993.

    Google Scholar 

  16. A. Kemper, G. Moerkotte, and K. Peithner. A blackboard architecture for query optimization in object bases. Informatik-Fachberichte 92–31, RWTH Aachen, 5100 Aachen, Germany, 1992.

    Google Scholar 

  17. W. Kiessling. SQL-like and Quel-like correlation queries with aggregates revisited. ERL/UCB Memo 84/75, University of Berkeley, 1984.

    Google Scholar 

  18. W. Kim. A model of queries for object-oriented database. In Proc. Int. Conf. on Very Large Data Bases (VLDB), 1989.

    Google Scholar 

  19. W. Kim. On optimizing an SQL-like nested query. ACM Trans. on Database Systems,7(3):443–469, Sep 82.

    Google Scholar 

  20. M. Muralikrishna. Optimization and dataflow algorithms for nested tree queries. In Proc. Int. Conf. on Very Large Data Bases (VLDB), 1989.

    Google Scholar 

  21. M. Muralikrishna. Improved unnesting algorithms for join aggregate SQL queries. In Proc. Int. Conf. on Very Large Data Bases (VLDB), pages 91–102, 1992.

    Google Scholar 

  22. A. Rosenthal and C. Galindo-Legaria. Query graphs, implementing trees, and freely-reorderable outerjoins. In Proc. of the ACM SIGMOD Conf. on Management of Data, pages 291–299, 1990.

    Google Scholar 

  23. G.M. Shaw and S.B. Zdonik. A query algebra for object-oriented databases. In Proc. IEEE Conference on Data Engineering, pages 154–162, 1990.

    Google Scholar 

  24. D. Straube and T. Özsu. Queries and query processing in object-oriented database systems. ACM Trans. on Information Systems, 8 (4): 387–430, 1990.

    Article  Google Scholar 

  25. S. L. Vandenberg and D. DeWitt. Algebraic support for complex objects with arrays, identity, and inheritance. In Proc. of the ACM SIGMOD Conf. on Management of Data, pages 158–167, 1991.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Domaine de Voluceau, INRIA, 78153, Le Chesnay Cedex, France

    Sophie Cluet

  2. Fakultät für Informatik, Universität Karlsruhe, D-7500, Karlsruhe, Germany

    Guido Moerkotte

Authors
  1. Sophie Cluet
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Guido Moerkotte
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Institute of Computer Science, The Hebrew University of Jerusalem, 91904, Givat-Ram, Jerusalem, Israel

    Catriel Beeri PhD

  2. Research Institute for Mathematical Sciences, Kyoto University, Kitashirakawa, Sakyo-ku, 606-01, Kyoto, Japan

    Atsushi Ohori PhD

  3. Department of Computer Science, Courant Institute of Mathematical Sciences, New York University, 251 Mercer Street, 10012-1185, New York, NY, USA

    Dennis E. Shasha PhD

Rights and permissions

Reprints and permissions

Copyright information

© 1994 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Cluet, S., Moerkotte, G. (1994). Nested Queries in Object Bases. In: Beeri, C., Ohori, A., Shasha, D.E. (eds) Database Programming Languages (DBPL-4). Workshops in Computing. Springer, London. https://doi.org/10.1007/978-1-4471-3564-7_13

Download citation

  • DOI: https://doi.org/10.1007/978-1-4471-3564-7_13

  • Publisher Name: Springer, London

  • Print ISBN: 978-3-540-19853-6

  • Online ISBN: 978-1-4471-3564-7

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation