A practical guide to SQL white-box testing

Authors:
Javier Tuya;M. José Suárez-Cabal;Claudio de la Riva
Affiliations:
Universidad de Oviedo, GIJON/SPAIN;Universidad de Oviedo, GIJON/SPAIN;Universidad de Oviedo, GIJON/SPAIN
Venue:
ACM SIGPLAN Notices
Year:
2006

Citing 10
Cited 2

The category-partition method for specifying and generating fuctional tests

Communications of the ACM
A survey on usage of SQL

ACM SIGMOD Record
Automatic Generation of Database Instances for White-box Testing

COMPSAC '01 Proceedings of the 25th International Computer Software and Applications Conference on Invigorating Software Development
A family of test adequacy criteria for database-driven applications

Proceedings of the 9th European software engineering conference held jointly with 11th ACM SIGSOFT international symposium on Foundations of software engineering
Reviewing 25 Years of Testing Technique Experiments

Empirical Software Engineering
Using an SQL coverage measurement for testing database applications

Proceedings of the 12th ACM SIGSOFT twelfth international symposium on Foundations of software engineering
Testing database transactions with AGENDA

Proceedings of the 27th international conference on Software engineering
An AGENDA for testing relational database applications: Research Articles

Software Testing, Verification & Reliability
A comparison of MC/DC, MUMCUT and several other coverage criteria for logical decisions

Journal of Systems and Software - Special issue: Quality software
Semantic errors in SQL queries: A quite complete list

Journal of Systems and Software - Special issue: Quality software

Query-aware shrinking test databases

Proceedings of the Second International Workshop on Testing Database Systems
Repairing OLAP queries in databases with referential integrity errors

DOLAP '10 Proceedings of the ACM 13th international workshop on Data warehousing and OLAP

Quantified Score

Hi-index	0.00

Visualization

Abstract

SQL is a ubiquitous language used in a wide range of applications for accessing the data stored in relational databases. However, the usual software testing techniques are not designed to address some important features of SQL. We present a set of practical guidelines for designing white-box tests cases that reasonably exercise the way in which an SQL query processes the stored data. These guidelines are illustrated using an example.