An important part of developing database models is to understand
what it is that you want to accomplish. In general one can look at
data modeling, database design and the database as itegrated with
other uml models. Each one will have a different way to be modeled.
In database modeling, tables are not used, for example. In database
design we need tables but partitioning may or may not be used. In
integrating with other models tables and indexes are far too grainy
and it is enough to recognize just the databases. In database
design <<FK>> could be a stereotype for an attribute of a class, in
data modeling it could a stereotype for the class itself (typical ER
modeling) or it could be attached to a dependency line.
There are two other references that I like as well. "UML for
Database Design" by Eric Naiburg Addison-Wesley has some interesting
ideas and "Designing Data-Intensive Web Applications" by Ceri et al.
from Morgan Kaufman has some ideas and if I am correct still has
something downloadable approximating a profile.
Hope this helps.
--- In agileDatabases@yahoogroups.com
, "Scott W. Ambler"
> The closest you're going to find is at
> There's a move afoot by a few people to use that as a basis for an
> spec, but frankly it'll be another year or two at least at the
> earliest before a real standard comes about due to the OMG
> - Scott
> At 08:04 PM 4/24/2004, you wrote:
> >I came to this group via tha 2002 agile essay on a UML profile
> >modeling. I'm starting to understand enough about UML to become
> >dangerous. I'd like to create some UML data models as input to a
> >generator. So the models need to get specify the nitty-gritty
> >of such things as relations, indexes, RI etc.
> >I don't suppose there are any real standards for UML RDB modeling
> >Searching the web yields a plethora of possibilities, books and
> >projects but I'd really like to pick one that has some
> >staying around. Are any of the several books on the subject
> >enough to be usable in a real development enviroment?
> >Yahoo! Groups Links
> Scott W. Ambler
> Senior Consultant, Ronin International, Inc.