CA ERwin Data Model Validator

Create accurate data models and consistent database structures

Published By:

CA

Please see below for licensing options, pricing and availability.
Shipping is free within mainland UK (next working day subject to availability).

Product Variants

New Licence

Renewal

Upgrade

Other product variants may be available, please contact us or request a call back if you cannot see what you are looking for.

Product Information

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.

Features

Comprehensive Diagnostics and Reporting: CA ERwin Data Model Validator analyses 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 customised to reflect to the requirements and priorities of your organisation. 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 organisation.