Using the co-existence approach to achieve combined functionality of object-oriented and relational systems

ABSTRACT

Once considered a novelty, object oriented systems have now entered the mainstream. Their impressive performance and rich type systems have created a demand for object oriented features in other areas, such as relational database systems. We believe the current efforts to combine object oriented and relational features into a single hybrid system will fall short of the mark, whereas our approach, the co-existence approach, has the distinction of requiring far less work, but at the same time promising both the desired functionality and performance. We describe the attributes of our co-existing systems, an object oriented system (C++) and a relational system (Starburst), and show how this combination supports the desired features of both object-oriented and relational systems.

REFERENCES

• 1: R. Ananthanarayanan, V. GottemukkMa, W. K#efer, T.J. Lehman, and H. Pirahesh. SMRC: Incorporating Object-Orientatlon into Starburst. Research Report, IBM Almaden Research Center, 1993. under preparation.
• 2: M. M. Astrahan , M. W. Blasgen , D. D. Chamberlin , K. P. Eswaran , J. N. Gray , P. P. Griffiths , W. F. King , R. A. Lorie , P. R. McJones , J. W. Mehl , G. R. Putzolu , I. L. Traiger , B. W. Wade , V. Watson, System R: relational approach to database management, ACM Transactions on Database Systems (TODS), v.1 n.2, p.97-137, June 1976 [doi>10.1145/320455.320457]
• 3: Michael Carey , George Lapis , Eugene Shekita , Bruce Lindsay , John McPherson, An incremental join attachment for Starburst, Proceedings of the sixteenth international conference on Very large databases, p.662-673, September 1990, Brisbane, Australia
• 4: Linda G. DeMichiel , Donald D. Chamberlin , Bruce G. Lindsay , Rakesh Agrawal , Manish Arya, Polyglot: Extensions to Relational Databases for Sharable Types and Functions in a Multi-Language Environment, Proceedings of the Ninth International Conference on Data Engineering, p.651-660, April 19-23, 1993
• 5: O. Deux, The O2 system, Communications of the ACM, v.34 n.10, p.34-48, Oct. 1991 [doi>10.1145/125223.125238]
• 6: L. M. Haas , W. Chang , G. M. Lohman , J. McPherson , P. F. Wilms , G. Lapis , B. Lindsay , H. Pirahesh , M. J. Carey , E. Shekita, Starburst Mid-Flight: As the Dust Clears, IEEE Transactions on Knowledge and Data Engineering, v.2 n.1, p.143-160, March 1990 [doi>10.1109/69.50910]
• 7: Joseph M. Hellerstein , Michael Stonebraker, Predicate migration: optimizing queries with expensive predicates, Proceedings of the 1993 ACM SIGMOD international conference on Management of data, p.267-276, May 25-28, 1993, Washington, D.C., United States
• 8: IBM IBM Database 2 Administration Guide, March 1992.
• 9: Informix, Guide to SQL Reference, December 1991.
• 10: I$O-.ANSI. ISO-ANSI Working Draft' Database Language SQL2 and SQL3; X3H2, ISO/IEC JTCI/SC21/WG3, 1992.
• 11: Alfons Kemper , Donald Kossmann, Adaptable Pointer Swizzling Strategies in Object Bases, Proceedings of the Ninth International Conference on Data Engineering, p.155-162, April 19-23, 1993
• 12: Charles Lamb , Gordon Landis , Jack Orenstein , Dan Weinreb, The ObjectStore database system, Communications of the ACM, v.34 n.10, p.50-63, Oct. 1991 [doi>10.1145/125223.125244]
• 13: T. J. Lehman , E. J. Shekita , L.-F. Cabrera, An Evaluation of Starburst's Memory Resident Storage Component, IEEE Transactions on Knowledge and Data Engineering, v.4 n.6, p.555-566, December 1992 [doi>10.1109/69.180606]
• 14: Bruce Lindsay , John McPherson , Hamid Pirahesh, A data management extension architecture, Proceedings of the 1987 ACM SIGMOD international conference on Management of data, p.220-226, May 27-29, 1987, San Francisco, California, United States
• 15: Mary E. S. Loomis, Client-server architecture, Journal of Object-Oriented Programming, v.4 n.6, p.40-44, Feb. 1992
• 16: J. Eliot B. Moss, Working with Persistent Objects: To Swizzle or Not to Swizzle, IEEE Transactions on Software Engineering, v.18 n.8, p.657-673, August 1992 [doi>10.1109/32.153378]
• 17: Harold Pirahesh and C. Mohan. Evolution of Relational DBMSs Toward Object Support A Practical Viewpoint. In Prec. Datenbanksysteme in Buro, Technik und Wissenschaft, Kaiserslautern, March 1991. Springer-V~rlag. Al#o ave.liable as IBM Research Report #J 8324, IBM Alma.den R.e#ea.rch Center, September 1991
• 18: Prec. 9th IEEE International Conference on Data Engineering, Vienna, April 1993
• 19: Bjarne Stroustrup, The C++ programming language, Addison-Wesley Longman Publishing Co., Inc., Boston, MA, 1986
• 20: Seth J. White , David J. DeWitt, A Performance Study of Alternative Object Faulting and Pointer Swizzling Strategies, Proceedings of the 18th International Conference on Very Large Data Bases, p.419-431, August 23-27, 1992
• 21: Paul Wilson. Pointer Swizzling at Page Fault Time: Efficiently Supporting Huge Address Spaces on Standard Hardware. Electrical Engineering andComputer Science Technical Report UIC-EECS-90-6, University of Illinois at chicago, June 1990.
• 22: Stanley B. Zdonik , David Maier, Object-oriented database systems, Readings in object-oriented database systems, Morgan Kaufmann Publishers Inc., San Francisco, CA, 1989

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT

Additional Classification:
  D. Software
  D.3 PROGRAMMING LANGUAGES
      D.3.2 Language Classifications

          Nouns: C++

  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.1 Logical Design
          Subjects: Data models

  J. Computer Applications
  J.6 COMPUTER-AIDED ENGINEERING
      Subjects: Computer-aided design (CAD)

General Terms:
Design, Languages, Performance