Go to HomeClient/Server Software Benelux
Tel: +31 23 542 22 27

Schema Examiner

Validate and fine-tune database schema with comprehensive diagnostics and reporting.

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.


Home --> Products --> Architect --> Schema Examiner

Frequently Asked Questions

Q: What can Schema Examiner do for you?
A: Your corporate databases are one of the most valuable assets of your company. The database professionals that design and maintain them must protect this data vigorously. This cannot be easily done without Embarcadero Schema Examiner. Schema Examiner will ensure you have an error-free data model. It checks your data model against a relational theory knowledge-based repository and reports on any deviations. With Schema Examiner, you can be assured that the information that is disseminated throughout the company is reliable.
Q: Why should Schema Examiner be used?
A: Relational Database Management Systems (RDBMS) are based on the Relational Theory. To get the most out of them, you need to define objects that adhere to the relational standards. One of the greatest paradoxes of an RDBMS is that it is possible to define a non-relational object and still be able to store and retrieve data from it. It is important to adhere to relational standards because an RDBMS offers powerful commands that work well on relational objects, but they do not work well, or at all, on non-relational structures. The consequences of having a non-relational object in an RDBMS are: more complex source code, increased system complexity, and manual manipulation of integrity. In fewer words: systems that are more expensive and vulnerable.

Q: Isn’t ER/Studio sufficient?
A: Although ER/Studio is an invaluable aid in the database development cycle, there are no guarantees that the model you design will conform to relational standards. ER/Studio creates the structures you tell it to create, whether they follow relational theory or not. Schema Examiner interfaces directly with ER/Studio models to validate these database designs.

Q: Why must I use Schema Examiner every time I modify my database structure? A: Every time your model is modified, it must be checked for compliance with relational standards. That may take a lot of time, especially if you decide to do it after the system is in production. The hours spent manually checking the model is time that could be used to do more productive things.

Q: Can't I manually validate my model?
A: Schema Examiner verifies the structure of your system against a set of rules, in a fraction of the time it would take to do the same job manually. It instructs you on the theoretical principles applied to verify your system, and automatically generates the corrections to necessary improve your structure.

Q: What is the Teach Me Facility within Schema Examiner?
A: Schema Examiner’s Teach Me facility will assist you in understanding why an issue was reported, what its consequences are, and what your course of action should be. All of these issues are illustrated by examples. The correction facility will generate, if appropriate, scripts to solve the problems.