File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes OO, Patterns, UML and Refactoring and the fly likes Database Modelling using UML Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » OO, Patterns, UML and Refactoring
Bookmark "Database Modelling using UML" Watch "Database Modelling using UML" New topic

Database Modelling using UML

Peter Chang

Joined: May 06, 2003
Posts: 18
Hi All,
How can a database design be modelled using UML ?
My thoughts on this :
1) Using Class Diagrams for representing Tables, views etc, and
2) Using Deployment Diagrams for representing Physical Structure
Please let me know your comments
Lasse Koskela

Joined: Jan 23, 2002
Posts: 11962
Sounds good. If you're serious about database modeling, there's a book called Agile Database Techniques from Scott Ambler, which contains a lot of useful information on how to model a database schema with UML.

Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
Ilja Preuss

Joined: Jul 11, 2001
Posts: 14112
See also

The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
Logical database design is done using class diagrams. The UML calls for using the {persistent} tag to identify the objects as logical database entries. Then design the associations for the objects. This is extremely useful because potential design flaws such as one-to-one, cyclic, and n-ary associations will become quite obvious.
Mapping your logical design to a physical design is done with standard UML component diagrams. You will want to take into account the physical distribution of your database at this point. (It may be that your logical tables will live in different databases on different servers.)

Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
Peter Chang

Joined: May 06, 2003
Posts: 18
Thanks a lot all of you for your support and pointers.
BTW, here is one more link, that might be helpful to you.
I agree. Here's the link:
subject: Database Modelling using UML
It's not a secret anymore!