Database Answers

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map


  Best Practice
  Careers
  Case Study
  Road Map
  Topics and FAQs
  Vision of the Future
  What,Why,How & When
  Your Comments


  Analysis of Data Modelling Tools
 
This page presents an anlysis using different criteria of price and features.
Here's the page on Data Modelling Tools.
All these Products offer Forward and Reverse Engineering.
Generally, the Open Source products are free and support UML, but the support assumes that you are ready and willing to do some of the 'heavy lifting'.

PRICE PRODUCT FEATURE UML OPEN SOURCE USP REVIEW
Free (Donations welcome) Argo UML   Yes Yes Recommended with MySQL  
Free Azzuri Clay   Yes Yes From Japan  
Free (Donations welcome) DBDesigner4     Yes Designed for MySQL  
Free (Donations welcome) Dia   Yes Yes    
Free Umbrello   Yes Yes   Review by A Register
 
Under $500 Case Studio 2         5 Star Review by Dan Horne
Under $500 DB Constructor         Quote for Freedownload Center
Under $500 Dezign         Quote from Barry
Under $500 ModelRight         Quote from David McKelvey
Under $500 TOAD       Also offers TOAD for Data Analysts  
 
Over $2,000 IBM's Data Architect       "Use with IBM Industry Models"  
Over $2,000 ER/Studio   Yes      
Over $2,000 ERWin          
Over $2,000 IBM's Data Architect          
Over $2,000 Sybase Data Architect          

Barry writes about Dezign ...
"Dezign is the one I have used on a regular basis for many years creating Data Models on my Web Site.

I like it because it offers forward and reverse engineering for a wide range of RDBMS's.
I also like the style of the Data Models that Dezign produces.
Dezign provides a Data Generation facility which I ahve to be very useful in the past."

Dan Horne writes about Case Studio ...
"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.
Nevertheless, I am very pleased with my purchase. 

Case Studio deserves to be much better known than it is.

Regards
Dan Horne"
David McKelvey writes about ModelRight ...
"As a pure Database Physical Modelling Tool, nothing else comes close."
© Database Answers Ltd. 2010
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map