This Article 
 Bibliographic References 
 Add to: 
Evaluation and Optimization of Query Programs in an Object-Oriented and Symbolic Information System
June 1993 (vol. 5 no. 3)
pp. 479-495

OASIS, a database programming environment that extends UNIX with the concept of persistent objects, is discussed. The OASIS query languages extend conventional database query languages with procedural methods and general control statements. As the complexity of the languages makes it difficult to device a query optimizer based on a universally applicable algorithm, each query in OASIS is optimized based on a collection of basic patterns for which each pattern is associated with a separation query optimization algorithm. The optimization techniques for a set of basic patterns consisting of iterative statements and a set of nested statements is described. The optimization techniques discussed include an extended decomposition algorithm, evaluation of multiple conditions, data dependence analysis, and optimization of queries with arbitrary nesting.

[1] M. M. Astrahanet al., "System R: Relational approach to database management,"Trans. Database Syst., vol. 1, no. 1, pp. 97-137, 1976.
[2] A. V. Aho, R. Sethi, and J. D. Ullman,Compilers: Principles, Techniques, and Tools. Reading, MA: Addison-Wesley, 1986.
[3] M. P. Atkinson and O. P. Buneman, "Types and persistence in data-base programming languages,"ACM Computing Surveys, vol. 19, pp. 105-190, June 1987.
[4] M. J. Carey, D. J. Dewitt, J. E. Richardson, and E. J. Shekita, "Object and file management in the EXODUS extensible database system," inProc. Twelfth Int. Conf. Very Large Databases, pp. 91-100, 1986.
[5] U. Chakravarthy and J. Minker, "Processing multiple queries in database systems,"Database Eng,, vol. 1, 1982.
[6] U. S. Chakravarthy and J. Minker, "Multiple query processing in deductive databases using query graphs," inProc. Int. Conf. Very Large Data Bases, Kyoto, Japan, Aug. 1986, pp. 384-391.
[7] G. Copeland and D. Maier, "Making Smalltalk a database system," inProc. 1984 ACM-SIGMOD Int. Conf. Management of Data, Boston, MA, June 1984.
[8] D. Fish,et al., "Iris: An object-oriented database management system,"ACM Trans. Office Inform. Syst., vol. 5, pp. 48-69, Jan. 1987.
[9] H. Gallaire, J. Minker, and J. Nicolas, "Logic and databases: A deductive approach,"ACM Comput. Surveys, vol. 16, pp. 153-185,1984.
[10] R. Ganski and H. Wong, "Optimization of nested SQL queries revisited," inProc. ACM SIGMOD, May 1987, pp. 23-33.
[11] J. Grant and J. Minker, "On optimizing the evaluation of a set of expressions," Tech. Rep. TR-916, Univ. Maryland, College Park, MD, July 1980.
[12] J. Grant and J. Minker, "Optimization in deductive and conventional relational database systems," inAdvances in Database Theory, Vol. 1, H. Gallaire, J. Minker and J. Nicolas, Eds. New York: Plenum, 1981.
[13] M. Jarke and J. Koch, "Query optimization in database systems,"ACM Comput. Surveys, vol. 16, no. 2, June 1984.
[14] M. Jarke, "Common subexpression isolation in multiple query optimization," inQuery Processing in Database Systems, W. Kim, D. Reiner and D. Batory, Eds. New York: Springer-Verlag, 1984.
[15] W. Kim, "On optimizing an SQL-like nested query,"ACM Trans. Database Syst., vol. 7, no. 3, pp. 443-469, Sept. 1982.
[16] W. Kim, "Global optimization of relational queries: A first step," inQuery Processing in Database Systems, W. Kim, D. Reiner, and D. Batory, Eds. New York: Springer-Verlag, 1984.
[17] D. J. Kuck, R.H. Kuhn, B. Leasure, D.A. Padua, and M. Wolfe, "Compiler transformation of dependence graphs," inConf. Rec. 8th ACM Symp. Principles Program. Languages, Williamsburg, VA, Jan. 1981.
[18] R. MacGregor, "Ariel--A semantic front-end to relational DBMS's,"Proc. VLDB, 1985, pp. 305-315.
[19] G. Marque-Pucheu, J. M. Gallausiaux, and G. Jomier; "Interfacing Prolog and relational database management systems,"New Applications of Databases, Gardarin and Gelenbe, Eds. New York: Academic, 1984.
[20] D. Maieret al., "Development of an object-oriented DBMS," inProc. ACM OOPSLA'86, pp. 472-482, 1986.
[21] O'Brien, P., Bullis, B., and Schaffert, C., "Persistent and shared objects in trellis/owl," inProc. 1986 IEEE Workshop on Object-oriented Database Syst.
[22] J. Park and A. Segev, "Using common subexpression to optimize multiple queries," inProc. 4th Int. Conf. Data Eng., Feb. 1988, pp. 311-319.
[23] J. Park, T. Teorey, and S. Lafortune, "A knowledge-based approach to multiple query processing,"Data and Knowledge Engineering, Vol. 3, New York: North-Holland, 1989.
[24] L. Rowe and K. A. Shones, "Data abstraction, views and updates in RIGEL," inProc. ACM SIGMOD Int. Conf. Management Data, 1979. pp. 71-81.
[25] L. Rowe and M. Stonebraker, "The POSTGRES data model," inProc. 1987 VLDB Conf., Brighton, England, Sept. 1987.
[26] J. W. Schmidt, "Some high level constructs for data of type relation,"Trans. Database Syst., vol. 2, no. 3, pp. 247-261, 1977.
[27] T. Sellis, "Multiple-query optimization,"ACM Trans. Database Syst., vol. 13, no. 1, Mar. 1988.
[28] P.C.-Y. Sheu, R. L. Kashyap, and S. Yoo, "Query optimization in object-oriented knowledge bases,"Int. J. Data and Knowledge Eng., Mar. 1989.
[29] M. Stonebraker, "Quel as a data type," inProc. 1984 ACM-SIGMOD Int. Conf. Management of Data, Boston, MA, June 1984.
[30] M. Stonebrakeret al., "The design of the POSTGRES rules system," inProc. 1987 IEEE Data Eng. Conf., Los Angeles, CA, Feb. 1987.
[31] M. Stonebraker,et al., "The design and implementation of INGRES,"ACM Trans. Database Syst., vol. 1, no. 3, Sept. 1976.
[32] S. Tsur and C. Zaniolo, "An implementation of GEM-Supporting a semantic data model on a relational back end," inProc. 1984 ACM-SIGMOD Int. Conf. Management of Data, Boston, MA, June 1984.
[33] J. D. Ullman,Principles of Databases Systems. Rockville, MD: Computer Science Press, 1982.
[34] M. Wolfe and U. Banerjee, "Data Dependence and Its Application to Parallel Processing,"Int'l J. Parallel Programming, Vol. 16, No. 2, Apr. 1987, pp. 137-178.
[35] E. Wong and K. Youssefi, "Decomposition: A strategy for query processing,"ACM Trans. Database Syst., vol. 1, no. 3, Sept. 1976.

Index Terms:
object-oriented systems; optimization; query programs; symbolic information system; OASIS; database programming environment; query languages; procedural methods; general control statements; query optimizer; iterative statements; nested statements; decomposition algorithm; multiple conditions; data dependence analysis; arbitrary nesting; information retrieval; object-oriented databases; programming environments; query languages
S.B. Yoo, P.C.-Y. Sheu, "Evaluation and Optimization of Query Programs in an Object-Oriented and Symbolic Information System," IEEE Transactions on Knowledge and Data Engineering, vol. 5, no. 3, pp. 479-495, June 1993, doi:10.1109/69.224199
Usage of this product signifies your acceptance of the Terms of Use.