Erwin 3.52 for Modelmart

Rating:
Summary: Database Models Easy!
Review: (ENGLISH)
With this Database Modeling Tool I could gave to my System's Area the Formality and the ability to communicate with efficency our Database Shape and details. We now have under control the database deployment and can assure the qualitiy of transactions over our database.

As a fist step ERwin let us to document our legacy database with the ERwin's tool called inverse engineering. In this manner and using a physical database model, we could have a full snapshot of our real database.

Then, using the corresponding logic database model, and using ERwin's tools like Transforms, Normalization and Subject Area Views, we realize where the troubles born. We found the desing errors that made our databse to grow too fast and some querys too slow.

Finally, we sincronize the models whith our real database using the ERwin's ability to direct communicate with the Oracle ODBMS, we made the structural database modifications in a controled way and really really fast.

In resume, ERwin it's a high productivity tool for both, database designers and database administrators.

(ESPAÑOL)
La formalidad y la capacidad de comunicación que son provistas al tener de manera formal el modelo de la base de datos de nuestra empresa nos ha permitido tener bajo control el desarrollo de la base de datos y las calidades de las transacciones sobre ella.

Primero nos permitió documentar la vieja base de datos con su herramienta de ingeniería inversa, de esta manera y a través de un modelo físico, pudimos tener una panorama general de la realidad del sistema.

Luego, usando el correspondiente modelo lógico y en conjunción con sus herramientas para hacer transformaciones de tablas, normalización de las bases de datos y las vistas por temas logramos darnos cuenta dónde surgían esos problemas que hacían crecer muy rápido la base de datos, además de poder optimizar los querys sobre ellas.

Finalmente y después de hacer una nueva sincronización de los modelos directamente con la base real de nuestro sistema y a través de su capacidad de modificar la base de datos real, pudimos llevar a cabo cambios estructurales y controlados en muy corto tiempo.

En resumen, es una herramienta que proporciona alta productividad tanto a los diseñadores como a los administradores de base de datos.

Rating:
Summary: Userful and Reliable
Review: ERwin is a great product for modeling and generating databases and DDL scripts. However, this product hasn't been significantly upgraded in years, especially since Computer Associates bought it. It does all the basics but does not allow for much in the way of optimizing the SQL that it generates, particularly for views. Fantastic for Logical Modeling, Adequate for Physical Data Modeling. Don't count on platform specific extensions (Oracle, Teradata, etc.). Don't count on them being added anytime soon either.

Rating:
Summary: Userful and Reliable
Review: In my experience, the database model almost always is a critical factor in the final ROI for a software application. Maintainable, reliable, bug free software is almost impossible without an effective and correct data model because the quality and elegance of the data model makes possible much simpler and therefore more reliable and effective application code. Erwin provides better support for creating, documenting and maintaining quality data models than any other tool I have seen. Another plus is the relatively shallow learning threshold for the tool to be used effectively. Another words, it can be immediately useful on simple projects by less experienced developers, and yet support the largest projects and most sophisticated modelling concepts when asked to do so. $$$ may seem like a lot of money, but it is expensive only if the costs of poor data modeling practices are hidden. You will pay 10 times the cost on your project for ineffective modeling, and still have a buggy, unreliable, inflexible application result even at that cost. When the true cost of amateurish data modeling practices are taken into account (managers of database hackers take note), Erwin may be the best bargain in the IT industry.

Rating:
Summary: One of the most useful "real world" modelling tools
Review: In my experience, the database model almost always is a critical factor in the final ROI for a software application. Maintainable, reliable, bug free software is almost impossible without an effective and correct data model because the quality and elegance of the data model makes possible much simpler and therefore more reliable and effective application code. Erwin provides better support for creating, documenting and maintaining quality data models than any other tool I have seen. Another plus is the relatively shallow learning threshold for the tool to be used effectively. Another words, it can be immediately useful on simple projects by less experienced developers, and yet support the largest projects and most sophisticated modelling concepts when asked to do so. $$$ may seem like a lot of money, but it is expensive only if the costs of poor data modeling practices are hidden. You will pay 10 times the cost on your project for ineffective modeling, and still have a buggy, unreliable, inflexible application result even at that cost. When the true cost of amateurish data modeling practices are taken into account (managers of database hackers take note), Erwin may be the best bargain in the IT industry.