Database Design, Testing And Validation Tools | Schema Examiner From Embarcadero Technologies

50 %
50 %
Information about Database Design, Testing And Validation Tools | Schema Examiner From...
Technology

Published on March 24, 2009

Author: findling67

Source: slideshare.net

Description

Embarcadero Technologies is the leader in database tools and developer software. Schema Examiner automatically reviews and finds design errors in a database schema. Detailed reporting and graphical documentation then simplify the process of pinpointing and reviewing these problems. Business requirements change over time, and naturally this can require changes to the database schema.

design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it Embarcadero Schema Examiner DATASHEET build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design™ ∙ build it it ® run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it Spell-check for Database Schema build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it ∙ design it ∙ build it ∙ run it Schema Examiner automatically reviews and finds design errors in a database Related Products schema. Detailed reporting and graphical documentation then simplify the process of pinpointing and reviewing these problems. Finally, Schema Examiner er/studio® A model-driven data recommends changes to database schema and can automatically generate scripts to fix architecture and database problems. This efficient and consistent approach to improving database design helps avoid design solution. costly data errors and performance problems. dBartisan® • Simplifies the process of testing and validating The leading cross-platform database schema database administration solution helps DBAs • Allows reverse-engineering of existing schema maximize performance, • Creates diagnostic reports that increase productivity availability, and security. • Recommends changes and automatically rapid sql® generates scripts to fix problems An integrated cross- platform database reduces development and maintenance costs development environment with comprehensive tools Ensuring that database designs conform to relational for tuning and editing standards is often an extensive manual process that requires code. hours upon hours of review. By automating this process, the Schema Examiner visually embarcadero® analysis goes from hours to minutes. Additionally, Schema Examiner not only represents diagnostics all-access™ finds problems, but recommends solutions, saving time and improving productivity Instant access to the during all phases of the database lifecycle. Whether validating the initial design languages, tools, and or evaluating possible changes, improving design quality lowers costs by saving technologies to design, development time and improving database performance. build, and run your software applications and database systems. improves consistency and quality of data across the enterprise The quality of the data in your database is of the utmost importance to your business. And maintaining Solution Pack consistency and quality, especially when data is touched by multiple end users is very challenging. By examiner edition enforcing correct relational design, Schema Examiner helps prevent incorrect and inconsistent data from Schema Examiner and reaching the database. ER/Studio form a complete solution for database mitigates risk design and schema validation. Business requirements change over time, and naturally this can require changes to the database schema. The length of time required to comprehensively test and validate these changes manually is often just too long. It’s all too common for changes to be promoted to production without thorough review. Every change promoted to production compounds the risks of data integrity being lost and of database performance degradation. By automating the process, schema examiner allows validation to become part of the standard change process, significantly reducing deployment risk. Schema Examiner generates comprehensive reports to share diagnostics

Features Description Schema Examiner Comprehensive Diagnostics and Reporting Schema Analysis Analyzes the schema’s data structure, keys, indexes, field columns and relationships Flaw Detection Applies the rules of the relational model and detect flaws and inconsistencies Customizable Diagnostics Diagnostics can be specified to isolate only key metrics, then conveniently grouped based on category or severity Intuitive Reporting Graphical documentation of the entire database structure, including column cross-reference and relationship listings is provided in an easily read and responded to format Design Discrepancy Isolation Isolate Design Issues Innovative “Show Me” facility isolates specific design issues in complex database models, saving hours of time sifting through thousands of lines of code Intuitive Display Design issues found are displayed in a simplified window that drills down only on the affected portion of the structure Model Division Modelers can specify which subsets of the model to deal with at a given time, allowing validation work to be done in manageable chunks Database Relational Model Analysis Error Discovery Quickly identifies structural errors allowing them to be easily fixed before they flow through the entire design Design Validation Validates design elements against industry standards to ensure consistent design quality across the entire database Change Recommendation Diagnostics not only evaluate current quality, but also provide recommendations for improvement, including automatically generating scripts to execute design changes Flexible Analysis Interface Database Reverse Engineering Reverse engineers database schema from existing databases for analysis SQL Script Interface Performs analysis on database schema based on SQL Scripts ER/Studio Model Interface Directly interfaces with ER/Studio allowing schema analysis, validation and recommendations while designing the database in ER/Studio Change Validation Maintenance Management 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. Performance Management Schema Examiner identifies violations of best practices that adversely affect performance. Suggested changes are scripted for easy implementation. Instructive Recommendation 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. Cross-platform Support Multi-platform Interface All database platforms are accessed from the same easy to use interface Cross-platform Compare Compare database schemas from different database platforms with each other to highlight similarities and variations ‘Teach Me” Facility Flaw Impact Analysis Reveals the impact of design choices or modifications in light of relational theory by explaining the relational theory that the flaw violates DBMS Support System Requirements Operating System Memory • IBM® DB2® Mainframe versions 4, 5, 6, 7 and 8 • IBM DB2 Client/Server versions 4, 5, 6 and 7 Microsoft Windows 98, ME, XP Home 256 MB ® • Microsoft® SQL Server 6.5, 7, 2000 and 2005 Microsoft Windows NT®, 2000, 2003 and XP Professional 512 MB • Oracle® 7, 8i, 9i and 10g • Sybase® 10, 11 and 12.x • Schema Examiner also supports any ODBC compliant datasource Download a Free Trial at www.embarcadero.com Corporate Headquarters | Embarcadero Technologies | 100 California Street, 12th Floor | San Francisco, CA 94111 | www.embarcadero.com | sales@embarcadero.com © 2009 Embarcadero Technologies, Inc. Embarcadero, the Embarcadero Technologies logos, and all other Embarcadero Technologies product or service names are trademarks or registered trademarks of Embarcadero Technologies, Inc. All other trademarks are property of their respective owners. SCH/DS/2009/01/20

Add a comment

Related presentations

Related pages

Data Validation

Data validation guarantees to your application that every data value is correct and accurate. You can design data validation into your application with ...
Read more

Database Tools and Developer Software | Embarcadero ...

The complete database management and modeling solution for delivering significant productivity gains across a broad set of DBMS platforms.
Read more

Data migration - Wikipedia, the free encyclopedia

Data migration is the process of transferring data between storage types, formats, or computer systems. It is a key consideration for any system ...
Read more

Embarcadero Developer Network Home Page

Welcome to the Embarcadero Developer Network (EDN), the community site for developers where you can access, ...
Read more

DB Optimizer Community

DB Optimizer Community. EDN. 3rdRail & TurboRuby; Blackfish SQL; C++Builder; Change Manager; DB Optimizer; DBArtisan; Delphi; ER/Studio; FireMonkey; HTML5 ...
Read more

How EPA Manages the Quality of its Environmental Data | US EPA

The EPA Quality Program provides requirements for conducting quality management activities for all environmental data collection and environmental ...
Read more

IT Networking - Network Performance Testing Tools | Fluke ...

Fluke Networks provides network performance monitoring tools that give accurate results and help IT professionals meet today’s networking challenges.
Read more

CERTIFICATE/DIPLOMA IN IITT - OCR - awarding body for A ...

Database Design Level 3 Unit 23 in a questionnaire and then feed their questions back to the group. Using the example databases that the learners have created
Read more