Database Integration Testing

Definition

Database integration testing is integration testing to determine if the application software components interface properly with the database(s).

The typical objectives of database integration testing are typically to:

Database integration testing can begin when the following preconditions hold:

The integration team is adequately staffed and trained in database integration testing.
The integration environment is ready.
The database(s) have been:
- Obtained (either bought or an evaluation copy).
- Ported to the integration environment.
- Integrated.
- Configured

Database integration testing is complete when the following postconditions hold:

A complete set of test cases that read and write data to the database have successfully executed.

Database integration testing involves the integration team performing the following testing tasks:

Database integration testing is typically performed on the following environments using the following tools:

Database integration testing typically consists of the following tasks being performed during the following phases:

TASK \ PHASE	*Business Strategy ()**	*Business Optimization ()**	*Initiation ()**	Construction	Delivery	Usage	Retirement
Test Planning	Not Applicable	Not Applicable	Started	Completed	Iterated	Iterated	Not Applicable
Test Reuse	Not Applicable	Not Applicable	Started	Completed	Iterated	Iterated	Not Applicable
Test Design	Not Applicable	Not Applicable	Started	Completed	Iterated	Iterated	Not Applicable
Test Implementation	Not Applicable	Not Applicable	Started	Completed	Iterated	Iterated	Not Applicable
Test Execution	Not Applicable	Not Applicable	Started	Completed	Iterated	Iterated	Not Applicable
Test Reporting	Not Applicable	Not Applicable	Started	Completed	Iterated	Iterated	Not Applicable

(*) Potentially some database integration testing may occur during database vendor and product evaluation.

Database integration testing can elicit failures produced by defects that are difficult to detect during system or launch testing once the databases have been completely integrated into the system.