Database testing
Database is an amount of data composed according to certain rules. It is necessary for long-term storage and multiple usages. 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 of those non-functional requirements to the information, the 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 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
- System alterations;
- New system development for replacement of the current one;
- New system development to migrate the data from the 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.
