Testing the relational Database
Mitu Dhull, Archana Sharma, Guru Nānak, Yamuna Nagar · 2010
It is proposed that database systems be assessed for quality using an approach based on stochastic software testing. This approach requires an understanding of potential data errors ranging from syntactic mistakes to undetectable dirty data. A data error classification schema has been developed to categorize the type of data errors that could be found during testing. This classification schema provides a basis for developing test cases inclusive of data, constraints, rules, and supporting queries. A process is described whereby a database system is tested using the test cases and data validation requirements to generate feedback on data quality.