ÿþ<html><head><script type="text/javascript" src="/_static/js/bundle-playback.js?v=1WaXNDFE" charset="utf-8"></script> <script type="text/javascript" src="/_static/js/wombat.js?v=txqj7nKC" charset="utf-8"></script> <script type="text/javascript"> __wm.init("https://web.archive.org/web"); __wm.wombat("http://www.databaseanswers.org:80/data_modellers_toolkit.htm","20200116072232","https://web.archive.org/","web","/_static/", "1579159352"); </script> <link rel="stylesheet" type="text/css" href="/_static/css/banner-styles.css?v=S1zqJCYt" /> <link rel="stylesheet" type="text/css" href="/_static/css/iconochive.css?v=qtvMKcIJ" /> <!-- End Wayback Rewrite JS Include --> <title>Data Modeller's Toolkit</title> <link rel="stylesheet" href="/web/20200116072232cs_/http://www.databaseanswers.org/styles/style.css"> </head> <body bgcolouur="#98CEFD" text="#202020"> <table width="100%"> <tr> <td align="left" valign="middle"> <img alt="Database Answers Logo" height="58" width="400" src="/web/20200116072232im_/http://www.databaseanswers.org/images/dba_400_home.jpg"> </td> <td align="right" height="95" rowspan="2" valign="top"> <a hreeeef="http://en.wikipedia.org/wiki/Lady_Gabriella_Windsor" target="_NEW"> <img align="right" alt="Lady Gabriella Windsor, a Model (Click for Wikipedia entry)" border="0" wiiiiidth="122" heiiiight="90" src="/web/20200116072232im_/http://www.databaseanswers.org/images/toolkit_sml.jpg"></a> </td> </tr> </table> <!--- START OF APRIL 1ST. MENU BAR ---> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="32" background="/web/20200116072232im_/http://www.databaseanswers.org/images/nav_bg.jpg" align="left" valign="middle"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="1%"><img src="/web/20200116072232im_/http://www.databaseanswers.org/images/spacer.gif" width="15" height="15"></td> <td width="5%" wiiiidth="6%"><a style="text-decoration:none" href="index.htm"><font color="white" face="Verdana" size="2">Home</font></td> <td align="LEFT" width="5%" wiiiidth="10%"><a style="text-decoration:none" href="about_us.htm"><font color="#FFFFFF" face="Verdana" size="2">About Us</font></a> </td> <td width="8%" wiiiidth="10%"><a style="text-decoration:none" href="pi_ask_a_question/index.asp"><font color="#FFFFFF" face="Verdana" size="2"> Ask a Question</font></a></td> <td width="7%"> <a style="text-decoration:none" href="careers.htm"><font color="#FFFFFF" face="Verdana" size="2">Careers</font></a> </td> <td width="7%"><a style="text-decoration:none" href="clients.htm"><font color="#FFFFFF" face="Verdana" size="2">Clients</font></a> </td> <td align="LEFT" width="8%" wiiiidth="18%"><a style="text-decoration:none" href="contact_us.htm"><font color="#FFFFFF" face="Verdana" size="2">Contact Us</font></a> </td> <td width="10%"><a style="text-decoration:none" href="data_models/index.htm"><font color="#FFFFFF" face="Verdana" size="2">Data Models</font></a></td> <td width="10%"><a style="text-decoration:none" href="tutorials.htm"><font color="#FFFFFF" face="Verdana" size="2">Tutorials</font></a></td> <td width="10%"><a style="text-decoration:none" href="site_map.htm"><font color="#FFFFFF" face="Verdana" size="2">Site Map</font></a></td> </tr> </table> </td> </tr> </table> <!--- END OF APRIL 1ST. MENU BAR ---> <!--- START OF PAGE NAME ---> <font color="blue" face="Verdana" size="2"> <table bgcolor="#98CEFD" border="0" cellpadding="5" cellspacing="5" width="100%"> <tr> <td height="32" background="/web/20200116072232im_/http://www.databaseanswers.org/images/nav_bg.jUg" align="left" valign="top"> <table width="10%" border="0" cellspacing="0" cellpadding="0"> <tr> <td background="/web/20200116072232im_/http://www.databaseanswers.org/images/nav_bg.jpg" valign="top" width="1%"><img src="/web/20200116072232im_/http://www.databaseanswers.org/images/spacer.gif" width="15" height="15"></td> <td align="left" background="/web/20200116072232im_/http://www.databaseanswers.org/images/nav_bg.jpg" height="32" width="10%"><pre><font color="yellow" colouuur="#FFFFFF" face="Verdana" size="2">Data Modeller's Toolkit&nbsp;&nbsp;&nbsp;</font></td> </tr> </table> </td> </tr> </table> <!--- END OF PAGE NAME ---> <table bgcolor="#98CEFD" width="100%"> <tr><td><font color="blue" face="Verdana" size="2"> <!-- begin body Text --> Here's a short list of the contents of our <a hreeeef="favourite_data_modelling_tools.htm">Data Modeller's Toolkit</a>. <hr>Industry-specific Models :- <li><a href="data_models/investment_banking/index.htm">Investment Banking</a> <li><a href="data_models/retail_data_models.htm">Retail Data Models</a> <hr> <br><br>If you have any comments or thoughts to pass on, <a hreeeef="mailto:happyfish_comments@databaseanswers.org">please let us know</a>. <!------- <BR><BR><B>Wikipedia</B> has published a <A HREF="http://en.wikipedia.org/wiki/Data_modeling_tools" TARGET=_NEW>Comparison of Data Modelling Tools</A> which is worth a look - and thanks to <B>Erick Calder</B> for telling us about it. *< > + There's a <A HREF="#SHORT_NOTE"><b>short note</b></A> about about Data Modeling and Database design at the bottom of the page. <BR><BR>if you have any specific recommendations or comments, please <A HREF='mailto:dba_requests&#64;barryw.org?subject=Comments on Modelling Tools'><B>Email me</B></A> <HR> On April 27th. 2014, I came across an interesting discussion on LinkedIn about <A HREF="http://www.linkedin.com/groupItem?view=&gid=1779772&item=5853885579736920065&type=member&commentID=-1&trk=eml-b2_anet_digest-null-5-null&fromEmail=fromEmail&ut=3UCFSHs2QmHCc1#commentID_-1" TARGET=_NEW> the future of ERwin</A> (after the takeover by <B>Embarcadero</B>). <BR><B>ERwin</B> has announced an integration with <B>Casewise</B> for enterprise architecture and business process modeling. <BR><B>PowerDesigner</B> has a more complete vision than either. <BR><BR> <CENTER><TABLE BORDER=1 CELLPADDING=5> <TR> <TD BGCOLOR=blue><CENTER><FONT COLOR=white FACE=Verdana SIZE=2><B>PRODUCT</B></TD> <TD BGCOLOR=blue><CENTER><FONT COLOR=white FACE=Verdana SIZE=2><B>VENDOR</B></TD> <TD BGCOLOR=blue><CENTER><FONT COLOR=white FACE=Verdana SIZE=2><B>PRICE</B></TD> <TD BGCOLOR=blue><CENTER><FONT COLOR=white FACE=Verdana SIZE=2><B>COMMENTS</B></TD> </TR> <TR> / -<*TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.aquafold.com/er-modeler.html" + ++--+ ARGET=_NEW> *+ AquaData Studio ER Modeler</A></TD> <-* +TD VALIGN=top><A HREF="http://www.aquafold.com/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>AquaFold</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>$400</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>A <FONT COLOR=red>Free</FONT> 14-day evaluation copy can be downloaded. <BR>The purchase price includes 12-month support. After the first year, support can purchased for 35% of the original license price. <BR>"Discounted licences are available for qualified Academic users and <FONT COLOR=red>Free</FONT> licenses are available for qualified Open Source Software (OSS) Developers." </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.altova.com/databasespy.html" TARGET=_NEW>Altova Database Spy</A></TD> <TD VALIGN=top><A HREF="http://www.altova.com/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Altova</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>$499 or $999</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>One of a broad range of Tools. Thanks to <B>Graham Lattin</B> for telling me about the change in the link. </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.archimate.org/" TARGET=_NEW>Archimate</A></TD> <TD VALIGN=top><A HREF="http://www.opengroup.org/subjectareas/enterprise/archimate" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Open Group</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red>Free</FONT> Trial available</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Archmimate is described as an Enterprise Architecture Modelling Tool, <B>which would be great ;-)</B>. Unfortunately, the download is for documentation and not for the product !!! I+t looks like Archimate is a specification for which a number of Vendors have developed Modelling Tools. Here's <A HREF="http://en.wikipedia.org/wiki/ArchiMate" TARGET=_NEW><B>Wikipedia's entry for +Archimate</B></A>. </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.argouml.org" TARGET=_NEW>Argo UML</A></TD> <TD VALIGN=top><A HREF="http://www.tigris.org" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Tigris</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red><B>Free</B></FONT> - Open Source</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>For Modelling UML Diagrams - but not for the faint-hearted. </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://astah.net/features/er-diagram" TARGET=_NEW>Astah ER Diagrams</A></TD> <TD VALIGN=top><A HREF="http://www.change-vision.com/index_en.html" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Change Vision</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://astah.change-vision.com/en/shopping/steps.html" TARGET=_NEW><B><FONT COLOR=red>Free</FONT> to Students</B></A>. An Annual licence is $119/year and a Perpetual Licence is only $199. </TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>A <B><FONT COLOR=red>Free</FONT></B> <A HREF="http://astah.net/editions/community" TARGET=_NEW>Community version</A> is available. <BR>Astah is a total System Design tool supporting UML, ERD,DFD, Flowchart, Mind Map, CRUD and Requirement diagrams) </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.azzurri.jp/en/software/clay/index.jsp" TARGET=_NEW>Azzurri Clay</A></TD> <TD VALIGN=top><A HREF="http://www.azzurri.jp/en/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Azzuri (Japan)</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red><B>Free</B></FONT></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>From <B>Japan</B> -Open Source Plug-In for Eclipe - Reverse Engineering and generates SQL. <BR>Pro version costs 35,000 Japanese Yen (about $150) !! </TD> </TR> <TR> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.borland.com/us/products/together/index.html" TARGET=_NEW>Borland Together</A></TD> <TD VALIGN=TOP><A HREF="http://www.borland.com/" TARGET=_NEW> <FONT COLOR=blue FACE=Verdana SIZE=2>Borland</A></TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2>No prices on the Website</TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2>Described as "Visual Modeling for Software Architecture Design". <BR>The Website offers information on <A HREF="http://www.borland.com/us/rc/model-driven-development/index.html" TARGET=_NEW> <FONT COLOR=red>Model-Driven Development</FONT></A>. </TD> </TR> <TR> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.ca.com/us/products/product.aspx?id=256" TARGET=_NEW>CA Gen</A></TD> <TD VALIGN=TOP><A HREF="http://www.ca.com/" TARGET=_NEW> <FONT COLOR=blue FACE=Verdana SIZE=2>Computer Associates</A></TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2>No prices on the Website</TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2>Provides Model-Driven support for <B>Agile Development</B>. Has a UK Partner in <A HREF="http://www.response-systems.com/" TARGET=_NEW>Response Systems</A>. </TD> </TR> <TR> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.casestudio.com/" TARGET=_NEW>Case Studio 2</A> Acquired by Toad (see below under Toad Data Modeler)</TD> <TD VALIGN=TOP><A HREF="http://www.charonware.com/" TARGET=_NEW> <FONT COLOR=blue FACE=Verdana SIZE=2>CharonWare</A></TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red>Free</FONT>Download Trial, then $175(Lite) or $369(Full)</TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2>Looks impressive - supports an unusally wide range of Databases, including Firebird, MaxDB,Postgres - if you try it, please me have <A HREF="mailto:comments_on_studio2@databaseanswers.org">your comments</A>. <BR>Here's <A HREF="#DAN_HORN">a "5-Star" Review from Dan Horn.</A></TD> </TR> <TR> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.casewise.com/" TARGET=_NEW>CASEWise</A></TD> <TD VALIGN=TOP><A HREF="http://www.sybase.com/home/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>CASEWise</A></TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp</TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2>Aimed at Business Process Modelling, but has links to DataArchitect.</TD> </TR> <TR> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.conceptdraw.com/en/products/cd5/applications_uml.php" TARGET=_NEW>ConceptDraw</A> </TD> <TD VALIGN=TOP><A HREF="http://www.csodessa.com/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>CS Odessa</A></TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2>$179 (50% off)</TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2>For <B>ERD, UML, ORM, FlowCharts, etc.</B> - Free Download Trial is available.</B> I like the appearance of the diagrams this Product produces and this is an important consideration for me. </TD> </TR> <TR> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.sybase.com/products/modelingdevelopment/powerdesigner">DataArchitect</A></TD> <TD VALIGN=TOP><A HREF="http://www.sybase.com/home/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Sybase</A></TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2>$2,000</TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2><B>If you are buying for the company, buy this one.</B> <FONT SIZE=2><BR>DataArchitect is part of Power Designer, which is described below.</TD> </TR> <TR> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREeeeF="http://www.thekompany.com/products/dataarchitect/index.php3" TARGET=_NEW>DataArchitect</A></TD> <TD VALIGN=TOP><A HREeeeF="http://www.thekompany.com/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>TheKompany</A></TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2>This product has disappeared - thanks to <B>Matthijs Willemstein</B> for letting me know. <BR>If you have any news or suggestions for replacements, <A HREF="mailto:dba_requests@barryw.org">please let me know</A>. </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://gnuwin.epfl.ch/apps/DDT/en/" TARGET=_NEW>Database Design Tool (DDT)</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Open Source</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> THANKS VERY MUCH to <A HREF="http://www.bosh.info" TARGET=_NEW><B>Josh Bosh</B></A>, Milwaukee's most beloved Web specialist, for providing this link. </TD> </TR> <TR> <TD VALIGN=top WIDTH=200><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.chillisource.com/dds/index.html"> Database Design Studio</A></TD> <TD VALIGN=top><A HREF="http://www.chillisource.com"><FONT COLOR=blue FACE=Verdana SIZE=2>Chilli Source</A> </TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://download.cnet.com/Database-Design-Studio-Lite/3000-10254_4-10027666.html" TARGET=_NEW>Lite</A> at $80 , <A HREF="http://download.cnet.com/Database-Design-Studio-Professional/3000-10254_4-10261065.html" TARGET=_NEW>Professional</A> at $299. and <B>maybe</B> Educational at $39. </TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://download.cnet.com/Database-Design-Studio-Lite/3000-10254_4-10027666.html" TARGET=_NEW>Lite</A> supports ERD Modeling and Forward Engineering and <A HREF="http://download.cnet.com/Database-Design-Studio-Professional/3000-10254_4-10261065.html" TARGET=_NEW>Professional</A> adds support for Reverse Engineering. </TD> </TR> <TR> <TD VALIGN=top WIDTH=200><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.microolap.com/products/database/postgresql-designer/" TARGET=_NEW>Database Designer</A> </TD> <TD VALIGN=top><A HREF="http://www.microolap.com/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>MicroOlap</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>$125</FONT></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Specially for <B>PostgreSQL</B> and includes Reverse Engineering.They give it away <B><FONT COLOR=red>Free</FONT></B> if you mention it in your Blog. </TD> </TR> <TR> <TD VALIGN=top WIDTH=200><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.dbconstructor.com/home/home.aspx" TARGET=_NEW>DB Constructor</A> </TD> <TD VALIGN=top><A HREF="http://www.dbconstructor.com/home/home.aspx" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Robert Schambach</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT SIZE=2>Free/$150</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Here's <FONT COLOR=red>a glowing reference</FONT> at the <A HREF="http://www.Freedownloadscenter.com/Information_Management/Information_Refere nce_Databases/dbConstructor___Your_Database_Tool__Review.html" TARGET=_NEW>FreeDownloadCenter Web Site</A>. </TD> </TR> <TR> <TD VALIGN=top WIDTH=200><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.fabforce.net/dbdesigner4/" TARGET=_NEW> DBDesigner 4</A></TD> <TD VALIGN=top><A HREF="http://www.fabforce.net" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>FabForce.net</A> </TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red>Free</FONT><FONT SIZE=2> <A HREF="http://www.fabforce.net/dbdesigner4/donations.php" TARGET=_NEW>(Donations welcome)</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Open Source and <B>highly recommended</B> if you work with <B>MySQL</B>. </TD> </TR> <TR> <TD VALIGN=top WIDTH=200><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://sourceforge.net/projects/dbdesigner-fork/" TARGET=_NEW> DBDesigner-Fork</A></TD> <TD VALIGN=top><A HREF="http://www.sourceforce.net" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>SourceForce.net</A> </TD> <TD VALIGN=top><FONT COLOR=red FACE=Verdana SIZE=2>Free</FONT></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>A Fork of <B>DBDesigner 4</B> (see above)- generates SQL scripts for Oracle, SQL Server, MySQL and FireBird. </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.primelogics.com/primevision.htm" TARGET=_NEW>DB Diagram Designer</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.primelogics.com/" TARGET=_NEW>PrimeLogics</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>Offers a Free evaluation download or $130 to buy.</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><B>Looks very interesting</B> - modeller plus data editor using ODBC connections. If you try it please let me know <A HREF="mailto:barryw@databaseanswers.com" TARGET=_NEW><B>your opinion</B>.</A></B></TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.dbesoftware.com/" TARGET=_NEW>DB Examiner</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.dbesoftware.com/" TARGET=_NEW>DBE Software Inc.</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red>Free Trial</FONT> but I was not able to find prices quoted on their Web Site.</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Looks interesting and offers unique facilities for validation of a Data Model. </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.db-main.eu/?q=en" TARGET=_NEW>DB Main</A> </TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.rever.eu/rever_new/en" TARGET=_NEW>Rever</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red>Free</FONT> for the Data Modeller, with add-ons available at typical prices of 1,000 Euros or US Dollars.</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Produced in Belgium, with documentation <B>in English and French</B>. <BR>Offers a very impressive range of features, including :- <BR>"... meta-modeling components that allow its users to develop new functions and <B>extend its repository</B>" </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.dbschema.com/" TARGET=_NEW>DBSchema</A> </TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.dbschema.com/" TARGET=_NEW>Concrete Software, Romania</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>Free download and then <B>only $45</B> to buy.</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><B>Reverse Engineer Oracle</B> and other Databases using JDBC connections. <BR>Can also generate SQL to create Databases from a Data Model. </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.dbvis.com/products/dbvis/" TARGET=_NEW>DBVisualiser</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.dbvis.com/" TARGET=_NEW>Minq</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Free evaluation and then <B>only $129</B> to buy,($103 for Education).</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> Helpful for <B>DBA</B> work, like performance monitoring. <BR>A Finalist for 'Best Data Access Tool 2005' in the Java Developers Journal Readers Choice Award and included in the BEA WebLogic Workshop. <BR><B><FONT COLOR=red>Free</FONT></B> version available with "the basic level of features that most users require".</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.dbwrench.com" TARGET=_NEW>DB Wrench</ </TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.nizana.com/" TARGET=_NEW>Nizana</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>$149</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> "Forward and Reverse Engineer, Affordable, Easy to Use." </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.datanamic.com/dezign/index.html" TARGET=_NEW>Dezign</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.datanamic.com" TARGET=_NEW>Datanamic</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Offers a Free download or starts at $259 to buy.</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>A recent upgrade offers significantly improved features. <BR>Supports Forward and Reverse Engineering for about 20 different Databases. <BR><B>If you are buying for yourself, buy this one</B> <HR> Here's an example of a Dezign Data Model :- <BR><IMG SRC="data_models/universal_data_model/images/data_model.gif"> </TD> </TR> <TR> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.gnome.org/projects/dia/" TARGET=_NEW>Dia</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://sourceforge.net/index.php" TARGET=_NEW> Hosted by Sourceforge</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red>Free</FONT> - Contributions suggested</TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>"Dia is software for drawing diagrams similar to Visio", such as UML. It's Open Source with many authors. <A HREF="http://dia-installer.sourceforge.net/" TARGET=_NEW>Install it from here</A> </TD> </TR> <TR> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://druid.sourceforge.net/" TARGET=_NEW> Druid</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://WWW.sourceforge.net" TARGET=_NEW> From SourceForge</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp</TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>Generates SQL Scripts and Java classes. <BR>Thanks again to <B>Josh Bosh</B>.</TD> </TR> <TR> <TD><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://sparxsystems.com.au/" TARGET=_NEW>Enterprise Architect</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://sparxsystems.com.au/" TARGET=_NEW>Sparx Systems</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.sparxsystems.com/products/ea/trial.html" TARGET=_NEW>Free Download</A> - then $135 to $239</TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>From Australia - supports <B>UML</B> and very affordable, and has an entry in <A HREF="http://en.wikipedia.org/wiki/Enterprise_Architect_(software)#Data_modeling" TARGET=_NEW><B>Wikipedia</B></A>. </TD> </TR> <TR> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.ideablade.com/products_summary.html" TARGET=_NEW"> Entity Framework Add-on</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.ideablade.com/" target=_new> IdeaBlade</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>$995+/developer</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>"Makes Microsoft's Entity Framework easier to use"</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.modelcreator.com/" TARGET=_NEW>ER Creator</A></TD> <TD><A HREeF="http://www.cai.com"><FONT COLOR=blue FACE=Verdana SIZE=2>Model Creator</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>About $100</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Includes a Tutorial and a Trial version.</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.keeptool.com/" TARGET=_NEW>ER Diagrammer</A> </TD> <TD VALIGN=top><A HREF="http://www.keeptool.com" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2> KeepTool</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>$240</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Free download is available and a User Forum is supported.</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.erdconcepts.com/" TARGET=_NEW>ERD Concepts 5</A> </TD> <TD VALIGN=top><A HREF="http://www.erdconcepts.com/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2> ERD Concepts</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>$179 Euros (single-user)</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>A Free download is available.</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.embarcadero.com/products/er-studio" TARGET=_NEW>ER/Studio</A> </TD> <TD VALIGN=top><A HREF="http://www.embarcadero.com"><FONT COLOR=blue FACE=Verdana SIZE=2>Embarcadero</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>$1,500 up to $7,500 (!!!)</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>In response to a helpful comment from <B>Daryl Purcell</B> I have added a link to <A HREF="http://shop.embarcadero.com/dr/v2/ec_Main.Entry17c?SID=39696&SP=10024&CID=0&PID=&PN=29&V1=31048725&V2=31048725&CUR=840&DSP=&PGRP=0&ABCODE=&CACHE_ID=0" TARGET=_NEW> US prices</A> and <A HREF="http://store.embarcadero.com/DRHM/store?Action=DisplayCategoryProductListPage&SiteID=borlande&Locale=en_GB&categoryID=13829500" TARGET=_NEW> UK prices</A>. </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.erwin.com/" TARGET=_NEW>ERwin</A></TD> <TD VALIGN=top><A HREF="http://www.cai.com" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>CA Technologies</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>There is <A HREF="http://erwin.com/products/detail/ca_erwin_data_modeler_community_edition/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2> a <B>Free</B> Community Edition</A>, and a price list is in <A HREF="http://shop.erwin.com/" TARGET=_NEW>the Online Store</A>. </TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>One of the Market Leaders - an enterprise solution with a particularly powerful Model Manager for large teams, especially useful when operating from different locations. <HR> Here's an example of an ERwin Data Model :- <BR><IMG SRC="data_models/canonical_data_models/images/data_model.gif"> </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.electronic-experience.net/" TARGET=_NEW>Experience</A></TD> <TD VALIGN=top><A HREF="http://www.electronic-experience.net/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Electronic Exerience</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Free Trial then 90 Euros (about $50)</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp </TD> </TR> ------> <!-------- <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.codepatterns.com/a_aboutfasttracks.htm" TARGET=_NEW>FastTracks</A></TD> <TD VALIGN=top><A HREF="http://www.codepatterns.com/index.htm" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Code Patterns</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Works only with UML and Ruby on Rails</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.genmymodel.com/" TARGET=_NEW>GenMyModel</A></TD> <TD VALIGN=top><A HREF="http://www.genmymodel.com/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>GenMyModel</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><B>Free !!!</B> A beautiful Web Site</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> "GenMyModel is an innovative online UML tool for software architects and developers. <BR>It allows to create UML-compliant diagrams, export and <B>generate code</B> from your web browser. </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.gliffy.com/products/online/" TARGET=_NEW>Gliffy</A> </TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREeeeF="http://www.gliffy.com/products/online/" TARGET=_NEW>Gliffy</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red>Free</FONT> option available</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> The <FONT COLOR=red>ONLY Online Modelling Tool</FONT> I have found - unfortunately it only does UML at the moment. </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://code.google.com/p/wwwsqldesigner/" TARGET=_NEW>Google WWW SQL Designer</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREeeeF="http://ondras.zarovi.cz/" TARGET=_NEW>Ondrej Zara (Czechoslovakia)</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red>Free</FONT> Open Source</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Good-looking <A HREF="http://ondras.zarovi.cz/sql/demo/?keyword=default" TARGET=_NEW><B>sample Data Model</A>. </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.calopus.com/calopus/gteadata.htm" TARGET=_NEW>G-TEA Data Architect</A> </TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.calopus.com" TARGET=_NEW>Calopus (UK)</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red>Free</FONT> Community version available</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <B>An interesting and (currently) a unique Cloud-based Modelling Tool</A> </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.erdconcepts.com" TARGET=_NEW>Happy Fish</A> </TD> <TD VALIGN=top><A HREF="http://www.polderij.nl" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Polderij NV.</A> (in Dutch)</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>$89</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> Renamed <A HREF="http://www.erdconcepts.com/" TARGET=_NEW>ERD Concepts</A>.</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://objectgeneration.com/eclipse/index.html" TARGET=_NEW>HiberObjects</A> </TD> <TD VALIGN=top><A HREF="http://objectgeneration.com/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Object Generation</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red>Free</FONT></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>An open source UML Tool for creating Class diagrams that supports Reverse Engineering</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www-01.ibm.com/software/data/studio/data-architect/features.html?S_CMP=wspace" TARGET=_NEW> IBM InfoSphere Data Architect</A> </TD> <TD VALIGN=top><A HREF="http://www.ibm.com" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2> IBM</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>$5,570 !!!</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Provides reverse and forward engineering facilities for a range of databases, also ERD and UML Modelling.</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.datanamic.com/importermysql/index.html" TARGET=_NEW>ImportER MySQL</A></TD> <TD VALIGN=top><A HREF="http://www.datanamic.com" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Datanamic</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>Excellent value at $55</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Reverse Engineering for MySQL</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.mid.de/en/products/innovator-for-database-architects.html" TARGET=_NEW>Innovator</A> <IMG SRC="images/new.gif"></TD> <TD VALIGN=top><A HREF="http://www.mid.de/en/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>MID</A> </TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Free trial then no price details available</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Looks good. <BR>It says it supports UML and ERD. <BR>In the web site, it says :- <BR>"With the addition of the IDEF1X-Notation also for Entity-Relationship-Models, Innovator is for the first time provided with a unified graphical presentation for both, the Entity-Relationship as well as the Data Base Diagrams." <HR> Here's an example of an Innovator Data Model :- <BR><IMG SRC="images/data_model_tool_examples/mid_innovator_feb22nd.jpg"> </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.keeptool.com/en/keeptool_diagrammer.php" TARGET=_NEW>KeepTool</A></TD> <TD VALIGN=top><A HREF="http://www.keeptool.com/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>KeepTool</A> </TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>$300 / 300 Euros</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Can Reverse Engineer Oracle Databases to create Data Models - Comments and experiences welcome.</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.magicdraw.com">MagicDraw</A></TD> <TD VALIGN=top><A HREF="http://www.magicdraw.com"><FONT COLOR=blue FACE=Verdana SIZE=2>No Magic</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Award-winning <B>UML Modeller</B> and very popular with Java enthusiasts.</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.mega.com/_product/usisoa.htm" TARGET=_NEW>Mega Database Builder</A></TD> <TD VALIGN=top><A HREF="http://www.mega.com/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Mega</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Looks like a great product with a wide range of features BUT there is no price information on their Site and they offer an evaluation version but you can't download it - instead they will contact you to discuss your requirements !!! </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.modelright.com" TARGET=_NEW>ModelRight</A></TD> <TD VALIGN=top><A HREF="http://www.modelright.com" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>ModelRight</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Free Trial, then $495 for DB2, Oracle and SQL Server, $295 for MySQL and PostgreSQL, and $195 for Access.</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> An enthusiastic user is David McKelvey from Richardson,Texas, who says  As a pure Database Physical Modeling Tool, nothing else comes close."</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://mysql.com/products/workbench/" TARGET=_NEW> <IMG SRC="images/mysql_logo_sml.gif">MySQL Workbench</A> </TD> <TD VALIGN=top><A HREF="http://mysql.com" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>MySQL</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red>Free</FONT> with MySQL (also Free)</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> Looks good and offers Reverse Engineering.</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.navicat.com/en/products/navicat_datamodeler/modeler_overview.html" TARGET=_NEW>Navicat Data Modeler</A> </TD> <TD VALIGN=top><A HREF="http://www.navicat.com/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Navicat</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=blue FACE=Verdana SIZE=2>Starts at $79 for a non-commercial version</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Looks good with a comprehensive range of versions.</FONT></TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.objecteering.com/" TARGET=_NEW>Objecteering</A> </TD> <TD VALIGN=top><A HREF="http://www.objecteering.com/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Objecteering.com</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red FACE=Verdana SIZE=2>Free</FONT> download trial</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Looks good with a comprehensive range of features, including UML support.</FONT></TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.omnigroup.com/products/omnigraffle/" TARGET=_NEW>OmniGraffle</A> </TD> <TD VALIGN=top><A HREF="http://www.omnigroup.com/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Omni Group</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red FACE=Verdana SIZE=2>Free</FONT> download trial</TD> <TD VALIGN=top><FONT COLOR=red FACE=Verdana SIZE=2>For Mac only</FONT></TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.modelsphere.org/" TARGET=_NEW>Open ModelSphere</A> </TD> <TD VALIGN=top><A HREF="http://www.omnigroup.com/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Model Sphere</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red FACE=Verdana SIZE=2>Free</FONT> </TD> <TD VALIGN=top><FONT COLOR=red FACE=Verdana SIZE=2>Open Source and UML</FONT></TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://otn.oracle.com/products/designer/index.html" TARGET=_NEW> Oracle Designer</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.oracle.com" TARGET=_NEW> Oracle</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>$200</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Available from the <A HREF="http://technet.oracle.com" TARGET=_NEW>Oracle Technology Network</A> (Free to join).</B> <BR>Oracle says "Oracle Designer is our model-driven development tool based on the principles of Information Engineering."</TD> </TR> <TR> <TD VALIGN=top><A HREF="http://otn.oracle.com/products/jdev/index.html" TARGET=_NEW> <FONT COLOR=blue FACE=Verdana SIZE=2>Oracle J-Developer</A></TD> <TD VALIGN=top><A HREF="http://otn.oracle.com/" TARGET=_NEW> <FONT COLOR=blue FACE=Verdana SIZE=2>Oracle</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Free Download</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><B>UML</B> diagramming is part of J-Developer. <BR><FONT SIZE=2>Also available from the <A HREF="http://technet.oracle.com" TARGET=_NEW>Oracle Technology Network</A>. <BR>Oracle says "Oracle JDeveloper is an integrated development environment with end-to-end support for modeling, developing, debugging, optimizing, and deploying Java applications and Web services." </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html" TARGET=_NEW> Oracle SQL Developer Data Modeler</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.oracle.com" TARGET=_NEW> Oracle</A></TD> <TD VALIGN=top><FONT COLOR=red FACE=Verdana SIZE=2>Free</FONT></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Many thanks to <B>Tuomas Kassila in Finland</B> for telling us about this. <BR>Oracle says :- <BR>SQL Developer Data Modeler is a Free data modeling and design tool, for ERD and Multi-dimensional modeling, with forward and reverse engineering. It imports from and exports to a variety of sources and targets. <HR>In a discussion on LInkdedIn, <A HREF="http://www.linkedin.com/profile/view?id=1823988&authType=name&authToken=h1Bz&trk=miniprofile-primary-view-button" TARGET=_NEW><B>Kent Graziano</B></A> said :- <BR> Oracle SQL Developer Data Modeler has a Logical Modeling diagrammer that gives you the option of three different notations and the ability to turn various display options on and off. <BR>You also have an option to use box-in-box for sub types (if you like that style), so it is very usable. </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.orm-designer.com/" TARGET=_NEW>ORM Designer</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.inventic.cz/" TARGET=_NEW>Inventic</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>Offers a Free trial then costs $140 or 99 Euros.</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Thanks to <B>Ludek Vodicka</B> in Czechoslovakia.</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.hardgeus.com/projects/pgdesigner/" TARGET=_NEW>PG Designer</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>From John.</TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Open Source - for PostgreSQL. <BR>Thanks again to <B>Josh Bosh</B>.</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.cai.com/products/decisionbase/repository.htm" TARGET=_NEW> Platinum Repository</A></TD> <TD><A HREF="http://www.cai.com" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Computer Associates</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> This is a Repository, rather than a Modelling Tool, with a 'Where-used' facility, and it lets you add entity types,such as Business Function, Business Role and Script. </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.gentleware.com/" TARGET=_NEW>Poseidon</A></TD> <TD><A HREF="http://www.gentleware.com" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>GentleWare</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> Comes highly recommended, good for <B>UML</B>, and has an open-source <FONT COLOR=red>Free</FONT> version. </TD> </TR> <A NAME="POWER_DESIGNER"></A> <TR> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.sybase.com/products/designtools/powerdesigner/" TARGET=_NEW>Power Designer</A></TD> <TD VALIGN=TOP><A HREF="http://www.sybase.com/home/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>Sybase</A></TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2>$2,000</TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2>If you are buying for the company, consider this one. </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=red FACE=Verdana SIZE=2><A HREF="http://www.metastorm.com/products/provision_ea.asp" TARGET=_NEW>ProVision</A> now renamed to <A HREF="http://www.bps.opentext.com" TARGET=_NEW>OpenText</A></TD> <TD VALIGN=top><A HREF="http://www.metastorm.com" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>MetaStorm</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Free Trial, but prices not avalable on the Website.</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> Includes Frameworks, such as Zachman, and also Reference Models, such as Customers, Finance and Telecomms, and an interesting <A HREF="images/MetaStorm_ProVision_lge.jpg" TARGET=_NEW><IMG BORDER=0 SRC="images/MetaStorm_ProVision_xsml.jpg"><B>3-D Architecture</B></A> </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://revj.sourceforge.net/" TARGET=_NEW>RevJ</A></TD> <TD><A HREF="http://revj.sourceforge.net/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>SourceForge</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red><B>Free</B></FONT> Open Source</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> This Object Source product generates ERD Data Models from SQL. It is a way of understanding complex SQL that you might have 'inherited' from somebody else. <BR>Please <A HREF='mailto:dba_requests&#64;barryw.org?subject=Comments on RevJ'>Email me</A> if you have any comments on <B>RevJ</B>. </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.rhalotel.com/web-database-diagram-manager-demo.html" TARGET=_NEW>Rhalotel DB Diagram Mgr</A></TD> <TD VALIGN=top><A HREF="http://www.rhalotel.com/" TARGET=_NEW> <PRE><FONT COLOR=blue FACE=Verdana SIZE=2>Rhalotel</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>98 Euros/$100</TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.byterefinery.com/produkte" TARGET=_NEW>RM Bench</A></TD> <TD VALIGN=top><A HREF="http://www.byterefinery.com/" TARGET=_NEW> <PRE><FONT COLOR=blue FACE=Verdana SIZE=2>Byte Refinery</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Free Trial then $120</TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>"Graphical Modelling of Relational Databases in Eclipse".</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://erwin.com/products/ca-erwin-safyr-option-for-erp" TARGET=_NEW>Safyr</A> </TD> <TD VALIGN=top><A HREF="http://www.ca.com/" TARGET=_NEW> <PRE><FONT COLOR=blue FACE=Verdana SIZE=2>Computer Associates</A> <BR>(acquired from Silwood)</PRE></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Used to be about $14,000 but check with CA</TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>Safyr is <B>more than a Modelling Tool</B>. It sits between an ERP like SAP and a Modelling Tool like ERWin. <BR> It provides a very useful and powerful <B>Metadata manipulation</B> package which allows you to extract metadata from ERPs such as SAP, J.D. Edwards and PeopleSoft, which can then be 'reverse engineered' into a Modelling Tool like ERwin, to see the Data Model.</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://schemaspy.sourceforge.net/" TARGET=_NEW>Schema Spy</A> (command line) or <A HREF="http://www.joachim-uhl.de/projekte/schemaspygui/" TARGET=_NEW>Schema Spy GUI (Point and click) </TD> <TD VALIGN=top><A HREeeeF="http://www.silverrun.com/index.html" TARGET=_NEW> <PRE><FONT COLOR=blue FACE=Verdana SIZE=2>Schema Spy</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Free</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>May not exactly be a Data Modelling Tool. <BR>On the Web Site, it is described as a "Graphical Database Schema Metadata Browser" and a tool to investigate the validity of a Data Model. <BR><BR>The Web Site also says :- <BR>"Do you hate starting on a new project and having to try to figure out someone else's idea of a database? <BR>Or are you in QA and the developers expect you to understand all the relationships in their schema? <BR>If so then this tool's for you. <BR><BR>A Contributor to the LinekdIn Data Architecture Group said :- <BR>"Schemaspy would be nice for Reverse Engineering as it outputs in HTML and you can zip the file and send it around to people. <BR<A contributgion on the LInkedIn Data Architecure Group said :- <BR>"I have used to to view what is inside a schema, quickly. <BR>It helps you to quickly generate the data model and visualize entities as per 'Degree of Separation' , too. <BR>Very flexible, and quick, it is just a 'jar' file to which you pass your database credentials and it does the job. </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.silverrun.com/modelsphere_dm.html" TARGET=_NEW>SilverRun Data Modeller</A> (now Open ModelSphere) </TD> <TD VALIGN=top><A HREF="http://www.silverrun.com/index.html" TARGET=_NEW> <PRE><FONT COLOR=blue FACE=Verdana SIZE=2>Grandite</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>$990 </TR> <TR> <TD><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.smartdraw.com/resources/examples/software/erd.htm" TARGET=_NEW>SmartDraw</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.smartdraw.com" TARGET=_NEW>SmartDraw</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>$50 !!!</TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><B>Recommended</B> - Promoted as a UML Drawing Tool with impressive support.</TD> </TR> <TR> <TD><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://sparxsystems.com.au/" TARGET=_NEW>Sparx Enterprise Architect</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://sparxsystems.com.au/" TARGET=_NEW>Sparx Systems</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.sparxsystems.com/products/ea/trial.html" TARGET=_NEW>Free Download</A> - then $135 to $239</TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>From Australia - supports <B>UML</B> and very affordable, and has an entry in <A HREF="http://en.wikipedia.org/wiki/Enterprise_Architect_(software)#Data_modeling" TARGET=_NEW><B>Wikipedia</B></A>. </TD> </TR> <TR> <TD><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www-01.ibm.com/software/analytics/spss/products/modeler/" TARGET=_NEW>SPSS Clemetine</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.ibm.com" TARGET=_NEW>IBM</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><B>IBM recommends this for Data Mining.</TD> </TR> <TR> <TD><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://sqldeveloper.solyp.com/screenshots/diagram-editor/index.html" TARGET=_NEW>SQL Developer Diagram Editor</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp;</TD> <TD><FONT COLOR=red FACE=Verdana SIZE=2><B>Free</B></FONT></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>Not to be confused with Oracle's SQL Developer. <BR>Offers a range of attractive features and has some <A HREF="http://sqldeveloper.solyp.com/reviews/index.html" TARGET=_NEW>glowing references</A>. </TD> </TR> <TR> <TD><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.sqlmaestro.com/" TARGET=_NEW>SQL Maestro</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREeeF="http://sourceforge.net/index.php" TARGET=_NEW>SQL Maestro Group</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><B><FONT COLOR=red>Free</FONT>ware</B></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><B>Please let me know if you have any experience with this product.</TD> </TR> <TR> <TD><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.sqlmanager.net/" TARGET=_NEW>SQL Manager</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREeeF="http://sourceforge.net/index.php" TARGET=_NEW>EMS</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><B>Free Trial available</B></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><B>&nbsp</TD> </TR> <TR> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.sqlpower.ca/page/architect" TARGET=_NEW>SQL Power Architect</A></TD> <TD VALIGN=TOP><A HREF="http://wwww.sqlpower.ca/" TARGET=_NEW><FONT COLOR=blue FACE=Verdana SIZE=2>SQL Power</A></TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red>Free</FONT> (Open Source)</TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2> Here's an example of an SQL Power Data Model :- <BR><IMG SRC="images/data_model_tool_examples/sqlpower_model_sml_feb22nd.jpg"> </TD> </TR> <TR> <TD><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://squirrel-sql.sourceforge.net/" TARGET=_NEW>Squirrel</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREeeF="http://sourceforge.net/index.php" TARGET=_NEW>Squirrel</A></TD> <TD><FONT COLOR=red FACE=Verdana SIZE=2><B>Free</B></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>Open Source</TD> </TR> <TR> <TD><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://staruml.sourceforge.net/" TARGET=_NEW>StarUML</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://sourceforge.net/index.php" TARGET=_NEW>SourceForge</A></TD> <TD><FONT COLOR=red FACE=Verdana SIZE=2><B>Free</B></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><B>"The Open Source UML/MDA Platform" (from Korea).</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www-01.ibm.com/software/awdtools/systemarchitect/">System Architect</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.ibm.com">IBM</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>$3,000-5,000 per seat.</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>In an evaluation, I found this product very difficult to use, the diagrams were very ugly and it crashed too often for me to recommend it. <A HREF="http://www.popkin.com/services/downloads/downloads.htm" TARGET=_NEW>Downloads available for Evaluation.</TD> </TR> <TR> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.quest.com/toad_data_modeler" TARGET=_NEW>Toad Data Modeler</A> </TD> <TD VALIGN=TOP><A HREF="http://www.quest.com/" TARGET=_NEW> <FONT COLOR=blue FACE=Verdana SIZE=2>Quest</A></TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.toadsoft.com/toaddm/toad_data_modeler.htm" TARGET=_NEW>Free Download</A>, then $479</TD> <TD VALIGN=TOP><FONT COLOR=blue FACE=Verdana SIZE=2><B>Price is 30% off</B> to CASE Studio 2 customers <BR>From the makers of <B>Toad</B>, and based on CASE Studio 2  Includes 24x7 support, runs on over 40 DBMSs, and you can create ER & Data Flow diagrams, reverse engineer and generate SQL Scripts.</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=1><A HREF="http://www.borland.com/together/solo/index.html" TARGET=_NEW> TogetherSoft Solo</A> </TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.borland.com" TARGET=_NEW>Borland</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Downloadable</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Supports <B>UML</B></TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=1> <A HREF="http://wwwhome.cs.utwente.nl/~tcm/" TARGET=_NEW> Toolkit for Conceptual Modeling (TCM)</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://wwwhome.cs.utwente.nl" TARGET=_NEW>University of Twente, Holland</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red>Free</FONT> and Downloadable</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Very interesting combination of Tools, including <B>UML</B>. <BR>Thanks to <B>Tony Adams</B> for suggesting a better link here. </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://uml.sourceforge.net/index.php" TARGET=_NEW>Umbrello</A> </TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://sourceforge.net/" TARGET=_NEW>SourceForge</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><FONT COLOR=red>Free</FONT> Open Source</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>UML Modeller</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.microsoft.com/office/visio/" TARGET=_NEW>Visio</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.microsoft.com" TARGET=_NEW>Microsoft</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Trial CD available</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=1>Many Versions- Standard($199),Technical($399),Professional($399) and Enterprise($999)</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.visual-paradigm.com" TARGET=_NEW>Visual Paradigm</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.visual-paradigm.com" TARGET=_NEW>Visual Paradigm</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Free Community Edition, also Free trial.</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Produced by a Hong Kong-based company - supports ERDs and UML, imports Visio</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.vertabelo.com" TARGET=_NEW>Vertabelo</A> </TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.Vertabelo.com" TARGET=_NEW>Vertabelo</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Free trial and then $12 or $48/month - $99 or $399.</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>"Design your database <FONT COLOR=red>Online</FONT>"</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://product-support.web.cern.ch/product-support/sdt/visualthought.html" TARGET=_NEW>Visual Thought</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.cern.ch" TARGET=_NEW>CERN</A> (Godfathers of the Internet)</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>&nbsp</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>Give it a try for <B>UML</B>. <BR>THANKS AGAIN to <A HREF="http://www.bosh.info" TARGET=_NEW><B>Josh Bosh</B></A>, Milwaukee's most beloved Web specialist, for providing this link.</TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.excelsoftware.com/wina&dproducts.html" TARGET=_NEW>Win A&D</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.excelsoftware.com/" TARGET=_NEW>Excel Software</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>No price information on the Web Site</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><B>Unusually offers products for MAC</B> as well as Windows - <A HREF="http://www.excelsoftware.com/uml_topic.html" TARGET=_NEW><B>UML</B> Modelling</A> as well as ERD. </TD> </TR> <TR> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.xcase.com/" TARGET=_NEW>xCase</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.xcase.com/" TARGET=_NEW>Resolution Software</A></TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2>$800 (Download Trial available)</TD> <TD VALIGN=top><FONT COLOR=blue FACE=Verdana SIZE=2> "xCase is a complete database design and maintenance tool including archiving and model compare and merge across different DBMSs". </TD> </TR> </TABLE> </CENTER> <HR><A HREF="http://en.wikipedia.org/wiki/Lady_Gabriella_Windsor" TARGET=_NEW> <IMG ALIGN=left ALT="Lady Gabriella Windsor, a Model (Click for Wikipedia entry)" BORDER=1 WIDTH=130 HEIGHT=187 SRC="images/gabriella_w_3.jpg"> </A> <CENTER> <B>Useful Links :-</B> <BR> <TABLE BORDER=1 CELLPADDING=5> <TR> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><B>CATEGORY</B></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><B>ORGANISATION</B></TD> <TD><CENTER><FONT COLOR=blue FACE=Verdana SIZE=2><B>COMMENTS</B></TD> </TR> <TR> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>Discussion Group</TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.infoadvisors.com/datamodellist.htm">InfoAdvisors</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>Data Model Group</TD> </TR> <TR> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>Portal</TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.infogoal.com/dmc/dmchome.htm">Data Management Centre</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2> <A HREF="http://www.infogoal.com/dmc/dmcdmd.htm">Directory of Data Modelling Resources (Highly Recommended)</A></TD> </TR> <TR> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>Portal</TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.dmreview.com">DM Review</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>Search for 'Data Models'</TD> </TR> <TR> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>Portal</TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2><A HREF="http://www.inconcept.com/JCM/">Journal of Conceptual Modelling</A></TD> <TD><FONT COLOR=blue FACE=Verdana SIZE=2>Worth Checking out</TD> </TR> </TABLE> </CENTER> <A NAME="SHORT_NOTE"></A> <P><P><P><P><P><FONT COLOR=blue FACE=Verdana SIZE=2> <HR> <B>A short note about about Data Modelling and Database Design ...</B> <PRE><FONT COLOR=blue FACE=Verdana SIZE=2>Data modelling and database design are two very different activities. For data modelling, the question you are asking is : 1) What does the world being modelled look like ? In particular, you are looking for similarities between things. Then you identify a 'super-type' of thing which may have sub-types. For example, Corporate Customers and Personal Customers If, for example, supplier contacts are conceptually different things from customer contacts, then the answer is that they should be modelled separately. On the other hand, if they are merely sub-sets of the same thing, then treat them as the same thing. 2) For database design, you are answering a different question:- "How can I efficiently design a database that will support the functions of the proposed application or Web Site ?" The key task here is to identify similarities between entities so that you can integrate them into the same table, usually with a 'Type' indicator. For example, a Customer table, which combines all attributes of both Corporate and Personal Customers. As a result, it is possible to spend a great deal of time breaking things out when creating a Data Model, and then collapsing them back together when designing the corresponding database. </PRE> <A NAME="DAN_HORN"></A> <PRE><FONT COLOR=blue FACE="Verdana" SIZE=2> <B><I>Dan Horne writes about Case ...</I></B> "I have found Case Studio to be an outstanding tool in its market niche. It supports a wide variety of databases, although I've only use it with Oracle, where I have found it to be excellent. It's a bargain at $299, and with additional licenses costing only $89, it is well within the budget of most organizations that do not require an enterprise solution. I've been searching for a data modelling tool for some time, but most are not within my price range, and are generally aimed at larger companies. The competitive products I have found are marginally cheaper, but do not support the fundamental features I need such as the reverse engineering of existing databases. The only weakness is the documentation, which is included as a help file. Some topics such as exporting the diagrams to a graphic file are not covered, and there is no detail on writing templates to enhance and extend the system. Likewise, Data Flow Diagrams are barely touched on. <B>Nevertheless, I am very pleased with my purchase. Case Studio deserves to be much better known than it is.</B> Regards Dan Horne" </PRE> Copyright Notice --> <br><center><font size="1"><i> &#169; DatabaseAnswers.org 2015</i></font></center></br> <!--- START OF APRIL 1ST. MENU BAR ---> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="32" background="/web/20200116072232im_/http://www.databaseanswers.org/images/nav_bg.jpg" align="left" valign="middle"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="1%"><img src="/web/20200116072232im_/http://www.databaseanswers.org/images/spacer.gif" width="15" height="15"></td> <td width="5%" wiiiidth="6%"><a style="text-decoration:none" href="index.htm"><font color="white" face="Verdana" size="2">Home</font></td> <td align="LEFT" width="5%" wiiiidth="10%"><a style="text-decoration:none" href="about_us.htm"><font color="#FFFFFF" face="Verdana" size="2">About Us</font></a> </td> <td width="8%" wiiiidth="10%"><a style="text-decoration:none" href="pi_ask_a_question/index.asp"><font color="#FFFFFF" face="Verdana" size="2"> Ask a Question</font></a></td> <td width="7%"> <a style="text-decoration:none" href="careers.htm"><font color="#FFFFFF" face="Verdana" size="2">Careers</font></a> </td> <td width="7%"><a style="text-decoration:none" href="clients.htm"><font color="#FFFFFF" face="Verdana" size="2">Clients</font></a> </td> <td align="LEFT" width="8%" wiiiidth="18%"><a style="text-decoration:none" href="contact_us.htm"><font color="#FFFFFF" face="Verdana" size="2">Contact Us</font></a> </td> <td width="10%"><a style="text-decoration:none" href="data_models/index.htm"><font color="#FFFFFF" face="Verdana" size="2">Data Models</font></a></td> <td width="10%"><a style="text-decoration:none" href="tutorials.htm"><font color="#FFFFFF" face="Verdana" size="2">Tutorials</font></a></td> <td width="10%"><a style="text-decoration:none" href="site_map.htm"><font color="#FFFFFF" face="Verdana" size="2">Site Map</font></a></td> </tr> </table> </td> </tr> </table> <!--- END OF APRIL 1ST. MENU BAR ---> </td></tr> </table> </body> </html> <!-- FILE ARCHIVED ON 07:22:32 Jan 16, 2020 AND RETRIEVED FROM THE INTERNET ARCHIVE ON 17:18:41 Jun 27, 2023. JAVASCRIPT APPENDED BY WAYBACK MACHINE, COPYRIGHT INTERNET ARCHIVE. ALL OTHER CONTENT MAY ALSO BE PROTECTED BY COPYRIGHT (17 U.S.C. SECTION 108(a)(3)). --> <!-- playback timings (ms): captures_list: 61.322 exclusion.robots: 0.071 exclusion.robots.policy: 0.06 cdx.remote: 0.062 esindex: 0.008 LoadShardBlock: 32.606 (3) PetaboxLoader3.datanode: 45.019 (4) load_resource: 76.448 PetaboxLoader3.resolve: 41.947 -->