Previous Topic: Overview and Installation

Next Topic: Overview


Database Design

Welcome to CA ERwin Data Modeler (CA ERwin DM), the database design tool that raises the level of data quality in transactional and data warehouse systems. It provides the tools to design and implement databases for transactional business, E-commerce, and data warehousing applications.

You can create and maintain graphical models that represent databases, data warehouses, and enterprise data models. CA ERwin DM 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.

A Windows-based graphical user interface is combined 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 leading SQL and desktop databases.

You can also use CA ERwin DM to streamline the application development process, by allowing different groups (Standards Administrators, Business Analysts, Data Modelers, and so on) to perform work independently, while collaborating and synchronizing. In this way, different groups can simultaneously work on various parts of a model or different model types.