A1QA Blog

QA Core for Executives

Database Testing

Database is an amount of data composed according to certain rules. It is necessary for long-term storage and multiple usage. Moreover, it is one of the most important structural components of information systems. For providing high quality data storage and quick information processing database should meet several requirements. Among those are:

  • Authenticity;
  • Integrity;
  • Reliability;
  • Security;
  • Flexibility;
  • High response time.

The named points are considered as the set of non-functional requirements or also quality attributes. They checked according to certain scripts and rated with the marks. As an example of one those non-functional requirements to the information system is search of certain data type in 5 seconds, if the process goes longer the base is low rated.

Though, the quality attributes are not the only testing parameters for verifying the base quality. Apart from that, the system should be compliant with the standard functional requirements.
The compliance is checked with several testing types like performance testing, migration testing and some others. The aim of all the held tests is to ensure the base quality, request processing, and correct processing of migrated data. As long as the aim is achieved the system is regarded as high quality one, or needing the improvement.

Data migration is a complex and important procedure made within the database system, which makes migration testing a basic part of all tests held while database verification. The data migration is held in case of

  1. System alterations;
  2. New system development for replacement of the current one;
  3. New system development to migrate the data from exterior base.

This testing type checks, if the data leakage or damage happened under the migration process. In addition to that, it verifies the data integrity and completeness, so that the system could be efficiently used for business processes. In the next blog post we`ll get through the approaches applied in database migration testing.

Share this:

  • Prashant Chambakara

    Database is the heart of any apps and hence holds a great value in testing. I liked your post. Excellent read. Was searching about database testing and found yours. We too have a tool developed and it has database testing feature. I would like to share about it, hoping that it might be a good further read.