A methodological approach for object-relational database design using UML

Abstract.The most common way of designing databases is by means of a conceptual model, such as E/R, without taking into account other views of the system. New object-oriented design languages, such as UML (Unified Modelling Language), allow the whole system, including the database schema, to be modelled in a uniform way. Moreover, as UML is an extendable language, it allows for any necessary introduction of new stereotypes for specific applications. Proposals exist to extend UML with stereotypes for database design but, unfortunately, they are focused on relational databases. However, new applications require complex objects to be represented in complex relationships, object-relational databases being more appropriate for these requirements. The framework of this paper is an Object-Relational Database Design Methodology, which defines new UML stereotypes for Object-Relational Database Design and proposes some guidelines to translate a UML conceptual schema into an object-relational schema. The guidelines are based on the SQL: 1999 object-relational model and on Oracle8i as a product example.

[1]  Elisa Bertino,et al.  Object-Oriented Database Systems: Concepts and Architectures , 1993 .

[2]  Elisa Bertino,et al.  Object-Oriented Database Systems , 1993 .

[3]  C. Robert Carlson,et al.  MOODD, a Method for Object-Oriented Database Design , 1995, Data Knowl. Eng..

[4]  Scott W. Ambler.  The Object Primer , 1995 .

[5]  Brian Henderson-Sellers,et al.  A generic object-oriented design methodology incorporating database considerations , 1996, Ann. Softw. Eng..

[6]  Jennifer Widom,et al.  A First Course in Database Systems , 1997 .

[7]  Michael R. Blaha,et al.  Object-Oriented Modeling and Design for Database Applications , 1997 .

[8]  Michael Stonebraker,et al.  Object-Relational DBMSs: Tracking the Next Great Wave , 1998 .

[9]  Jim Melton,et al.  SQL: 1999, formerly known as SQL3 , 1999, SGMD.

[10]  Stefano Paraboschi,et al.  Database Systems - Concepts, Languages and Architectures , 1999 .

[11]  Ivar Jacobson,et al.  The Unified Modeling Language User Guide , 1998, J. Database Manag..

[12]  Robert J. Muller,et al.  Database Design for Smarties , 1999 .

[13]  Neal Leavitt,et al.  Whatever Happened to Object-Oriented Databases? , 2000, Computer.

[14]  Douglas K. Barry,et al.  The Object Data Standard: ODMG 3.0 , 2000 .

[15]  Esperanza Marcos,et al.  Extending UML for Object-Relational Database Design , 2001, UML.

[16]  Robert A. Maksimchuk,et al.  UML for Database Design , 2001 .

[17]  Esperanza Marcos,et al.  Object-oriented database design , 2001 .

[18]  Esperanza Marcos,et al.  Aggregation and Composition in Object-Relational Database Design , 2001 .