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.
This is a preview of subscription content, log in via an institution to check access.
Similar content being viewed by others
Author information
Authors and Affiliations
Additional information
Initial submission: 22 January 2002 / Revised submission: 10 June 2002 Published online: 7 January 2003
This paper is a revised and extended version of Extending UML for Object-Relational Database Design, presented in the UML’2001 conference [17].
Rights and permissions
About this article
Cite this article
Marcos, E., Vela, B. & Cavero, J. A Methodological Approach for Object-Relational Database Design using UML . SoSyM 2, 59–72 (2003). https://doi.org/10.1007/s10270-002-0001-y
Issue Date:
DOI: https://doi.org/10.1007/s10270-002-0001-y