Abstract
Because program behaviors of database applications depend on the data used, code coverages do not effectively test database applications. Additionally, test coverages for database applications that focus on predicates in Structured Query Language (SQL) queries are not useful if the necessary predicates are omitted. In this paper, we present two new database applications using Plain Pairwise Coverage (PPC) and Selected Pairwise Coverage (SPC) for SQL queries called Plain Pairwise Coverage Testing (PPCT) and Selected Pairwise Coverage Testing (SPCT), respectively. These coverages are based on pairwise testing coverage, which employs selected elements in the SQL SELECT query as parameters. We also implement a coverage calculation tool and conduct case studies on two open source software systems. PPCT and SPCT can detect many faults, which are not detected by existing test methods based on predicates in the query. Furthermore, the case study suggests that SPCT can detect faults more efficiently than PPCT and the costs of SPCT can be further reduced by ignoring records filtered out by the conditions of the query.
| Original language | English |
|---|---|
| Title of host publication | Proceedings - 2016 IEEE International Conference on Software Testing, Verification and Validation Workshops, ICSTW 2016 |
| Publisher | Institute of Electrical and Electronics Engineers Inc. |
| Pages | 92-101 |
| Number of pages | 10 |
| ISBN (Electronic) | 9781509018260 |
| DOIs | |
| Publication status | Published - 2016 Aug 1 |
| Event | 9th IEEE International Conference on Software Testing, Verification and Validation Workshops, ICSTW 2016 - Chicago, United States Duration: 2016 Apr 10 → 2016 Apr 15 |
Other
| Other | 9th IEEE International Conference on Software Testing, Verification and Validation Workshops, ICSTW 2016 |
|---|---|
| Country | United States |
| City | Chicago |
| Period | 16/4/10 → 16/4/15 |
Fingerprint
Keywords
- combinatorial testing
- coverage
- database testing
- test data
ASJC Scopus subject areas
- Software
- Safety, Risk, Reliability and Quality
Cite this
Pairwise Coverage-Based Testing with Selected Elements in a Query for Database Applications. / Tsumura, Koji; Washizaki, Hironori; Fukazawa, Yoshiaki; Oshima, Keishi; Mibe, Ryota.
Proceedings - 2016 IEEE International Conference on Software Testing, Verification and Validation Workshops, ICSTW 2016. Institute of Electrical and Electronics Engineers Inc., 2016. p. 92-101 7528951.Research output: Chapter in Book/Report/Conference proceeding › Conference contribution
}
TY - GEN
T1 - Pairwise Coverage-Based Testing with Selected Elements in a Query for Database Applications
AU - Tsumura, Koji
AU - Washizaki, Hironori
AU - Fukazawa, Yoshiaki
AU - Oshima, Keishi
AU - Mibe, Ryota
PY - 2016/8/1
Y1 - 2016/8/1
N2 - Because program behaviors of database applications depend on the data used, code coverages do not effectively test database applications. Additionally, test coverages for database applications that focus on predicates in Structured Query Language (SQL) queries are not useful if the necessary predicates are omitted. In this paper, we present two new database applications using Plain Pairwise Coverage (PPC) and Selected Pairwise Coverage (SPC) for SQL queries called Plain Pairwise Coverage Testing (PPCT) and Selected Pairwise Coverage Testing (SPCT), respectively. These coverages are based on pairwise testing coverage, which employs selected elements in the SQL SELECT query as parameters. We also implement a coverage calculation tool and conduct case studies on two open source software systems. PPCT and SPCT can detect many faults, which are not detected by existing test methods based on predicates in the query. Furthermore, the case study suggests that SPCT can detect faults more efficiently than PPCT and the costs of SPCT can be further reduced by ignoring records filtered out by the conditions of the query.
AB - Because program behaviors of database applications depend on the data used, code coverages do not effectively test database applications. Additionally, test coverages for database applications that focus on predicates in Structured Query Language (SQL) queries are not useful if the necessary predicates are omitted. In this paper, we present two new database applications using Plain Pairwise Coverage (PPC) and Selected Pairwise Coverage (SPC) for SQL queries called Plain Pairwise Coverage Testing (PPCT) and Selected Pairwise Coverage Testing (SPCT), respectively. These coverages are based on pairwise testing coverage, which employs selected elements in the SQL SELECT query as parameters. We also implement a coverage calculation tool and conduct case studies on two open source software systems. PPCT and SPCT can detect many faults, which are not detected by existing test methods based on predicates in the query. Furthermore, the case study suggests that SPCT can detect faults more efficiently than PPCT and the costs of SPCT can be further reduced by ignoring records filtered out by the conditions of the query.
KW - combinatorial testing
KW - coverage
KW - database testing
KW - test data
UR - http://www.scopus.com/inward/record.url?scp=84992170233&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=84992170233&partnerID=8YFLogxK
U2 - 10.1109/ICSTW.2016.19
DO - 10.1109/ICSTW.2016.19
M3 - Conference contribution
AN - SCOPUS:84992170233
SP - 92
EP - 101
BT - Proceedings - 2016 IEEE International Conference on Software Testing, Verification and Validation Workshops, ICSTW 2016
PB - Institute of Electrical and Electronics Engineers Inc.
ER -