Data Modeling Tool

taskhill
taskhill used Ask the Experts™
on
Greetings Experts,

We are looking at purchasing a data modeling system for our organization.  I have seen in past posts the most recommended systems are:

PowerDesigner
Oracle Designer
CA ERWIN

However, I have been able to find information from the developer's site for things such as:

Scalability
Flexibility
Maturity
User friendliness
Platform Dependency
Limitations
Who has the market share (who is the best)

Any help in answering these questions would be great.

Task
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Praveen Kumar ChandrashekatrDatabase Analysist Senior

Commented:
PowerDesigner and ER Studio are some of the more popular data modeler in the market.

aslo have a look on this article on comparions of these products and there rating.

http://www.sqlmag.com/content1/topic/data-modeling-software-comparison-review/catpath/sql-server
Oracle Database Administrator III
Commented:
IMO if you are planning to drive your business rules and application development using such as tool, remember your hidden costs:  initial training costs / travel, ongoing training (assuming normal position turnover), delays in implementing, per seat licensing, etc.  So in part your choice depends upon how many people do you need to train -- two business analysts and a DBA, or a hundred developers.  Maybe the cost-cutting is over, but as a DBA I'm not adverse to including cheaper products like MS Visio, TOAD, and SQL*Developer.

Personally, I'd favor having my employer(s) make more effort to capture the business and process flows -- the head knowledge that goes with the logical / physical models.  HTH
I completely agree with dvz's comment.
While working at one of the top transportation companies, we had Erwin to work with.
Even if it is an exceptional product, I recall we (IT Group) never used more that  5 - 10% of the functionality, in fact, for quick and dirty designs everyone used Visio.

Good luck!
:p

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial