This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
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
Citation:
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.