Skip to main content
SpringerLink
Log in

Extending UML for Object-Relational Database Design

  • Conference paper
  • First Online:
≪UML≫ 2001 — The Unified Modeling Language. Modeling Languages, Concepts, and Tools (UML 2001)

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

Included in the following conference series:

Abstract

The most common way of designing databases is using de E/R model without taking into account other views of the system. However, new object-oriented design languages, such as UML (Unified Modelling Language), permit modelling the full system, including the database schema, in a uniform way. Besides, as UML is an extensible language, it allows introducing new stereotypes for specific applications if it is needed. There are some proposals to extend UML with stereotypes for database design but, unfortunately, they are focused on relational databases. However, new applications require representing complex objects related with complex relationships and object-relational databases are more appropriated to support the new application requirements. The framework of this paper is an Object- Relational Database Design Methodology. The methodology defines new UML stereotypes for Object-Relational Database Design and proposes some guidelines to translate an UML schema into an object-relational one. The guidelines are based on the SQL:1999 object-relational model and on Oracle8i as an example of product. In this paper we focus on the UML extensions required for object-relational database design.

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

Access this chapter

Log in via an institution
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

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Ambler (1999), Persistence Modelling in the UML. In: http://www.sdmagazine.com/articles/1999/0008/0008q/0008q.htm

  2. Atzeni, Ceri, Paraboschi and Torlone (1999). Database Systems. Concepts, Languages and Architectures. McGraw-Hill.

    Google Scholar 

  3. Bertino and Marcos (2000), “Object Oriented Database Systems”. In Advanced Databases: Technology and Design, O. Díaz and M. Piattini (Eds.). Artech House.

    Google Scholar 

  4. Bertino and Martino (1993), Object-Oriented Database Systems. Concepts and Architectures. Addison-Wesley.

    Google Scholar 

  5. Blaha and Premerlani (1998), Object-Oriented Modeling and Design for Database Applications. Prentice Hall.

    Google Scholar 

  6. Booch, Rumbaugh and Jacobson (1999), The Unified Modelling Language User Guide. Addison Wesley.

    Google Scholar 

  7. T. Case, B. Henderson-Sellers and G. C. Low (1996). A generic object-oriented design methodology incorporating database considerations. Annals of Software Engineering. Vol. 2, pag. 5–24.

    Article  Google Scholar 

  8. Cattell and Barry (2000), The Object Data Standard: ODMG 3.0. Morgan Kaufmann.

    Google Scholar 

  9. J. Conallen (2000), Building Web Application with UML. Addison-Wesley.

    Google Scholar 

  10. Eisenberg and Melton (1999), “SQL:1999, formerly known as SQL3”. ACM SIGMOD Record, Vol. 28, No. 1, pp. 131–138, March 1999.

    Article  Google Scholar 

  11. Informix Corporation (1999), Informix Guide to SQL: Reference. Electronic Documentation, Informix Press.

    Google Scholar 

  12. C. Kovács and P. Van Bommel (1998), “Conceptual modelling-based design of objectoriented databases”. Information and Software Technology, Vol. 40, No. 1, pp. 1–14.

    Article  Google Scholar 

  13. Leavit, N. (2000), “Whatever Happened to Object-Oriented Databases?”. Computer, pp. 16–19, August 2000.

    Google Scholar 

  14. Mattos, N. M (1999), SQL:1999, SQL/MM and SQLJ: An Overview of the SQL Standards. Tutorial, IBM Database Common Technology.

    Google Scholar 

  15. Marcos, E. and Cáceres, P. (2001), “Object Oriented Database Design”. In: Developing Quality Complex Database Systems: Practices, Techniques, and Technologies. ed. Shirley Becker. Idea Group (accepted to publish in 2001).

    Google Scholar 

  16. E. Marcos, B. Vela and J. M. Cavero (2001), A Methodology for Object-Relational Database Design Using UML (submitted to 12th International Conference and Workshop on Database and Expert Systems and Applications, DEXA 2001).

    Google Scholar 

  17. E. Marcos, B. Vela and J. M. Cavero (2001), Aggregation and Composition in Object-Relational Database Design (submitted to Fifth East European Conference on Advances in Databases and Information Systems, ABDIS’2001).

    Google Scholar 

  18. Muller (1999), Database Design for Smarties. Morgan Kaufmann.

    Google Scholar 

  19. Naiburg, E. (2000), “Database Modeling and Design Using Rational Rose 2000e”. Rose Architect Vol. 2, Issue 3, pp. 48–51.

    Google Scholar 

  20. Oracle Corporation (1998), “Objects and SQL in Oracle8”. Oracle Technical White paper. In: Extended DataBase Technology conference (EDBT’98). Valencia (Madrid).

    Google Scholar 

  21. Oracle Corporation (2000), Oracle8i. SQL Reference. Release 3 (8.1.7). In: http://www.oracle.com.

  22. Silva and Carlson (1995), “MOODD, a method for object-oriented database design.” Data & Knowledge Engineering, Vol. 17, pp.159–181.

    Article  MATH  Google Scholar 

  23. Stonebraker and Brown (1999). Object-Relational DBMSs. Traking the Next Great Wave. Morgan Kauffman.

    Google Scholar 

  24. Ullman and Widom (1997), A First Course in Database Systems. Prentice-Hall.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Kybele Research Group, Rey Juan Carlos University, Madrid, Spain

    E. Marcos, B. Vela & J. M. Cavero

Authors
  1. E. Marcos
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. B. Vela
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. J. M. Cavero
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Mathematics and Computer Science Database Systems Group, University of Bremen, P.O. Box 33 04 40, 28334, Bremen, Germany

    Martin Gogolla

  2. Telelogic Technologies, P.O. Box 23 20, Fallbrook, CA, 92088, USA

    Cris Kobryn

Rights and permissions

Reprints and permissions

Copyright information

© 2001 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Marcos, E., Vela, B., Cavero, J.M. (2001). Extending UML for Object-Relational Database Design. In: Gogolla, M., Kobryn, C. (eds) ≪UML≫ 2001 — The Unified Modeling Language. Modeling Languages, Concepts, and Tools. UML 2001. Lecture Notes in Computer Science, vol 2185. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45441-1_17

Download citation

  • DOI: https://doi.org/10.1007/3-540-45441-1_17

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-42667-7

  • Online ISBN: 978-3-540-45441-0

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation