Skip to main content

The Real Benefits of Object-Relational DB-Technology for Object-Oriented Software Development

  • Conference paper
  • First Online:

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 2097))

Abstract

Object-oriented programming languages (OOPLs like C++, Java, etc.) have established themselves in the development of complex software systems for more than a decade. With the integration of object-oriented concepts, objectrelational database management systems (ORDBMSs) aim at supporting new generation software systems better and more efficiently. Facing the situation that nowadays more and more software development teams use OOPLs ‘on top of’ (O)RDBMSs, i. e., access (object-)relational databases from applications developed in OOPLs, this paper reports on our investigations on assessing the contribution of object-relational database technology to object-oriented software development. First, a conceptual examination shows that there is still a considerable gap between the object-relational paradigm (as represented by the SQL:1999 standard) and the object-oriented paradigm. Second, empirical studies (performed by using our new benchmark approach) point at mechanisms, which are not part of SQL:1999 but would allow to reduce the mentioned gap. Thus, we encourage the integration of such mechanisms, e. g., support for navigation and complex objects (structured query results), into ORDBMSs in order to be really beneficial for new generation software systems.

This is a preview of subscription content, log in via an institution.

Buying options

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Bernhard, R., Flehmig, M., Mahdoui, A., Ritter, N., Steiert, H.-P., Zhang, W.P.: “Building a Persistent Class System on top of (O)RDBMS–Concepts and Evaluations”, Internal Report, University of Kaiserslautern, 1999

    Google Scholar 

  2. Bernstein, P.A., Harry, B., Sanders, P.J., Shutt, D., Zander, J.: “The Microsoft Repository”, Proc. VLDB Conf., 1997, pp. 3–12

    Google Scholar 

  3. Bernstein, P.A., Pal, S., Shutt, D.: “Context-Based Prefetch for Implementing Objects on Relations”, Proc. VLDB Conf., 1999, pp. 327–338

    Google Scholar 

  4. Bitton, D., DeWitt, D.J., Turbyfill, C.: “Benchmarking Database Systems: A Systematic Approach”, Proc. VLDB Conf., 1983, pp. 8–19

    Google Scholar 

  5. Carey, M.J., DeWitt, D.J.: “Of Objects and Databases: A Decade of Turmoil”, Proc. VLDB Conf., 1996, pp. 3–14

    Google Scholar 

  6. Carey, M.J., DeWitt, D.J., Naughton, J.F., Asgarian, M., Brown, P., Gehrke, J.E., Shah, D.N.: “The Bucky Object-Relational Benchmark”, Proc. VLDB Conf., 1996, pp. 135–146

    Google Scholar 

  7. Carey, M.J., DeWitt, D.J., Kant, C., Naughton, J.F.: “A Status Report on the OO7 OODBMS Benchmarking Effort”, Proc. ACM OOPSLA, 1994, pp. 414–426

    Google Scholar 

  8. Carey, M.J., Doole, D., Mattos, N.M.: “O-O, What Have They Done to DB2?“, Proc. 1999 25th. VLDB Conf., pp. 542–553

    Google Scholar 

  9. Cattell, R.G.G., Barry, D., Bartels, D., et al: “The Object Database Standard:ODMG 2.0”, Morgan-Kaufman Publishers, San Mateo, 1997

    MATH  Google Scholar 

  10. Gray, J.: “The Benchmark Handbook for Database and Transaction Processing Systems”, Morgen Kaufmann Publishers, San Mateo, CA, USA, 2nd Ed., 1993

    MATH  Google Scholar 

  11. Gulutzan, P., Pelzer, T.: “SQL-99 Complete, Really”, R&D Publications, 1999

    Google Scholar 

  12. Keller, A., Jensen, R., Agrawal, S.: “Persistence Software: Bridging Object-Oriented Programming and Relational Database”, Proc. ACM SIGMOD Conf., 1993, pp. 523–528

    Google Scholar 

  13. Mahnke, W., Steiert, H.-P.: “The Application Protential of ORDBMS in the Design Environments”, Proc. CAD 2000, Berlin, pp. 219–239 (in German)

    Google Scholar 

  14. Ontos Business Data Server, http://www.ontos.com

  15. Poet Object Server, POET Software, POET SQL Object Factory, http://poet.com/

  16. Rao, B.R.: “Object-oriented Databases: Technology, Applications, and Products”, McGraw-Hill, New York, 1994

    Google Scholar 

  17. RogueWave Software, DBTools.h++, http://www.roguewav3e.com/products/dbtools/

  18. Schreiber, H.: “JUSTITIA: A Generic Benchmark for the OODBMS Selection”, Int. Conference on Data and Knowledge Systems in Manufacturing and Engineering, Tokyio, 1994

    Google Scholar 

  19. Scheller, T.: “Functionality of the Class System in System R/3”, Function Description, Version 0.9, SAP, Dec. 1997

    Google Scholar 

  20. SQL99: ANSI/ISO/IEC 9075-1-1999 Database Launguages SQL Part 1 Framework

    Google Scholar 

  21. SQL99: ANSI/ISO/IEC 9075-2-1999 Database Languages SQL Part 2 Foundation

    Google Scholar 

  22. Stonebraker, M., Brown, P., Moor, D.: “Object-relational DBMSs–The Next Wave”, Morgan Kaufmann, 2nd Ed., 1998

    Google Scholar 

  23. TPC: Transaction Processing Performance Council, Standard Specification 1.0, May 1995, http://www.tpc.org

  24. UML, Rational Software Corp. Unified Modeling Language, http://www.rational.com/

  25. Zhang, W.P.: “Evaluation of the First Generation ORDBMSs by Using Bucky Benchmark” Internal Report, University of Kaiserslautern, 1998

    Google Scholar 

  26. Zhang, W.P., Ritter, N.: “Measuring the Contribution of (O)RDBMS to Object-Oriented Software Development”, Proc. IDEAS 2000, pp. 243–249

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2001 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Zhang, W., Ritter, N. (2001). The Real Benefits of Object-Relational DB-Technology for Object-Oriented Software Development. In: Read, B. (eds) Advances in Databases. BNCOD 2001. Lecture Notes in Computer Science, vol 2097. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45754-2_7

Download citation

  • DOI: https://doi.org/10.1007/3-540-45754-2_7

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-42265-5

  • Online ISBN: 978-3-540-45754-1

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics