Query-aware shrinking test databases

Tuya, Javier; Suárez-Cabal, M. José; Riva, Claudio de la

doi:10.1145/1594156.1594164

Cited by 7 publications

(3 citation statements)

References 17 publications

(13 reference statements)

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Helpdesk is an in-house web application to manage service requests [7]. We used a production database as the initial database with 22,387 tickets, 103,553 annotations on tickets and 279 users.…”

Section: Objects Of Studymentioning

confidence: 99%

See 1 more Smart Citation

Coverage-Aware Test Database Reduction

Tuya

Riva

Suárez-Cabal

et al. 2016

IIEEE Trans. Software Eng.

Self Cite

View full text Add to dashboard Cite

Abstract-Functional testing of applications that process the information stored in databases often requires a careful design of the test database. The larger the test database, the more difficult it is to develop and maintain tests as well as to load and reset the test data. This paper presents an approach to reduce a database with respect to a set of SQL queries and a coverage criterion. The reduction procedures search the rows in the initial database that contribute to the coverage in order to find a representative subset that satisfies the same coverage as the initial database. The approach is automated and efficiently executed against large databases and complex queries. The evaluation is carried out over two real life applications and a well-known database benchmark. The results show a very large degree of reduction as well as scalability in relation to the size of the initial database and the time needed to perform the reduction.

show abstract

Section: Objects Of Studymentioning

confidence: 99%

“…While our prior work on test database reduction [7] deals with tool support for a very limited kind of queries, this work largely expands the applicability of the approach to more complex queries and provides a thorough assessment of the results.…”

Section: Introductionmentioning

confidence: 99%

Coverage-Aware Test Database Reduction

Tuya

Riva

Suárez-Cabal

et al. 2016

IIEEE Trans. Software Eng.

Self Cite

View full text Add to dashboard Cite

show abstract

“…equivalence partitioning and boundary value analysis). In addition, Tuya et al 16 proposed a new approach which is able to automatically reduce the initial databases in order to keep test databases as small as possible while preserving the coverage of the data. Anna Derezinska 17 conducted an experimental case study to apply SQL mutation operators to typical queries commonly used in programs interacting with a real database implemented in an insurance company.…”

Section: Introductionmentioning

confidence: 99%

JDAMA: Java database application mutation analyser

Zhou

Frankl

2011

Software Testing Verif & Rel

View full text Add to dashboard Cite

Database application programs are ubiquitous; hence, good techniques for testing them are needed. Several approaches to testing database applications have been proposed recently, including test generation techniques and adequacy criteria. Tuya et al. proposed mutation‐based adequacy criteria for database queries and developed a set of mutation operators for Structured Query Language SELECT statements. This paper extends that approach by integrating it with analysis and instrumentation of the application bytecode. The design and implementation of a tool, Java Database Application Mutation Analyser (JDAMA), are described. JDAMA instruments application bytecode so as to compare the results of queries executed by the application under test to the results of mutants of those queries. JDAMA can be used to support mutation testing for Java database applications. A second, potentially more useful application of JDAMA is to support experiments evaluating testing techniques for database applications, in which query mutation is used to seed faults into subject applications. The paper illustrates these uses of JDAMA with experiments comparing two approaches to test generation and experiments evaluating coverage criteria. Copyright © 2011 John Wiley & Sons, Ltd.

show abstract