dbTalk Databases Forums  

ER vs UML

comp.databases comp.databases


Discuss ER vs UML in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Katerina
 
Posts: n/a

Default ER vs UML - 07-21-2003 , 04:10 AM






Hallo everybody,

For my diploma I need to deal with the following questions:
I will model my software in ER and UML. ER I will use to model the
database design and UML to model the software itself.
But I would like to know why at all to model in two different
techniques. Is it not possible to model Databases as well in UML? For
sure it is possible, but why on practice ER is still used for this?
What is better with ER? What is better with relation databases?

The other question, I need to find some rules how to translate class
diagram in UML to ER or ER to UML class diagram.

I thought that somebody has made it maybe one and could help me with
useful links or books to this theme or just to tell his opinion about
it.
I would very, very much appreciate your help.

Thank you
Katerina

Reply With Quote
  #2  
Old   
Robert Klemme
 
Posts: n/a

Default Re: ER vs UML - 07-21-2003 , 07:05 AM







"Katerina" <ekaterina_zinke (AT) web (DOT) de> schrieb im Newsbeitrag
news:b101300b.0307210110.3ac243c4 (AT) posting (DOT) google.com...
Quote:
Hallo everybody,

For my diploma I need to deal with the following questions:
I will model my software in ER and UML. ER I will use to model the
database design and UML to model the software itself.
But I would like to know why at all to model in two different
techniques. Is it not possible to model Databases as well in UML? For
sure it is possible, but why on practice ER is still used for this?
What is better with ER? What is better with relation databases?
ER diagramming is focused on ER modeling and is thus likely to be better
adapted to that environment.

Quote:
The other question, I need to find some rules how to translate class
diagram in UML to ER or ER to UML class diagram.
ER table -> UML class
ER column -> UML (public) attribute

The other direction is more difficult and depends on the circumstances.
Left as an exercise, which all this is about as it seems.

robert



Reply With Quote
  #3  
Old   
Theo Peterbroers
 
Posts: n/a

Default Re: ER vs UML - 07-21-2003 , 10:10 AM



ekaterina_zinke (AT) web (DOT) de (Katerina) wrote in message news:<b101300b.0307210110.3ac243c4 (AT) posting (DOT) google.com>...
Quote:
Hallo everybody,

For my diploma I need to deal with the following questions:
I will model my software in ER and UML. ER I will use to model the
database design and UML to model the software itself.
But I would like to know why at all to model in two different
techniques. Is it not possible to model Databases as well in UML? For
sure it is possible, but why on practice ER is still used for this?
What is better with ER? What is better with relation databases?
UML models your application, ER models reality. A relational database
that contains the classes of your application will be highly application-
specific. A relational database that describes (a relevant portion of)
reality can be used by many more applications.
Quote:
The other question, I need to find some rules how to translate class
diagram in UML to ER or ER to UML class diagram.
If Class mapped to table/entity, then the columns in that table
- individual parts or aspects of your class - would be accessible
bypassing the methods that your application provides. For a relational
database, each class should be indivisible.
Quote:
I thought that somebody has made it maybe one and could help me with
useful links or books to this theme or just to tell his opinion about
it.
http://www.dcs.shef.ac.uk/vt/publica...tions_UML.html
http://www.cetus-links.org/oo_uml.html
Quote:
I would very, very much appreciate your help.

Thank you
Katerina

Reply With Quote
  #4  
Old   
Bob Badour
 
Posts: n/a

Default Re: ER vs UML - 07-21-2003 , 11:37 AM



"Katerina" <ekaterina_zinke (AT) web (DOT) de> wrote

Quote:
Hallo everybody,

For my diploma I need to deal with the following questions:
I will model my software in ER and UML. ER I will use to model the
database design and UML to model the software itself.
But I would like to know why at all to model in two different
techniques. Is it not possible to model Databases as well in UML? For
sure it is possible, but why on practice ER is still used for this?
What is better with ER? What is better with relation databases?

The other question, I need to find some rules how to translate class
diagram in UML to ER or ER to UML class diagram.

I thought that somebody has made it maybe one and could help me with
useful links or books to this theme or just to tell his opinion about
it.
I would very, very much appreciate your help.

Thank you
Katerina
While I doubt it will make much difference to your diploma, it will
certainly help your education to google for EWD696 and read what Dijkstra
wrote in anger. I suggest you follow that up by reading EWD1036.




Reply With Quote
  #5  
Old   
John Sasak
 
Posts: n/a

Default Re: ER vs UML - 07-22-2003 , 12:16 AM



Quote:
But I would like to know why at all to model in two different
techniques. Is it not possible to model Databases as well in UML? For
Yes, it is possible with object databases. You don't need ER diagram.
There should be several ODBMSs that you can model in UML.
If I recall correctly, Matisse defines database model using UML.

John


Reply With Quote
  #6  
Old   
Katerina
 
Posts: n/a

Default Re: ER vs UML - 07-23-2003 , 02:24 PM



Hello Bob, what does it exactly mean "google for EWD696" and where to
find "EWD1036"??
Sorry, I am new here.


"Bob Badour" <bbadour (AT) golden (DOT) net> wrote

Quote:
"Katerina" <ekaterina_zinke (AT) web (DOT) de> wrote in message
news:b101300b.0307210110.3ac243c4 (AT) posting (DOT) google.com...
Hallo everybody,

For my diploma I need to deal with the following questions:
I will model my software in ER and UML. ER I will use to model the
database design and UML to model the software itself.
But I would like to know why at all to model in two different
techniques. Is it not possible to model Databases as well in UML? For
sure it is possible, but why on practice ER is still used for this?
What is better with ER? What is better with relation databases?

The other question, I need to find some rules how to translate class
diagram in UML to ER or ER to UML class diagram.

I thought that somebody has made it maybe one and could help me with
useful links or books to this theme or just to tell his opinion about
it.
I would very, very much appreciate your help.

Thank you
Katerina

While I doubt it will make much difference to your diploma, it will
certainly help your education to google for EWD696 and read what Dijkstra
wrote in anger. I suggest you follow that up by reading EWD1036.

Reply With Quote
  #7  
Old   
Katerina
 
Posts: n/a

Default Re: ER vs UML - 07-23-2003 , 02:25 PM



Hallo,
thank you for the links. I will check them

peterbroers (AT) floron (DOT) leidenuniv.nl (Theo Peterbroers) wrote in message news:<39bb2c10.0307210710.4eed004b (AT) posting (DOT) google.com>...
Quote:
ekaterina_zinke (AT) web (DOT) de (Katerina) wrote in message news:<b101300b.0307210110.3ac243c4 (AT) posting (DOT) google.com>...
Hallo everybody,

For my diploma I need to deal with the following questions:
I will model my software in ER and UML. ER I will use to model the
database design and UML to model the software itself.
But I would like to know why at all to model in two different
techniques. Is it not possible to model Databases as well in UML? For
sure it is possible, but why on practice ER is still used for this?
What is better with ER? What is better with relation databases?
UML models your application, ER models reality. A relational database
that contains the classes of your application will be highly application-
specific. A relational database that describes (a relevant portion of)
reality can be used by many more applications.

The other question, I need to find some rules how to translate class
diagram in UML to ER or ER to UML class diagram.
If Class mapped to table/entity, then the columns in that table
- individual parts or aspects of your class - would be accessible
bypassing the methods that your application provides. For a relational
database, each class should be indivisible.

I thought that somebody has made it maybe one and could help me with
useful links or books to this theme or just to tell his opinion about
it.
http://www.dcs.shef.ac.uk/vt/publica...tions_UML.html
http://www.cetus-links.org/oo_uml.html

I would very, very much appreciate your help.

Thank you
Katerina

Reply With Quote
  #8  
Old   
Chad C. Mulligan
 
Posts: n/a

Default Re: ER vs UML - 07-23-2003 , 03:25 PM



Katerina,

Not to speak for Bob, but he almost certainly means you should go to www.google.com (one of the best search
engines on the web) and enter "EWD1036" in the search box, then press the "Google Search" button. I just
tried it and it works for me.

-- Chad (or today, I guess: Chad the butt-in-ski)

Katerina wrote:

Quote:
Hello Bob, what does it exactly mean "google for EWD696" and where to
find "EWD1036"??
Sorry, I am new here.

"Bob Badour" <bbadour (AT) golden (DOT) net> wrote

"Katerina" <ekaterina_zinke (AT) web (DOT) de> wrote in message
news:b101300b.0307210110.3ac243c4 (AT) posting (DOT) google.com...
Hallo everybody,

For my diploma I need to deal with the following questions:
I will model my software in ER and UML. ER I will use to model the
database design and UML to model the software itself.
But I would like to know why at all to model in two different
techniques. Is it not possible to model Databases as well in UML? For
sure it is possible, but why on practice ER is still used for this?
What is better with ER? What is better with relation databases?

The other question, I need to find some rules how to translate class
diagram in UML to ER or ER to UML class diagram.

I thought that somebody has made it maybe one and could help me with
useful links or books to this theme or just to tell his opinion about
it.
I would very, very much appreciate your help.

Thank you
Katerina

While I doubt it will make much difference to your diploma, it will
certainly help your education to google for EWD696 and read what Dijkstra
wrote in anger. I suggest you follow that up by reading EWD1036.


Reply With Quote
  #9  
Old   
Nuno Souto
 
Posts: n/a

Default Re: ER vs UML - 07-25-2003 , 01:43 AM



ekaterina_zinke (AT) web (DOT) de (Katerina) wrote in message news:<b101300b.0307210110.3ac243c4 (AT) posting (DOT) google.com>...

Quote:
Is it not possible to model Databases as well in UML? For
sure it is possible,
You just answered your question!

Quote:
but why on practice ER is still used for this?
For the same reason that on practice wheels in cars
are round: it works, it is very efficient, cheap and easy
to do. No need to re-invent a new device: wheels work.

Quote:
What is better with ER?
Nothing. It simply works.

Quote:
What is better with relation databases?
This is about as open to discussion as can get.
Suffice to say: "better" than what?

Cheers
Nuno Souto
wizofoz2k (AT) yahoo (DOT) com.au.nospam


Reply With Quote
  #10  
Old   
Anthony Youngman
 
Posts: n/a

Default Re: ER vs UML - 07-25-2003 , 04:29 AM



johnssk (AT) fishhoo (DOT) com (John Sasak) wrote in message news:<1b77ba63.0307231645.5f0e22be (AT) posting (DOT) google.com>...
Quote:
I haven't read the book, but there should be many "techniques"
to convert UML into ER or relational tables. But my point was
that with ODBMS like Matisse, you don't need any "tips" or
"techniques" for conversions. You design a UML diagram, period.
Your database schema is there.

Which at this point would be a crying shame. The OP is a student, and
has been tasked with investigating two different models.

Too many people only know one model, and use that model all the time
even when it is totally inappropriate. The more models you know, the
better you can critique how they apply to the problem in hand, and the
greater confidence you can have that you are using the correct model.

If you only know one model, how are you going to know that it is
appropriate to your problem? At least with two, you can see "here are
the good and bad points of A, here are the good and bad points of B".
More importantly, you are in a position to say "A has too many bad
points, and so does B. Surely there must be a C that's better" :-)

Cheers,
Wol


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.