ERwin Examiner is a database validation tool

ERwin Examiner

Managing Data Quality

ERwin Examiner is a database validation tool that raises the level of data quality in transactional and data warehouse systems by systematically scanning ERwin models or thousands of lines of SQL/DDL code to identify design inconsistencies. ERwin Examiner helps you address a number of critical IT management issues, including the need to rapidly design and deploy database systems with limited skilled personnel, integrate and maintain database systems with ease over their lifetime, and maintain the highest levels of data integrity across database systems.

ERwin Examiner significantly improves the consistency and quality of data across your entire enterprise information architecture. Its comprehensive set of diagnostic tools validates the structural integrity of ERwin data models by applying Relational Modeling Rules. ERwin Examiner pinpoints design discrepancies, recommends precise improvements, and automatically generates database scripts to implement the revisions.

eBusiness Requires A Solid Database Foundation

Staying ahead of the competition in today�s eBusiness economy requires faster, better decisions based on accurate data. Organizations must effectively leverage this data in order to identify market trends, predict customer demands and track business performance metrics. In addition, vast amounts of data must be compiled from new sources, such as customer information submitted on a website, new partner information, and online transactions. Often, the structure of this information must be revised to conform to the existing database design. Integrating and standardizing data from these diverse sources can be a very time-consuming task. Yet in order to establish a competitive advantage in the fast-paced world of eBusiness, organizations must create an accurate consolidated view of their business, partners, and customers. This increased need for accessible, dependable data has caused a skyrocketing demand for data warehouses that meet immediate eBusiness requirements.

A solid database foundation is essential to building high-performance eBusiness applications and effective data warehouses that allow businesses to leverage their most valuable resource -- information. Ultimately, the value of a data warehouse is determined by the integrity of the underlying data.

Superior Database Design Benefits Your eBusiness

ERwin the industry-leading data modeling solution, enables organizations to visualize complex business logic, inventory information assets, and establish data standards. It intelligently automates the design process through an intuitive user interface. ERwin Examiner provides extensive analytical tools to further enhance the superior modeling capabilities of ERwin.

ERwin Examiner accelerates database design and deployment by improving the consistency and quality of data sources enterprise-wide. It analyzes your ERwin data models to identify inconsistencies that adversely affect database integrity and efficiency. By providing a comprehensive set of diagnostics, ERwin Examiner validates your database design, recommends improvements and automatically generates alter scripts to quickly execute design changes. Detailed diagnostic reports illustrate structural inconsistencies in a conveniently organized format. ERwin Examiner fine tunes your database design to ensure a solid foundation for your eBusiness applications and data warehouse implementations.

Maximize Design Efficiency

ERwin Examiner analyzes databases already in production without modifying the existing data by scanning corresponding ERwin models or through reverse engineering. It produces complete graphical and tabular documentation to ensure solid structural integrity. ERwin Examiner allows you to check and validate alterations to a database design as a result of maintaining or combining the database structures. This allows you to simulate design changes before implementing them.

Distinctive Features

Comprehensive Diagnostics And Reporting
ERwin Examiner analyzes data structure, keys, indexes, field columns, and relationships. It supplies graphic documentation of the entire database structure including column cross-reference and relationship listings. The comprehensive diagnostics of ERwin Examiner apply Relational Modeling Rules to the performance parameters of your specific database environment. ERwin Examiner then generates detailed diagnostic reports that pinpoint any inconsistencies or anomalies in the database design. Diagnostic results are conveniently organized into these categories: columns, indexes, constraints, normalization, and relationships.

Automatically Improves Database Design
Based on the results of its comprehensive diagnostics, ERwin Examiner recommends changes to your database model providing an efficient and consis-tent approach to improving database design. In addition, ERwin Examiner automatically generates and applies alter scripts directly to your database or ERwin model.

Isolates Design Discrepancies
ERwin Examiner�s detailed diagnostic reports increase productivity by accelerating the review process. Its innovative "Show Me" facility isolates specific design issues in complex database models eliminating the task of sifting through thousands of lines of code. A window displays the particular part of the database structure that requires modification. Modelers can also define and work with a subset of the model. Teach Me Facility Educates Modelers. In addition to providing specific diagnostic messages and recommendations, ERwin Examiner explains the theory behind the messages. This valuable "Teach Me" facility reveals the impact of design choices or modifications in light of Relational Theory. By instructing data modelers on the effects of their design decisions, ERwin Examiner helps modelers construct higher quality databases.

ADvantage -- Managing Application Development
ERwin Examiner is part of the ADvantage family of products, a foundation for building, deploying, and managing applications. ADvantage consists of solutions for process and project management, change and configuration management, modeling and design, and knowledge publication and visualization. ADvantage strengthens your ability to automate the critical application life cycle processes required to succeed in todays increasingly complex and rapidly changing eBusiness economy.