[ale] ER Diagrams

Wolf Halton wolf.halton at gmail.com
Tue Sep 6 14:44:11 EDT 2011


>From Wikipedia:
http://en.wikipedia.org/wiki/Entity-relationship_model
ER diagramming tools

There are many ER diagramming tools. Some free software ER diagramming tools
that can interpret and generate ER models and SQL and do database analysis
are MySQL Workbench (formerly
DBDesigner<http://en.wikipedia.org/wiki/DBDesigner>),
and Open ModelSphere
<http://en.wikipedia.org/wiki/Open_ModelSphere>(open-source). A
freeware ER tool that can generate database and application
layer code (webservices) is the RISE
Editor<http://en.wikipedia.org/wiki/RISE_Editor>.
The Open Source
Erviz<http://www.ab.auone-net.jp/%7Esimply/en/works/erviz/about.html>takes
a simple textual description of the ERD and then uses
Graphviz <http://en.wikipedia.org/wiki/Graphviz> to automatically produce a
layout. The web application TinyModeler <http://tinymodeler.com/> allows you
to make ER diagrams in a web browser.

Some of the proprietary ER diagramming tools are ARIS,
Avolution<http://en.wikipedia.org/wiki/Avolution>,
Aqua Data Studio<http://en.wikipedia.org/w/index.php?title=Aqua_Data_Studio&action=edit&redlink=1>,
dbForge Studio for
MySQL<http://en.wikipedia.org/wiki/DbForge_Studio_for_MySQL>,
DeZign for Databases, ER/Studio <http://en.wikipedia.org/wiki/ER/Studio>,
Devgems Data Modeler,
ERwin<http://en.wikipedia.org/wiki/CA_ERwin_Data_Modeler>,
MEGA International <http://en.wikipedia.org/wiki/MEGA_International>,
ModelRight <http://en.wikipedia.org/wiki/ModelRight>, OmniGraffle, Oracle
Designer <http://en.wikipedia.org/wiki/Oracle_Designer>, Oracle Data
Modeler<http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html>,
PowerDesigner, Rational Rose
<http://en.wikipedia.org/wiki/Rational_Rose>, Sparx
Enterprise Architect<http://en.wikipedia.org/wiki/Enterprise_Architect_Visual_Modeling_Platform>,
SQLyog <http://en.wikipedia.org/wiki/SQLyog>, System
Architect<http://en.wikipedia.org/wiki/System_Architect>,
Toad Data Modeler <http://en.wikipedia.org/wiki/Toad_Data_Modeler>, SQL
Maestro<http://en.wikipedia.org/w/index.php?title=SQL_Maestro&action=edit&redlink=1>,
Microsoft Visio, Visible
Analyst<http://en.wikipedia.org/w/index.php?title=Visible_Analyst&action=edit&redlink=1>,
and Visual Paradigm <http://en.wikipedia.org/wiki/Visual_Paradigm>.

Some free software diagram tools just draw the shapes without having any
knowledge of what they mean, nor do they generate SQL. These include
yEd<http://en.wikipedia.org/wiki/YEd>,
LucidChart <http://en.wikipedia.org/wiki/LucidChart>,
Gliffy<http://en.wikipedia.org/w/index.php?title=Gliffy&action=edit&redlink=1>
,[13] <http://en.wikipedia.org/wiki/Entity-relationship_model#cite_note-12>
Kivio <http://en.wikipedia.org/wiki/Kivio>, and
Dia<http://en.wikipedia.org/wiki/Dia_%28software%29>.
DIA diagrams, however, can be translated with tedia2sql.


On Tue, Sep 6, 2011 at 2:28 PM, Michael H. Warfield <mhw at wittsend.com>wrote:

> On Tue, 2011-09-06 at 13:57 -0400, Pete Hardie wrote:
> > Dia?
>
> That would be one possibility but I've largely given up on Dia down
> through the years just for lack of compatibility and import/export with
> other applications.  Obviously, native Visio compatibility would be
> wonderful but, what's there is, errr, primitive at best.  Dia does have
> the advantage of a nice rich shape library collection and collections
> you can add  No question there.
>
> ER Diagrams seem pretty simple, almost akin to flow charts.  Those
> things could easily be done in just about any 2D CD app like QCad or a
> raster graphics package like OpenOffice Draw.  I've had to do similar
> diagrams for presentation and opted for the later largely because they
> were going into either OO Writer or OO Presents.  I've reserved using
> QCad for doing more architectural type drawings but could easily do the
> same in there.
>
> > On Tue, Sep 6, 2011 at 13:49, David Tomaschik <david at systemoverlord.com>
> wrote:
> > > Can anyone recommend a good open source tool for drawing ER diagrams?
> > >
> > > --
> > > David Tomaschik, RHCE, LPIC-1
> > > System Administrator/Open Source Advocate
> > > OpenPGP: 0x5DEA789B
> > > http://systemoverlord.com
> > > david at systemoverlord.com
>
> > --
> > Pete Hardie
> > --------
> > Better Living Through Bitmaps
>
> Regards.
> Mike
> --
> Michael H. Warfield (AI4NB) | (770) 985-6132 |  mhw at WittsEnd.com
>   /\/\|=mhw=|\/\/          | (678) 463-0932 |
> http://www.wittsend.com/mhw/
>   NIC whois: MHW9          | An optimist believes we live in the best of
> all
>  PGP Key: 0x674627FF        | possible worlds.  A pessimist is sure of it!
>
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale
> See JOBS, ANNOUNCE and SCHOOLS lists at
> http://mail.ale.org/mailman/listinfo
>
>


-- 
This Apt Has Super Cow Powers - http://sourcefreedom.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.ale.org/pipermail/ale/attachments/20110906/fb10aaf0/attachment-0001.html 


More information about the Ale mailing list