A semantic query optimization algorithm for object-oriented databases

  • Samir Nigam
  • Karen C. Davis
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1191)


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.


Transformation Rule Query Optimization Transformation Algorithm Semantic Constraint Knowledge Graph 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 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. 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. 3.
    E. Bertino and L. Martino, Object-Oriented Database Systems: Concepts and Architectures, Addison-Wesley, 1994.Google Scholar
  4. 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. 5.
    Cattell, R.G.G., et al., The Object Database Standard: ODMG-93, release 1.2, Morgan Kaufmann, 1996.Google Scholar
  6. 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. 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. 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. 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. 10.
    J. J. King, Query Optimization by Semantic Reasoning. UMI Research Press, Ann Arbor, MI, 1984.Google Scholar
  11. 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. 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. 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. 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. 15.
    J. Rumbaugh, M. Blaha, W. Premerlani, F. Eddy, and W. Lorensen, Object-Oriented Modeling and Design, Prentice-Hall, 1991.Google Scholar
  16. 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. 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. 18.
    S. B. Zdonik, “Query Optimization in Object-Oriented Databases.” Proc. Intl. Conf. on Software Systems, 1989.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1996

Authors and Affiliations

  • Samir Nigam
    • 1
  • Karen C. Davis
    • 2
  1. 1.Sybase, Inc.Emeryville
  2. 2.Karen C. Davis, Database Systems Laboratory, ECECS DepartmentUniversity of CincinnatiUSA

Personalised recommendations