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.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
C. Beeri and Y. Kornatzky, “Algebraic Optimization of Object-Oriented Query Languages.” Proc. Intl. Conf. on Database Theory, 1990, pp. 72–88.
E. Bertino and D. Musto, “Query Optimization by Using Knowledge about Data Semantics.” IEEE Trans. on Knowledge and Data Engineering, 1992, pp. 121–155.
E. Bertino and L. Martino, Object-Oriented Database Systems: Concepts and Architectures, Addison-Wesley, 1994.
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.
Cattell, R.G.G., et al., The Object Database Standard: ODMG-93, release 1.2, Morgan Kaufmann, 1996.
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.
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.
W. Kim, “A Model of Queries for Object-Oriented Databases.” Proc. Intl. Conf. on Very Large Data Bases, 1989, pp. 423–432.
J. J. King, “QUIST: A System for Semantic Query Optimization in Relational Databases.” Proc. Intl. Conf. on Very Large Data Bases, 1981.
J. J. King, Query Optimization by Semantic Reasoning. UMI Research Press, Ann Arbor, MI, 1984.
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.
R. MacGregor, and M.H. Burstein, “Using a Description Classifier to Enhance Knowledge Representation Systems,” IEEE Expert, Vol. 6, No. 3, June 1991.
S. Nigam, “Transformation-based Semantic Query Optimization for Object-Oriented Databases.” M.S. Thesis, Database Systems Laboratory, ECE Dept., University of Cincinnati, 1994.
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.
J. Rumbaugh, M. Blaha, W. Premerlani, F. Eddy, and W. Lorensen, Object-Oriented Modeling and Design, Prentice-Hall, 1991.
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.
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.
S. B. Zdonik, “Query Optimization in Object-Oriented Databases.” Proc. Intl. Conf. on Software Systems, 1989.
Author information
Authors and Affiliations
Editor information
Rights 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