Functional check of software product to database cooperation

Functional check of software product to database cooperation

The Case

Your QA department tests the functionality of the software product, implementing operations with databases. In the process of its operation this software product changes, adds or deletes data in the database.

In most cases the checks are intended to prove the accuracy of executing complete and multi-stage operations, changing data in databases.

Normally, after each cycle of test operations, a QA department worker tests the contents of different database tables. The number of these tables is often measured by dozens.

Thereby the checking procedure becomes very time consuming and may cause human errors.

Main goals to be achieved 

·         to improve the quality of the software product to database cooperation check;

·         to reduce the time needed for the test of the software product's operation;

·         increasing efficiency and simplicity of checking procedures and eliminating the possibility of human factor;

Our solution

Use Cross-Database Comparator Pro or Cross-Database Studio in order to compare a "regression" database with a "test" database:

1.     A "regression" database corresponding to the correct result of the software product operation is created. These "regression" databases are developed for each stage of the software product operation upon demand.

2.     Upon the completion of all required functions with the tested software product, the "test" database is compared with the "regression" database, which accords with the current stage of tests, in order to get a detailed report about the found differences in table structures, primary keys, indexes, foreign keys, store procedures, data (the list of the objects of comparison is defined by perforce)

3.     The received reports are analyzed in order to make a decision about further steps. If the uncovered difference between the databases is dramatic - act to change the software product, or make any other actions, in accordance with your profile.

4.     You can assign the test at night, or at any time you are comfortable with, by using the scheduling capabilities of the CDBS products.

Advantage of our solution

·         Provides a significant speed-up in the software product test analysis procedures;

·         Improves the quality of the software product to database cooperation check;

·         Eliminates the possibility of human error.