arrow
Return

Mutation testing of PL/SQL programs

delete2022-10-01
delete2
PRE
AI
A
Arzu Behiye Tarımcı
H
Hasan Sözer *
DOI:10.1016/j.jss.2022.111399delete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
Mutation testing is a prominent technique for evaluating the effectiveness of a test suite. Existing tools developed for supporting this technique are applicable for mainstream programming languages like C and Java. Mutation testing tools and mutation operators used by these tools are inherently language -specific. Moreover, there is a lack of industrial case studies for evaluating mutation testing tools and techniques in practice. In this article, we introduce muPLSQL, a tool for applying mutation testing on PL/SQL programs, facilitating automation for both mutant generation and test execution. We utilized existing mutation operators that are applicable for PL/SQL. In addition, we introduced some operators specifically for this language. We conducted an industrial case study for evaluating the applicability and usefulness of our tool and mutation testing in general. We applied mutation testing on a business support software system. muPLSQL generated a total of 5,939 mutants. The number of live mutants was 680. Manual inspection of live mutants led to improvements of the existing test suite. In addition, we found 8 faults in source code during the inspection process. Test execution against the mutants required around 40 h. The overall effort was almost one person month. (C) 2022 Elsevier Inc. All rights reserved.
Keywords:
Software testing
Mutation testing
Mutation analysis
PL/SQL
Industrial case study

Journal

Journal of Systems and Software cover
Journal of Systems and Software
IF:
4.1
Papers:
5.5K
Citations:
8.4K

Organization

O
Ozyegin University
Scholars:
758
Papers: 850
Citations: 3
T
turkcell turkey
Scholars:
20
Papers: 19
Citations: 0
Cited Papers

Cited Papers

Cu2ZnSnS4 thin films by simple replacement reaction route for solar photovoltaic application
err2014-01-01
err0
PREAI
errDevendra Tiwari; Tapas K. Chaudhuri; Arabinda Ray; Krishan Dutt Tiwari
errShare
errSave
A systematic review of adolescents’ sense of coherence and health
err2017-02-03
err0
PREAI
errHelena Länsimies; Anna‐Maija Pietilä; Soili Hietasola‐Husu; Mari Kangasniemi
errShare
errSave
Sulphide stress cracking of a valve stem of duplex stainless steel
err2018-12-01
err0
PREAI
errK. Chandra; A.P. Singh; Vivekanand Kain; Niraj Kumar
errShare
errSave
Forest Soil Management: A Mexican Experience
err2020-01-01
err0
errOAAI
errHelena Cotler; Leticia Merino; Sergio Martinez-Trinidad
errShare
errSave
A systematic literature review of techniques and metrics to reduce the cost of mutation testing
err2019-11-01
err73
PREAI
errPizzoleto, Alessandro Viola; Ferrari, Fabiano Cutigi; Offutt, Jeff; Fernandes, Leo; Ribeiro, Marcio
errShare
errSave
researcher View more