Query Optimization in Object—Oriented Database Systems

  • Wei Sun
  • Weiyi Meng
  • Clement Yu


In this paper, query processing and optimization in object-oriented database systems (OODBs) in a centralized environment is discussed. The typical chain query processing and optimization in OODBs is investigated in detail. An algorithm with complexity of O (n3) to minimize the total cost is provided using dynamic programming, where n is the number of classes referenced by the query. Many issues are addressed and integrated into our basic formulation of the problem. These include sorted states of classes, local processing of selections and projections, allowing multiple intermediate results, arbitrary answer class, class hierarchy (which captures the IS-A relationship among objects), loop query (a simple cyclic query).


Minimum Cost Query Processing Intermediate Result Nest Loop Query Optimization 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. ABGL88.
    Agrawal, P., D. Bitton, K. Guh, C. Liu and C. Yu, “A Case Study for Distributed Query Processing”, Int’l Symposium on Databases in Parallel and Distributed Systems, Dec. 1988 Google Scholar
  2. AFSA85.
    Afsarmanesh, H., D. Knapp, D. McLeod, and A. Parker, “An Object-Oriented Approach to VLSI/CAD”, Proc. of Int’l Con! on VLDB, August 1985, Stockholm, SwedenGoogle Scholar
  3. AFSA86.
    Afsarmanesh, H and Knapp D., “An Extensible Object_Oriented Approach to Data Bases for VLSI/CAD”,Proc. of Conf. on VLDB, 1986Google Scholar
  4. AHLS84.
    Ahlsen M., et al, “An Architecture for Object Management in OIS”, ACM Tran. on Office Information System, Vol. 2 No. 3, July 1984, pp. 173 - 196CrossRefGoogle Scholar
  5. ATWO85.
    Atwood, T. M., “An Object-oriented DBMS for Design Support Applications”, Proc. IEEE COMPINT 85,Montreal, Canada, pp. 299–307Google Scholar
  6. BANE88.
    Banerjee, J., W. Kim, K. C. Kim, “Queries in Object-Oriented Databases”, IEEE 4th Int’l Conf. on Data Engineering, Los Angeles, Feb. 1988, pp 31 – 38Google Scholar
  7. BEEC83.
    Beech, D. and J. Feldman, “The Integrated Data Model: A Database Perspective”, Proc. 9th Int. Conf. on VLDB, Florence, Italy, October 1983Google Scholar
  8. BOOC86.
    Booch, G., “Object-Oriented Development”, IEEE Trans. on Software Engineering, Vol. SE-12, No. 2, February 1986Google Scholar
  9. CARE88.
    Carey, M. J., D. J. DeWitt and S. L. Vandenberg, “A Data Model and Query Language of Exodus”, ACM-SIGMOD88, June, 1988, pp 413 – 423Google Scholar
  10. CHIU84.
    Chiu, D. M., P. Beinstein and Y. C. Ho, “Optimizing Chain Query in a Distributed Database System”, J. of Computing, SIAM, No. 1, Vol. 13, Feb. 1984, pp 116 – 134Google Scholar
  11. COX86.
    Cox, B. J, “Message/Object Programming: An Evolutionary Change in Programming”, IEEE Software 1986Google Scholar
  12. DANI82.
    Daniels, D., et al, “An Introduction to Distributed Query Compilation in R *”, IBM Research Rep, RJ3497, June 1982Google Scholar
  13. GOLD81.
    Goldberg, A., “Introducing the Smalltalk-80 System”, Byte,VOL. 6, NO. 8, AUGUST 1981, PP. 14–26Google Scholar
  14. GOLD83.
    Goldberg, A. and D. Robson, “SMALLTALK-80: The Language and its Implementation”, Addison-Wesley, 1983MATHGoogle Scholar
  15. HAAS89.
    Haas, L., J. Freytag, G. Lohman, and H. Pirahesh, “Extensible Query Processing in Starburst”, ACM SIGMOD 89, Portland, Oregon, 1989, pp. 377 – 388Google Scholar
  16. HARD86.
    Hardwick, M. and G. Sinha, “A Data Management System for Graphical Objects”, Proc. of Conf. on VLDB, 1986Google Scholar
  17. KIM87.
    Kim, W., K. Kim, and A. Dale, “Indexing Techniques for Object-Oriented Databases”, MCC TR134-87, May 1987Google Scholar
  18. KIM88.
    Kim, W., H.-T. Chou, and J. Banerjee, “Operations and Implementation of Complex Objects”, IEEE Transaction on Software Engineering, No. 7, Vol. 14, July 1988, pp 985 – 996Google Scholar
  19. KIM90.
    Kim, W., Garza, J., Ballou, N., and Woelk, D., “Architecture of the ORION Next-Generation Database System”, IEEE Trans. TKDE, No. 1, Vol. 2, March 1990, pp. 109 – 124Google Scholar
  20. LAFO86.
    Lafortune, S. and E. Wong, “A State Transition Model for Distributed Query Processing”, ACM Transactions on Database Systems, No. 3, Vol. 11, September 1986, pp 294 – 322Google Scholar
  21. LYNG84.
    Lyngbraek, P. and D. McLeod, “Object Management in Distributed Information System“, ACM Trans. on Office Information System, April 1984Google Scholar
  22. LYNG87.
    Lyngbaek, P. and V. Vianu, “Mapping a Semantic Database Model to the Relational Model”, ACM-SIGMOD, San Francisco, May 1987, pp 132 – 142Google Scholar
  23. NIER86.
    Nierstrasz, OM and DC Tsichritzis, “An Object-OrientedEnvironment for OIS Applications”, Proc. VLDB,1986Google Scholar
  24. SELI79.
    Selinger, P. G., et al, “Access Path Selection in a Relational Database Management System”, ACM-SIGMOD 79,pp 23–34Google Scholar
  25. SELI80.
    Selinger, P. G. and M. Adiba, “Access Path Selection in Distributed Database Management Systems”, IBM Research Lab., San Jose, Cal., RJ2883(36439), August 1980Google Scholar
  26. STON86.
    Stonebraker, M. and L. Rowe, “The Design of POSTGRES”,ACM SIGMOD86,Washington, D.C., May 1986, pp 340–355Google Scholar
  27. ULLM88.
    Ullman, J., “Database and Knowledge-based Systems”, Com-puter Science Press, 1988Google Scholar
  28. WOEL86.
    Woelk, D., W. Kim, and W. Luther, “An Object-Oriented Approach to Multimedia Databases”, Proc. ACM-SIGMOD, Washington D.C., May 1986Google Scholar
  29. WOEL87.
    Woelk, D., and W. Kim, “Multimedia Information Management in an Object-Oriented Database System”, Proc. VLDB, Brighton, England, Sept. 1987Google Scholar
  30. WOLF86.
    Wolf, W., “An Object-Oriented Procedural Database for VLSI Chip Planning”, Proc. of Design Automation Conf, 1986Google Scholar
  31. YLCC82.
    Yu, C.,et al, “A Promising Approach to Distributed Query Processing”, Berkeley Workshop on Database and Computer Network, 1982, pp 152 – 170Google Scholar
  32. YUCC84.
    Yu, C. and C. Chang, “Distributed Query Processing”, Computing Surveys, Vol. 16, No. 4, Dec. 1984CrossRefGoogle Scholar
  33. YUOZ84.
    Yu, C., M. Ozsoyoglu and K. Lam, “Distributed Query Optimization for Tree Queries”, Journal of Computer and System Science, 1984, pp 409 – 445Google Scholar
  34. ZANI83.
    Zaniolo, C. “The Database Language Gem”, ACM-SIGMOD, San Jose, California, May 1983, pp 207 – 217Google Scholar

Copyright information

© Springer-Verlag/Wien 1990

Authors and Affiliations

  • Wei Sun
    • 1
  • Weiyi Meng
    • 1
  • Clement Yu
    • 1
  1. 1.Department of Electrical Engineering and Computer ScienceUniversity of Illinois at ChicagoChicagoUSA

Personalised recommendations