This Article 
 Bibliographic References 
 Add to: 
Main Memory Orientated Optimization of OO Queries Using Typed Datalog with Foreign Predicates
December 1992 (vol. 4 no. 6)
pp. 517-528

Object-oriented database systems (OODBs) have created a demand for relationally complete, extensible, and declarative object-oriented query languages. Until now, the runtime performance of such languages was far behind that of procedural OO interfaces. One reason is the internal use of a relational engine with magnetic disk resident databases. The authors address the processing of the declarative OO language WS-OSQL, provided by the fully operational prototype OODB called WS-IRIS. A WS-IRIS database is main memory (MM) resident. The system architecture, data structures, and optimization techniques are designed accordingly. WS-OSQL queries are compiled into an OO extension of Datalog called ObjectLog, providing for objects, typing, overloading, and foreign predicates for extensibility. Cost-based optimizations in WS-IRIS using ObjectLog are presented. Performance tests show that WS-IRIS is about as fast as current OODBs with procedural interfaces only and is much faster than known relationally complete systems. These results would not be possible for a traditional disk-based implementation. However, MM residency of a database appears to be only a necessary condition for better performance. An efficient optimization is of crucial importance as well.

[1] R. Ahmed, P. DeSmedt, W. Du, W. Kent, M. A. Ketabchi, W. A. Litwin, A. Rafii, and M-C. Shan, "The Pegasus heterogeneous multidatabase system,"IEEE Comput., vol. 24, Dec. 1991.
[2] J. Annevelink, "Database programming languages: A functional approach," inProc. ACM SIGMOD Conf., 1991, pp. 318-327.
[3] Abiteboul and A. Bonner: "Objects and views," inProc. ACM SIGMOD Conf., 1991, pp. 238-247.
[4] M. Careyet al., "A data model and query language for EXODUS," inProc. ACM SIGMOD Int. Conf. Management of Data, pp. 413-423, June 1988.
[5] R. G. G. Cattell and J. Skeen, "Object operations benchmark,"ACM Trans. Database Syst., vol. 17, no. 1, pp. 1-31, Mar. 1992.
[6] D. Chimenti, "Towards an open architecture for LDL," inProc. 15th VLDB, 1989, pp. 195-203.
[7] T. Connors and P. Lyngbaek, "Providing uniform access to heterogeneous information bases," inLecture Notes in Computer Science 334, Advances in Object-Oriented Database Ssytems, K. Dittrich, Ed. Berlin, Germany: Springer-Verlag, Sept. 1988.
[8] O. Deux, "The O2system,"CACM, vol. 34, no. 10, Oct. 1991.
[9] M. Guo, S. Y. W. Su, and H. Lam, "An association algebra for processing object-oriented databases," inProc. 7th Data Engineering conf., 1991, pp. 23-32.
[10] D. H. Fishmanet al., "Overview of the IRIS DBMS," inObject Oriented Concepts, Databases, and Applications, W. Kim and F. H. Lochowsky, Eds. New York: ACM, 1989.
[11] ITASCA Technical Summary, ITASCA Systems, Inc., 1990.
[12] A. Kemper and G. Moerkotte, "Advanced query processing in object bases using access support relations," inProc. 16th VLDB Conf., 1990, pp. 290-301.
[13] W. Kim and F. H. Lochovsky,Object-Oriented Concepts, Databases and Applications, New York: ACM Press, 1989.
[14] W. Kim,Introduction to Object-Oriented Databases. Cambridge, MA: MIT, 1990.
[15] R. Krishnamurthy, H. Boral, and C. Zaniolo, "Optimization of nonrecursive queries," inProc. 12th Int. Conf. Very Large Data Bases, Aug. 1986, pp. 128-137.
[16] R. Krishnamurthy and C. Zaniolo, "Optimization in a logic based language for knowledge and data intensive applications," inProc. Int. Conf. Extending Database Technol. (EDBT88). Venice, 1988; andLNCS, No. 303. New York: Springer-Verlag, 1988.
[17] W. Leler,Constraint Programming Languages. Reading, MA: Addison-Wesley, 1988.
[18] K. Li and J. Naughton, "Multiprocessor main memory transaction processong," inProc. Int. Symp. Databases Parallel Distributed Syst., ACM, IEEE-CS, Austin, TX, Dec. 1988, pp. 177-187: also, CS-TR-159-88, Comput. Science Dep., Princeton Univ., June 1988.
[19] W. Litwin and M-A. Neimat, "Distributed linear hashing," Tech. Rep. HPL-DTD-92-7, Database Technology Dept., HP-Laboratories, Palo Alto, 1992.
[20] Y. Lou and Z. M. Ozsoyoglu, "LLO: An object-oriented deductive language with methods and method inheritance," inProc. ACM SIGMOD Conf., 1991, pp. 198-207.
[21] D. Maieret al., "Development of an object-oriented DBMS," inProc. ACM OOPSLA'86, pp. 472-482, 1986.
[22] A. Mycroft and R. A. O'Keefe, "A polymorphic type system for Prolog,"Artificial Intell., vol. 23, pp. 295-307, 1985.
[23] S. Naqvi and S. Tsur,A Logical Language for Data and Knowledge Bases. New York: Computer Sci. Press, 1989.
[24] J. Orenstein, S. Haradhvala, B. Margulies, and D. Sakahara, "Query processing in the ObjectStore database system," inProc. ACM SIGMOD Conf., 1992, pp. 393-402.
[25] T. Risch, "Monitoring Database Objects,"Proc. 15th Int'l Conf. Very Large Databases, VLDB Foundation, 1989, pp. 445- 453.
[26] T. Risch, "WS-IRIS, A main memory object-oriented DBMS," Tech. Rep. HPL-DTD-92-5, Database Technology Dept., HP-Laboratories. Palo Alto, 1992.
[27] S. Zdonik and D. Maier, eds.,Readings in Object-Oriented Database Systems, Morgan Kaufmann, San Mateo, Calif., 1990.
[28] P. Selinger,et al., "Access path selection in a relational data base system," inProc. 1979 ACM-SIGMOD Int. Conf. Management of Data, Boston, MA, June 1979.
[29] G. M. Shaw and S. B. Zdonik, "Object-oriented queries: Equivalence and optimization,"Proc. 1st Conf. Deductive and OO Databases, 1989, pp. 264-278.
[30] M. Stonebraker and L. Rowe, "The design of POSTGRES," inProc. 1986 ACM-SIGMOD Conf. Management of Data, Washington, DC, May 1986.
[31] N.K. Jha and Q. Tong, "Testing of multiple-output domino logic (MODL) CMOS circuits,"IEEE J. Solid-State Circuits, vol. 25, no. 3, pp. 800-805, June 1990.
[32] M. Takizawa, "Distributed database system JDDBS,"JARECT Computer Science&Technologies, Vol 7. Amsterdam, The Netherlands: North Holland, 1983, pp. 262-283.
[33] S. Tsur and N. Garrison,LDL User's Guide, MCC Tech. Rep. STP-LD- 295-91, 1991.
[34] J. D. Ullman,Database and Knowledge-base Systems. Rockville, MD: Computer Science Press, 1988.
[35] D. S. Warren, "Memoing for logic programs,"CACM, vol. 35, no. 3, Mar. 1992.
[36] G. Wiederhold, "Views, objects, and databases,"Computer, vol. 19, no. 12, pp. 37-44, Dec. 1986.
[37] K. Wilkinson, P. Lyngbaek, and W. Hasan, "The IRIS architecture and implementation,"IEEE Trans. Knowl. Data Eng., vol. 2, Mar. 1990.

Index Terms:
object-oriented database; main memory resident; declarative object-oriented language; typed Datalog; object-oriented query languages; relational engine; magnetic disk resident databases; WS-OSQL; WS-IRIS database; system architecture; data structures; optimization techniques; ObjectLog; typing; overloading; foreign predicates; object-oriented databases; object-oriented languages; query languages; query processing; relational databases
W. Litwin, T. Risch, "Main Memory Orientated Optimization of OO Queries Using Typed Datalog with Foreign Predicates," IEEE Transactions on Knowledge and Data Engineering, vol. 4, no. 6, pp. 517-528, Dec. 1992, doi:10.1109/69.180603
Usage of this product signifies your acceptance of the Terms of Use.