What can DB-Examiner do for you?
The 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 DB-Examiner.

DB-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 the deviations. With DB-Examiner, you can be assured that information that is disseminated throughout the company is reliable.

Why DB-Examiner be used?
Relational Database Management Systems (RDBMS) are based on the Relational Theory. To get the most out of them, you are supposed to define objects that adhere to the relational standards. One of the greatest paradoxes of a 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 a 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 under a RDBMS are: more complex source code, increased system complexity, and manual manipulation of integrity. In fewer words, more expensive and vulnerable systems.
 

Aren't modeling tools sufficient?
Although you may (and probably should) use a modeling tool (such as ERwin or Oracle's Designer) as an aid in the development cycle, there are no guarantees that the model you design will conform to relational standards. A modeling tool will only create the structures you tell it to create, whether they follow relational theory or not.

Why must I use DB-Examiner every time I modify my database structure?
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 creative things.

Can't I manually validate my model?
DB-Examiner verifies the structure of your system against a set of rules, in a fraction of the time you'll need to do it manually. It instructs you on the theoretical principles applied to verify your system, and generates the corrections to improve your structure.

What is the Teach Me Facility within DB-Examiner?
DB-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.

Please contact us at: support@dbesoftware.com