|
View previous topic :: View next topic
|
| Author |
Message |
prav_06
Warnings : 1
Active User
Joined: 13 Dec 2005
Posts: 154
Location: The Netherlands
|
|
|
|
Hi All,
There is requirement to find the data model of all the tables in my system, is there any tool that gives the data model of the tables. Thanks in advance.
Thamilzan. |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Are you looking for entity relationship diagrams (ERD) or something else? |
|
| Back to top |
|
|
prav_06
Warnings : 1
Active User
Joined: 13 Dec 2005
Posts: 154
Location: The Netherlands
|
|
|
|
Hi Dick,
Yes am looking for the ERD diagram, parent child relationship between tables. I had gone thro fileaid for DB2 there is an option called as Relationship in the same will that be useful, if so can you please throw some light on how to use that option or is there any other tool to get the ERD diagram. Thanks for your reply.
Thamilzan. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
There are several vendors of data modeling software. Some products are:
AllFusion ERwin Data Modeler - ERD tool, ablity to generate HTML reports.
ConceptDraw - cross platform software for creating ER Diagrams
DBDesigner - OpenSource ER Data Modeler.
DB Visual ARCHITECT - Support UML Class Diagram and ERD
Dia - a free software/open source program to draw ER diagrams
Ferret (software) - a free software ER drawing tool
ER/Studio - robust, easy-to use ER modeling tool from Embarcadero.
ModelRight - inovative and complete physical modeling tool
Kivio - a free software flowcharting program that supports ER Diagrams
Microsoft Visio - The Enterprise Architect version supports generating and
reverse engineering databases
OmniGraffle - diagramming software for Mac OS
Oracle Designer - Oracle's CASE tool for designing an information system and generating it
PowerDesigner - modeling suite from Sybase which includes Data Architect for constructing or reverse engineering conceptual, logical and physical models with many of the leading RDBMS brands.
Rational Rose - Old software designed for producing UML diagrams. Notably easy to use which has aided its longevity
SILVERRUN ModelSphere - supporting conceptual, logical and physical data modeling including interfaces for multiple target systems.
SmartDraw - point and click drawing method combined with many templates creates professional diagrams.
If you search on the web, you may find some shareware/freeware that will do what you want. |
|
| Back to top |
|
|
prav_06
Warnings : 1
Active User
Joined: 13 Dec 2005
Posts: 154
Location: The Netherlands
|
|
|
|
Dick,
Thanka a lot for the reply!!!!!!!
Thamilzan. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
You're welcome  |
|
| Back to top |
|
|
|
|
