Skip to main content
SpringerLink
Log in

A semantic query optimization algorithm for object-oriented databases

  • Conference paper
  • First Online:
Constraint Databases and Applications (CDB 1997)

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

Included in the following conference series:

  • 162 Accesses

Abstract

This paper investigates an algorithm for semantic query optimization for object-oriented databases (OODBs). Semantic query optimization is accomplished by applying transformation rules that use semantic integrity constraints to modify queries to execute more efficiently. Data structures and a transformation algorithm are developed here for efficient constraint selection and processing. To verify that transformed queries can be executed more efficiently, a cost analysis method is utilized that compares the cost of an original query and the cost of its modified version. Representing and manipulating semantic knowledge in an OODB and effectively using this knowledge to enhance query performance are contributions of this research.

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.

References

  1. C. Beeri and Y. Kornatzky, “Algebraic Optimization of Object-Oriented Query Languages.” Proc. Intl. Conf. on Database Theory, 1990, pp. 72–88.

    Google Scholar 

  2. E. Bertino and D. Musto, “Query Optimization by Using Knowledge about Data Semantics.” IEEE Trans. on Knowledge and Data Engineering, 1992, pp. 121–155.

    Google Scholar 

  3. E. Bertino and L. Martino, Object-Oriented Database Systems: Concepts and Architectures, Addison-Wesley, 1994.

    Google Scholar 

  4. A. Borgida, R.J. Brachman, D.L. McGuinness, and L.A. Resnick, “CLASSIC: A Structural Data Model for Objects.” Proceedings of the 1989 SIGMOD Conference, Portland, Oregon, 1989.

    Google Scholar 

  5. Cattell, R.G.G., et al., The Object Database Standard: ODMG-93, release 1.2, Morgan Kaufmann, 1996.

    Google Scholar 

  6. J. P. Cheiney and R. S. G. Lanzelotte, “A Model for Optimizing Deductive and Object-Oriented DB Requests.” Intl. Conf. on Data Engineering, 1992, pp. 385–392.

    Google Scholar 

  7. L.M.L Delcambre, and K.C. Davis, “Automatic Validation of Object-Oriented Database Structures,” Proceedings of the Fifth International Conference on Data Engineering, Los Angeles, February, 1989.

    Google Scholar 

  8. W. Kim, “A Model of Queries for Object-Oriented Databases.” Proc. Intl. Conf. on Very Large Data Bases, 1989, pp. 423–432.

    Google Scholar 

  9. J. J. King, “QUIST: A System for Semantic Query Optimization in Relational Databases.” Proc. Intl. Conf. on Very Large Data Bases, 1981.

    Google Scholar 

  10. J. J. King, Query Optimization by Semantic Reasoning. UMI Research Press, Ann Arbor, MI, 1984.

    Google Scholar 

  11. R. Lanzelotte and P. Valduriez, “Extending the Search Strategy in a Query Optimizer.” Proc. Intl. Conf. on Very Large Data Bases, 1991, pp. 363–374.

    Google Scholar 

  12. R. MacGregor, and M.H. Burstein, “Using a Description Classifier to Enhance Knowledge Representation Systems,” IEEE Expert, Vol. 6, No. 3, June 1991.

    Google Scholar 

  13. S. Nigam, “Transformation-based Semantic Query Optimization for Object-Oriented Databases.” M.S. Thesis, Database Systems Laboratory, ECE Dept., University of Cincinnati, 1994.

    Google Scholar 

  14. H. H. Pang, H. J. Lu, and B. C. Ooi, “An Efficient Semantic Query Optimization Algorithm.” Proc. Intl. Conf. on Data Engineering, pp. 326–335, 1991.

    Google Scholar 

  15. J. Rumbaugh, M. Blaha, W. Premerlani, F. Eddy, and W. Lorensen, Object-Oriented Modeling and Design, Prentice-Hall, 1991.

    Google Scholar 

  16. P. C. Sheu, R. L. Kashyap, and S. Yoo, “Query Optimization in Object-Oriented Knowledge bases.” IEEE Trans. on Knowledge and Data Engineering, 1988, pp. 285–302.

    Google Scholar 

  17. W. Sun, N. Rishe, Y. Ding, and C. Liu, “Knowledge-based Query Optimization in an Object-Oriented Database System.” IEEE Transactions on Knowledge and Data Engineering, pp. 1657–1662, 1991.

    Google Scholar 

  18. S. B. Zdonik, “Query Optimization in Object-Oriented Databases.” Proc. Intl. Conf. on Software Systems, 1989.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Sybase, Inc., 94608, Emeryville, CA

    Samir Nigam

  2. Karen C. Davis, Database Systems Laboratory, ECECS Department, University of Cincinnati, USA

    Karen C. Davis

Authors
  1. Samir Nigam
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Karen C. Davis
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Volker Gaede Alexander Brodsky Oliver Günther Divesh Srivastava Victor Vianu Mark Wallace

Rights and permissions

Reprints and permissions

Copyright information

© 1996 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Nigam, S., Davis, K.C. (1996). A semantic query optimization algorithm for object-oriented databases. In: Gaede, V., Brodsky, A., Günther, O., Srivastava, D., Vianu, V., Wallace, M. (eds) Constraint Databases and Applications. CDB 1997. Lecture Notes in Computer Science, vol 1191. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-62501-1_42

Download citation

  • DOI: https://doi.org/10.1007/3-540-62501-1_42

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-62501-8

  • Online ISBN: 978-3-540-68049-9

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation