23 Ocak 2012 Pazartesi

Veritabanı Modelleme Kaynakları

Ref: http://www.databaseanswers.org/modelling_tools.htm

PRODUCT
VENDOR
PRICE
COMMENTS

AquaData Studio ER Modeler
AquaFold $400 A Free 14-day evaluation copy can be downloaded.

The purchase price includes 12-month support. After the first year, support can purchased for 35% of the original license price.


"Discounted licences are available for qualified Academic users and Free licenses are available for qualified Open Source Software (OSS) Developers."
Altova DB Design Altova   One of a broad range of Tools.
Archimate OMG Free Trial available Archmimate is described as an Enterprise Architecture Modelling Tool, which would be great ;-).
Unfortunately, the download is for documentation and not for the product !!!
It looks like Archimate is a specification for which a number of Vendors have developed Modelling Tools.
Here's Wikipedia's entry for Archimate.
Argo UML Tigris Free - Open Source For Modelling UML Diagrams - but not for the faint-hearted.

Astah (was Jude)
Change Vision
astah* comes with three editions:
  • astah* com - Free UML modeling tool
  • astah* UML - UML and Mind Mapping integrated tool for $50
  • astah* professional - Total System Design tool (UML, ERD,DFD, Flowchart, Mind Map, CRUD and Requirement diagrams)
  • A Free Trial is available.
  • A Free Community version is available, and they publish a lot of very favourable User Comments in
    their Community Forum.
    Follow them on Twitter
    Azzurri Clay Azzuri (Japan) Free From Japan -Open Source Plug-In for Eclipe - Reverse Engineering and generates SQL.

    Pro version costs 35,000 Japanese Yen (about $150) !!

    Borland Together

    Borland
    No prices on the Website Described as "Visual Modeling for Software Architecture Design".

    The Website offers information on
    Model-Driven Development
    .

    CA Gen

    Computer Associates
    No prices on the Website Provides Model-Driven support for Agile Development.
    Has a UK Partner in Response Systems.

    Case Studio 2 Acquired by Toad (see below under Toad Data Modeler)

    CharonWare
    FreeDownload Trial, then $175(Lite) or $369(Full) Looks impressive - supports an unusally wide range of Databases, including Firebird, MaxDB,Postgres - if you try it, please me have
    your comments.

    Here's a "5-Star" Review from Dan Horn.

    CASEWise
    CASEWise   Aimed at Business Process Modelling, but has links to DataArchitect.

    ConceptDraw
    CS Odessa $179 (50% off) For ERD, UML, ORM, FlowCharts, etc. - Free Download Trial is available.
    I like the appearance of the diagrams this Product produces and this is an important consideration for me.

    DataArchitect
    Sybase $2,000 If you are buying for the company, buy this one.

    DataArchitect is part of Power Designer, which is described below.

    DataArchitect
    TheKompany $39.99 Highly recommended by Andy Brown and an unbeatable price.
    Comments and experiences please.
    Database Design Tool (DDT) Open Source  
    THANKS VERY MUCH to Josh Bosh,
    Milwaukee's most beloved Web specialist, for providing this link.




    Database Design Studio
    Chilli Source
    $39 - $200 Comes in two versions - Lite at $79 ($39 Educational),
    which supports ERD Modeling and Forward Engineering
    and Professional at $299, which adds support for Reverse Engineering.

    Database Designer
    MicroOlap $125 Specially for PostgreSQL and includes Reverse Engineering.They give it away Free if you mention it in your Blog.

    DB Constructor
    Robert Schambach Free/$150 Here's a glowing reference at the
    FreeDownloadCenter Web Site.

    DBDesigner 4
    FabForce.net
    Free
    (Donations welcome)
    Open Source and highly recommended if you work with MySQL.


    DBDesigner-Fork
    SourceForce.net
    Free A Fork of DBDesigner 4 (see above)- generates SQL scripts for Oracle, SQL Server, MySQL and FireBird.
    DB Diagram Designer PrimeLogics Offers a Free evaluation download or $130 to buy. Looks very interesting - modeller plus data editor using ODBC connections.
    If you try it please let me know your opinion.
    DB Main Rever Free for the Data Modeller, with add-ons available at typical prices of 1,000 Euros or US Dollars. Produced in Belgium, with documentation in English and French.

    Offers a very impressive range of features, including :-

    "... meta-modeling components that allow its users to develop new functions and extend its repository"
    DBSchema Concrete Software, Romania Free download and then only $45 to buy. Reverse Engineer Oracle and other Databases using JDBC connections.

    Can also generate SQL to create Databases from a Data Model.
    DBVisualiser Minq Free evaluation and then only $129 to buy,($103 for Education).
    Helpful for DBA work, like performance monitoring.

    A Finalist for 'Best Data Access Tool 2005' in the Java Developers Journal Readers Choice Award and included in the BEA WebLogic Workshop.

    Free version available with "the basic level of features that most users require".




    Nizana $149
    "Forward and Reverse Engineer, Affordable, Easy to Use."
    Dia
    Hosted by Sourceforge
    Free - Contributions suggested "Dia is software for drawing diagrams similar to Visio", such as UML.
    It's Open Source with many authors.
    Install it from here

    Druid

    From SourceForge
      Generates SQL Scripts and Java classes.

    Thanks again to Josh Bosh.

    Enterprise Architect

    Sparx Systems
    $99 UML Analysis & Design Tool and very affordable.

    Entity Framework Add-on

    IdeaBlade
    $995+/developer "Makes Microsoft's Entity Framework easier to use"

    ER Creator
    Model Creator About $100 Includes a Tutorial and a Trial version.

    ER Diagrammer

    KeepTool
    $240 Free download is available and a User Forum is supported.

    ERD Concepts 5

    ERD Concepts
    $179 Euros (single-user) A Free download is available.

    ER/Studio
    Embarcadero $1,500 up to $7,500 (!!!) In response to a helpful comment from Daryl Purcell I have added a link to

    US prices

    and

    UK prices
    .

    ERWin
    Computer Associates No price on Web Site !!! One of the Market Leaders - an enterprise solution at an enterprise price

    Experience
    Electronic Exerience Free Trial then 90 Euros (about $50)  




    Google WWW SQL Designer
    Ondrej Zara (Czechoslovakia) Free Open Source Good-looking
    sample Data Model.

    Happy Fish
    Polderij NV. (in Dutch) $89
    Renamed ERD Concepts.


    IBM InfoSphere Data Architect

    IBM
    $5,570 !!! Provides reverse and forward engineering facilities for a range of databases,
    also ERD and UML Modelling.

    ImportER MySQL
    Datanamic Excellent value at $55 Reverse Engineering for MySQL

    KeepTool
    KeepTool $300 / 300 Euros Can Reverse Engineer Oracle Databases to create Data Models - Comments and experiences welcome.
    MagicDraw No Magic   Award-winning UML Modeller and very popular with Java enthusiasts.
    Mega Database Builder Mega   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 !!!
    ModelRight ModelRight Free Trial, then $495 for DB2, Oracle and SQL Server, $295 for MySQL and PostgreSQL, and $195 for Access.
    An enthusiastic user is David McKelvey from Richardson,Texas, who says “As a pure Database Physical Modeling Tool, nothing else comes close."


    MySQL Workbench

    MySQL Free with MySQL (also Free)
    Looks good and offers Reverse Engineering.

    Objecteering
    Objecteering.com Free download trial Looks good with a comprehensive range of features, including UML support.

    OmniGraffle
    Omni Group Free download trial For Mac only

    Open ModelSphere
    Model Sphere Free Open Source and UML


    Oracle Designer

    Oracle
    $200 Available from the
    Oracle Technology Network (Free to join).

    Oracle says "Oracle Designer is our model-driven development tool based on the principles of Information Engineering."

    Oracle J-Developer

    Oracle
    Free Download UML diagramming is part of J-Developer.

    Also available from the Oracle Technology Network.

    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."


    Oracle SQL Developer Data Modeler

    Oracle
    Free Many thanks to Tuomas Kassila in Finland for telling us about this.

    Oracle says :-

    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.

    ORM Designer
    Inventic Offers a Free trial then costs $140 or 99 Euros. Thanks to Ludek Vodicka in Czechoslovakia.

    PG Designer
    From John.   Open Source - for PostgreSQL.

    Thanks again to Josh Bosh.


    Platinum Repository
    Computer Associates  
    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.

    Poseidon
    GentleWare  
    Comes highly recommended, good for UML, and has an open-source Free version.

    Power*Architect
    SQL Power Free (Open Source)  

    Power Designer
    Sybase $2,000 If you are buying for the company, buy this one.


    The Data Modelling Tool in this composite product is called "DataArchitect".

    Unfortunately, the design of the web site has changed recently and
    information about Data Architect is difficult to find.
    But the product is excellent, and I have found its powerful Reverse Engineering facilities to be very useful.
    ProVision MetaStorm Free Trial, but prices not avalable on the Website.
    Includes Frameworks, such as Zachman, and also Reference Models, such as Customers, Finance and Telecomms,
    and an interesting 3-D Architecture

    RevJ
    SourceForge Free Open Source
    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.

    Please Email me if you have any comments on RevJ.

    Rhalotel DB Diagram Mgr

    Rhalotel
    98 Euros/$100  

    RM Bench

    Byte Refinery
    Free Trial then $120 "Graphical Modelling of Relational Databases in Eclipse".

    Saphir

    Computer Associates 
    (acquired from Silwood)
    Used to be about $14,000 but check with CA Saphir is more than a Modelling Tool. It sits between an ERP like SAP and
    a Modelling Tool like ERWin.


    It provides a very useful and powerful Metadata manipulation 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.

    SilverRun ModelSphere DM Data Modeller

    Grandite
    Offered on a unique Buy or Rent Scheme ($1,500/year).

    But the Web Site says 'Please contact us for a customized quote' - which often means 'If you have to ask, you can't afford it'.
    Offers Evaluation Download

    SmartDraw
    SmartDraw $50 !!! Recommended - Promoted as a UML Drawing Tool with impressive support.

    SQL Developer Diagram Editor
      Free Not to be confused with Oracle's SQL Developer.

    Offers a range of attractive features and has some glowing references.

    SQL Maestro
    SQL Maestro Group Freeware Please let me know if you have any experience with this product.

    SQL Manager
    EMS Free Trial available  

    Squirrel
    Squirrel Free Open Source

    StarUML
    SourceForge Free "The Open Source UML/MDA Platform" (from Korea).
    System Architect 2001 Popkin $3,000-5,000 per seat. 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.
    Downloads available for Evaluation.

    Toad Data Modeler

    Quest

    Free Download, then $479
    Price is 30% off to CASE Studio 2 customers

    From the makers of Toad, 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.

    TogetherSoft Solo
    Borland Downloadable Supports UML


    Toolkit for Conceptual Modeling (TCM)
    University of Twente, Holland Free and Downloadable Very interesting combination of Tools, including UML.

    Thanks to Tony Adams for suggesting a better link here.
    Umbrello
    SourceForge Free Open Source UML Modeller
    Visio Microsoft Trial CD available Many Versions- Standard($199),Technical($399),Professional($399) and Enterprise($999)
    Visual Paradigm Visual Paradigm Free Community Edition, also Free trial. Produced by a Hong Kong-based company - supports ERDs and UML, imports Visio
    Visual Thought CERN (Godfathers of the Internet)   Give it a try for UML.

    THANKS AGAIN to Josh Bosh,
    Milwaukee's most beloved Web specialist, for providing this link.
    Win A&D Excel Software No price information on the Web Site Unusually offers products for MAC as well as Windows -
    UML Modelling as well as ERD.
    xCase Resolution Software $800 (Download Trial available)
    "xCase is a complete database design and maintenance tool including archiving and model compare and merge across
    different DBMSs".