Erwin

ERwin

The database design tool that raises the level of data quality in transactional and data warehouse systems. ERwin is essential in helping your organization maintain its competitive edge by providing the tools to design and implement databases for transactional business, E-commerce, and data warehousing applications. ERwin creates and maintains graphical models that represent databases, data warehouses, and enterprise data models. ERwin provides a modeling platform where corporate data requirements and related database designs can be defined, managed, and implemented across a wide variety of database platforms. ERwin combines a Windows-based graphical user interface with powerful entity relationship (ER) diagramming tools, custom editors to define physical database objects, a Model Explorer for a text-based view of model objects, and support for the leading SQL and desktop databases.

ERwin is much more than a drawing tool. ERwin not only helps you design a logical data model, which captures business rules and requirements, it supports the design of a corresponding physical data model for your target server. This enables you to forward engineer this physical data model and automatically generate physical database structures to your system catalog. ERwin supports reverse engineering of existing databases and provides both a physical and logical/physical data model so you can maintain an existing database, or migrate from your current target server to a different one. In addition, ERwin's groundbreaking Complete Compare technology automates model and database synchronization by allowing you to compare the model with the database, displaying and analyzing the differences. This enables you to selectively move the differences into the model or generate them into the database.

ERwin’s Benefits

• Easy-to-use Design Functionality: Database design is made simple through point and-click creation of a graphical entity-relationship (ER) model of your data...