CA ERwin Data Model Validator

CA ERwin Data Model Validator verifies the structural integrity of data models or SQL/DDL code. It helps pinpoint design defects, recommends corrective actions and automatically generates scripts to implement selected corrections.

Key Features

Comprehensive Diagnostics and Reporting: CA ERwin Data Model Validator analyzes data structures, keys, indexes, columns and relationships for violations of relational database design rules. It generates graphic documentation of the entire database structure including column cross-reference and relationship listings. Comprehensive diagnostics can be customized to reflect to the requirements and priorities of your organization. Diagnostic results are conveniently ordered by category or severity level. Key diagnostic categories identified are: Missing Relationships, Disabled Triggers, Missing Indexes, Incorrectly Defined Relationships, and Inconsistent Datatype Definitions.

Design Discrepancy Isolation: CA ERwin Data Model Validator provides detailed diagnostic reports that help increase modeler and DBA productivity by accelerating the model and/or schema review process. Its innovative “Show Me” facility isolates specific design issues in complex schemas and eliminates the task of manually sifting through thousands of lines of schema code. A user-friendly display highlights the particular component of the database structure that requires modeler/DBA attention. You can also define and work with a subset of the model or schema.

"Teach Me" Facility: In addition to providing specific diagnostic messages and recommendations, CA ERwin Data Model Validator explains the theory behind the messages. This invaluable “Teach Me” facility reveals the impact of design choices or modifications in context of established and proven relational theory. By informing modelers of the impact their design decisions have on overall schema quality, CA ERwin Data Model Validator improves the skill level and quality of your database design teams.

Direct Interface to CA ERwin Data Modeler: By directly reading native data model files, CA ERwin Data Model Validator can validate the integrity and quality of data models created by modelers as well as those reverse engineered from existing databases. This ensures problem detection early in the life cycle and facilitates the development of high quality, relationally sound models constructed at significantly lower cost to the organization.

And More: Read the full Product Brief (PDF) for a more detailed list of features.

Platform Support

CA ERwin Data Model Validator is a Windows-based application that supports the following database platforms: