A Methodological Approach for Object-Relational Database Design using UML

dc.contributor.authorMarcos, Esperanza
dc.contributor.authorVela, Belén
dc.contributor.authorCavero, José María
dc.date.accessioned2026-05-06T15:24:56Z
dc.date.issued2003-03
dc.description.abstractThe 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.
dc.identifier.citationMarcos, 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
dc.identifier.doi10.1007/s10270-002-0001-y
dc.identifier.issn1619-1366
dc.identifier.issn1619-1374 (electrónico)
dc.identifier.publicationfirstpage59
dc.identifier.publicationlastpage72
dc.identifier.publicationtitleSoftware and Systems Modeling
dc.identifier.publicationvolume2
dc.identifier.urihttps://hdl.handle.net/10115/203297
dc.language.isoen_US
dc.publisherSpringer
dc.rights.accessRightsinfo:eu-repo/semantics/closedAccess
dc.subjectUML extensions
dc.subjectStereotypes
dc.subjectObject- Relational Databases
dc.subjectDatabase Design
dc.subjectObject Persistence
dc.subjectDesign Methodology
dc.subjectUML
dc.subjectSQL:1999
dc.subjectOracle
dc.titleA Methodological Approach for Object-Relational Database Design using UML
dc.typeArticle

Files

Original bundle

Now showing 1 - 1 of 1
Loading...
Name:
s10270-002-0001-y.pdf
Size:
1.69 MB
Format:
Adobe Portable Document Format

License bundle

Now showing 1 - 1 of 1
Loading...
Name:
license.txt
Size:
2.96 KB
Format:
Item-specific license agreed upon to submission
Description: