The Effectiveness of Test Coverage Criteria for Relational Database Schema Integrity Constraints

by Phil McMinn, Chris J. Wright, and Gregory M. Kapfhammer

ACM Transactions on Software Engineering and Methodology, 2015



Despite industry advice to the contrary, there has been little work that has sought to test that a relational database’s schema has correctly specified integrity constraints. These critically important constraints ensure the coherence of data in a database, defending it from manipulations that could violate requirements such as “usernames must be unique” or “the host name cannot be missing or unknown”. This paper is the first to propose coverage criteria, derived from logic coverage criteria, that establish different levels of testing for the formulation of integrity constraints in a database schema. These range from simple criteria that mandate the testing ... [more]


Reference

Phil McMinn, Chris J. Wright, and Gregory M. Kapfhammer. The Effectiveness of Test Coverage Criteria for Relational Database Schema Integrity Constraints. ACM Transactions on Software Engineering and Methodology, vol. 25, no. 1, pp. 8:1–8:49, 2015


Bibtex Entry
@article{McMinn2015,
  author  = "McMinn, Phil and Wright, Chris J. and Kapfhammer, Gregory M.",
  title   = "The Effectiveness of Test Coverage Criteria for Relational Database Schema Integrity Constraints",
  journal = "ACM Transactions on Software Engineering and Methodology",
  volume  = "25",
  number  = "1",
  pages   = "8:1--8:49",
  year    = "2015"
}