Re: How to get UML from database?

From: H. S. Lahman (h.lahman_at_verizon.net)
Date: 12/16/04


Date: Thu, 16 Dec 2004 16:54:48 GMT

Responding to Rizwan...

> I have a database which has tables with foreign keys and stuff. Is there any
> tool that can create UML from it? I am working on java and the UML tool I
> have is ArgoUML.

As Daniel T. indicated, a database is about data storage. That storage
paradigm is designed around access that is independent of how or why the
data is used. OTOH, an OO application is designed around solving a very
specific problem for the customer. In an OO application the solution is
tailored to the problem in hand and the solution doesn't care if the
required data is stored in an RDB, an OODB, a flat file, or the Rosetta
Stone.

When you model an RDB, you get a Data Model, not an OO model. In
particular, it is a model of the way the data is stored, which is
usually not a good model for solving the customer's problem.
[Exception: if the application is just a pipeline between the DB and the
UI for USER/CRUD processing, the models will match up fairly well. But
then you would probably be better off using a RAD IDE to build the
application rather than starting out in UML.]

Bottom line: Solve the customer's problem first by building an OO model
in UML. Then worry about how to access that solution's data needs from
the RDB (or whatever). Isolate and encapsulate the specific DB access
mechanisms in a subsystem or layer so that they are hidden from the main
application.

*************
There is nothing wrong with me that could
not be cured by a capful of Drano.

H. S. Lahman
hsl@pathfindermda.com
Pathfinder Solutions -- Put MDA to Work
http://www.pathfindermda.com
blog (under constr): http://pathfinderpeople.blogs.com/hslahman
(888)-OOA-PATH



Relevant Pages

  • Re: Please reply me!... Visio for UML Modelling examples..
    ... >i been post this question for a while, any help would be really apprecitate ... > I tried to find some examples/templates for Visual Modelling using Visio, ... > interactions and i thought vision with UML Modeling can help me out... ... It's much richer than Visio as a UML tool, ...
    (microsoft.public.visio.general)
  • Re: UML tools for .net
    ... > very difficult to find a good free UML tool for .net? ... If you use UML correctly to model your problem domain, ... misuse of UML as a low-level design tool, ...
    (microsoft.public.dotnet.framework)
  • Re: Is there a UML tool in VS.Net?
    ... Robby wrote: ... > Is there a UML tool in VS.Net? ... what version of UML is compatible with? ... > What UML software do you recommend? ...
    (microsoft.public.vsnet.enterprise.tools)
  • Re: Is there a UML tool in VS.Net?
    ... Robby wrote: ... > Is there a UML tool in VS.Net? ... what version of UML is compatible with? ... > What UML software do you recommend? ...
    (microsoft.public.vsnet.general)