Home   
Site Map   
Contact Us   
graphic
graphic
Product Solutions

DBE Software

DBE Software's DB-Examiner helps companies achieve superior information quality by improving their database schemas and therefore allowing them to successfully develop highly complex database applications in a fraction of the time and cost.

By implementing the suggestions provided by DB-Examiner, companies will:

  • Minimize the effort to comply with Sarbanes-Oxley requirements. With a poorly designed database schema, compliance with SOX will be compromised.
  • Generate Quality information for decision making and for operational applications – many applications have been scrapped due to poor information.
  • Implement new applications in a much sorter time – the database schema will be correct in fewer iterations; this is true for the initial creation of the application and the subsequent maintenance.
  • Save substantial amounts of money in development and maintenance due to reduced workload.

DB-Examiner

DB-Examiner is an easy-to–use, powerful solution that identifies design discrepancies, recommends precise corrections and generates scripts to implement corrections. DB-Examiner is an extensive analytical tool to validate and improve the database schemas for the majority of the leading relational database management systems (Oracle, DB2, Sybase, SQL Server and generic ODBC based RDBMS); it can also validate the data models from the leading database modeling tools from CA, Oracle, Sybase, etc. It is also extremely useful in situations where no modeling tools were used to create the database schemas.  PRODUCT BROCHURE

This powerful product provides numerous features, including:

  • Comprehensive Diagnostics and Reporting. DB-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. DB-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 severities.
  • Design Discrepancy Isolation. DB-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 definitions of the database schema. A window displays the particular part of the database structure that requires modifications. Modelers working with data models can work with the entire model or subsets of the data model.
  • Improved productivity and accuracy by analyzing relational data models to identify integrity and efficiency. DB-Examiner accelerates database design and deployment by improving 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 by analyzing databases being built or databases already in production. It does so by direct interface with popular modeling tools, reading SQL Scripts directly, or performing reverse engineering on the database schema. DB-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. This saves a lot of time and money because the alterations are not implemented until they are validated by DB-Examiner.
  • Increase database performance by identifying 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, DB-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, DB-Examiner helps modelers construct higher quality databases.

DBE Software core competencies are based on a strict discipline and focus on the integral quality of the database. 

DBE Software can be found on the web at www.dbesoftware.com

ADDITIONAL RESOURCES