DATABASE DESIGN WITH UML: IMPLEMENTATION ISSUES

摘要

The paper examines the benefits and drawbacks of the object-relational database technology using UML diagrams in comparison with the entity-relationship approach. Guidelines for transition to UML are presented and mapping strategy to relational and object-relational schema is overviewed. OR database extensions are outlined and two of the most popular object oriented modelling tools -Oracle Designer 6i and Rational Rose 2000 - are compared. The discussion of how well these tools are adapted to real-life situations is included, and their ability of generating DDL code for object-relational databases is studied.