Relational Database Testing

by Nataliia Vasylyna | January 9, 2017 7:52 am

Usually, database testing is neglected at all or conducted formally without any detalization. But this software testing procedure is an inevitable part of agile testing and it should become an essential part of traditional testing approaches.

Actually, the process of database testing is the validation of its content, schema, and functionality. If to talk about relational database testing, then two types of threats should be reviewed: at the database interface (black box testing[1]) and within the database (clear box testing). Besides that, relational databases include table structure, actual data, relationships between elements, classes, stored features, etc.

Relational Database Testing Includes:

The above-mentioned checking types can be conducted with applying TDDD (Test Driven Database Development). It is also known as Behavior Driven Database Development (BDDD). Only that part of database code is written which is required for running a single test. It is the way to specify the database design.

If some modification were made (code changes or the way of data input to the base), then database regression testing is performed. The point is that such modifications may potentially affect the correct work of the database.

Learn more from QATestLab

Related Posts:

Endnotes:
  1. black box testing: https://qatestlab.com/resources/knowledge-center/black-box-testing/
  2. functional testing : https://qatestlab.com/services/We-Are-Professionals-in/functional-testing/
  3. performance testing: https://qatestlab.com/services/Withstand-the-Load/performance-testing/
  4. RDBM Testing Tools: https://blog.qatestlab.com/2017/01/13/rdbm-testing-tools/
  5. What Is Database Sandbox?: https://blog.qatestlab.com/2017/01/11/database-sandbox-notion/
  6. What Is ETL Testing?: https://blog.qatestlab.com/2016/12/14/extraction-transformation-loading/

Source URL: https://blog.qatestlab.com/2017/01/09/relational-database-testing/