•  How do I buy? Find out how to get new copies of ERwin 4 or to upgrade your existing ERwin licenses.

ERwin 4.0 has a host of powerful new features including:

Support for Design Layers

ERwin 4.0 supports the application development process in new ways that enable you to capture business requirements as well as the exact design of your physical database. You can now create independent logical and physical models with unique notation and display options.

You can support an application development process that requires model derivation using the ERwin 4.0 Derive New Model wizard. You can derive a logical or dimensional model from a physical model, one or more physical models from a logical model, as well as multiple data marts from a dimensional model. The source and derived models are linked for future synchronisation, and history is traced in the derived model.

A transform is a method by which you can apply a design layer decision and maintain a record of the decision for the process you are modeling. For example, you can refine the physical model to improve query performance by applying a transform to two tables and creating a single denormalized table. Nine different transform types support a wide range of features including automation, traceability and the preservation of object properties.

You can save historical information for the your model, entities, attributes, tables and columns. You can track meaningful changes to derived and transformed models, as well as routine information about the creation and revision dates of your models using the History feature.

You can use the features in the ERwin Naming Standards Editor to develop model naming standards for your organization. Use the editor to define naming standards, build a word glossary, check model names for accuracy, and name model objects in models derived from other models.