With seven straight DBMS Readers' Choice Awards and over 50, 000 users, CA's CA Erwin ERwin Data Modeler is the industry's leading data modeling solution. It can greatly enhance the design, generation and maintenance of high-quality, high-performance databases, data warehouses and enterprise data resource models.
Design layer architecture
CA ERwin DM has the flexibility to generate data models that meet your needs. Separate logical and physical models are supported, along with the traditional, combined logical/physical model. Knowledge of the relationships and a record of design decisions are maintained, allowing you to quickly resolve the impact of changes from one design layer to the next.
Rarely does a physical database design match the original logical data design. Business constraints dictate the need to denormalize tables to meet the performance requirements of today's business applications and Service Oriented Architectures (SOAs). Transform technology facilitates the implementation of these changes while maintaining the integrity of the original design.
The definition and maintenance of standards is supported through the Domain Dictionary, Naming Standards Editor and Datatype Standards Editor. The Domain Dictionary contains reusable attributes to help ensure consistent names and definitions across the model. The Naming Standards Editor lets you create a glossary of valid words, abbreviations and naming rules that can also be reused across the model. The Datatype Standards Editor enables you to define the standards for mapping both user-defined and default data types to specific database management system data types.
Large model management
CA ERwin DM helps you manage large enterprise models through Subject Areas and Stored Displays. Subject Areas provide a focused view for individual modelers, dividing the model into smaller, manageable subsets. Stored Displays offer multiple graphical views of the model or its Subject Areas, facilitating information exchange between specialized groups of users.
This powerful feature automates complete bidirectional synchronization of models, scripts and databases. It compares one item with the other, displays the differences and permits you to select which differences are moved and in which direction. If model changes are moved to a database, CA ERwin DM can automatically generate a database alter script if desired.
Database design generation
CA ERwin DM includes optimized referential integrity trigger templates and a rich cross-database macro language, allowing you to customize triggers and stored procedures. Customizable templates facilitate the generation of a model's complete physical design and full definitions.
Data warehouse and data mart design
The performance, usability and value of a data warehouse are determined by its underlying design. CA ERwin DM supports data warehousing-specific modeling techniques (such as Star Schema and Snowflake dimensional modeling), thereby optimizing the data warehouse for your performance and analysis needs. It also captures and documents a rich set of information about the warehouse, including data sources, transformation logic and data management rules.
Reporting and printing
Visualization and publication are key to the communication and collaboration in data modeling. CA ERwin DM provides flexible, customizable reporting and printing capabilities.