Test Plan for a Database

Written by rick waugh
  • Share
  • Tweet
  • Share
  • Pin
  • Email
Test Plan for a Database
A well-documented plan saves grief in implementing a database. (taking test image by Petro Feketa from Fotolia.com)

A database test plan can cover different things depending on the scenario. A full database migration would require a wide ranging test. A change to a single application could require a detailed analysis of data in a few tables.

Other People Are Reading

Performance

A new database, or a large change to an old one, usually requires a performance test. At the simplest level, this could involve running some of your largest transactions or reports. A larger database with a greater change could involve using automated testing tools to challenge the system with a quantity of complex data.

Functionality

After a migration or application changes, it is important to note whether the application can function. Run through a set of transactions designed to work out the areas where changes occurred.

Integrity

Build queries to test data integrity. Run transactions against the database, then use the queries to check the data is being created, deleted and updated correctly. While performance and the ability to work in a system are important, it is data integrity problems that can lie hidden for months which cause the most anguish in the end.

Connections

Test connections from the other systems that access the database. Make sure the database accounts they use are functional. Some simple queries or transactions from these remote systems will suffice.

Metrics

With any test plan, the most important part is that it exists. Decide ahead of time what is to be measured and how it is to be measured. Changes can always be made and additional tests can be performed.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.