Comprehensive Diagnostics and Reporting

Schema Examiner analyzes the schema's data structure, keys, indexes, field columns and relationships, and generates graphic documentation of the entire database structure, including column cross-reference and relationship listings. Schema Examiner applies the rules of the relational model to detect flaws and inconsistencies. The diagnostic can be customized, by selecting the ones important to your organization. Diagnostic results are conveniently organized by categories or severity levels.

Design Discrepancy Isolation

Schema Examiner provides detailed diagnostic reports that can help 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 modifications. Modelers can also define and work with a subset of the model.

Improve Productivity and Accuracy

By analyzing relational data models to identify integrity and efficiency, Schema Examiner accelerates database design and deployment and improves the consistency and quality of data structures across the enterprise. Its comprehensive set of diagnostics validates database design, recommends improvements and automatically generates scripts to quickly execute design changes. Detailed diagnostic reports illustrate structural inconsistencies in a conveniently organized format. This powerful tool fine-tunes database design to ensure a solid foundation for any business applications.

Maximize Design Efficiency

Schema Examiner analyzes databases being built or databases already in production. It does so by directly interfacing with ER/Studio, reading SQL Scripts directly, or performing reverse engineering on the database schema. Schema Examiner allows users to check and validate alterations to a database design as a result of maintenance or new inclusions to the database structures. Users can simulate design changes before implementing them.

Increase Database Performance

Schema Examiner identifies violations of best practices that adversely affect performance. Suggested changes are scripted for easy implementation.

Teach Me Facility

In addition to providing specific diagnostic and recommendations, Schema 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, Schema Examiner helps modelers construct higher quality databases.