A controlled experiment on White-box database testing - Additional information

Data Model | List of Queries | Experiment data

Data Model

List of queries

Q1	SELECT DISTINCT p.name , e.name FROM project p LEFT JOIN work t ON p.proyId = w.proyId LEFT JOIN empoloyee e ON w.empId = e.empId WHERE e.hourSalary <= 20 OR e.hourSalary IS NULL ORDER BY p.name ASC , e.name ASC
Q2	SELECT e.name , w.month , w.hours , p.name FROM empoloyee e LEFT JOIN work t ON w.empId = e.empId LEFT JOIN project p ON p.proyId = w.proyId WHERE w.hours > 50 ORDER BY e.name ASC , w.month ASC
Q3	SELECT e.name , p.name , SUM( hours ) FROM empoloyee e INNER JOIN work t ON e.empId = w.empId INNER JOIN project p ON w.proyId = p.proyId GROUP BY e.name , p.name HAVING ( SUM( hours ) < @hours ) OR ( SUM( hours ) IS NULL) ORDER BY p.name ASC , e.name ASC
Q4	SELECT p.name , SUM( hours ) FROM project p INNER JOIN work t ON p.proyId = w.proyId LEFT JOIN empoloyee e ON w.empId = e.empId WHERE ( e.level <> 'B' ) OR ( e.level IS NULL) GROUP BY p.name HAVING SUM( horas ) > @hours ORDER BY p.name ASC

Experimental data

The following data includes the mutation scores for each test case, organized as follows:

Group (A or B)
Subject (from 1 to 20)
Query (Q1 to Q4)
Technique (CC or OT)
Score (mutation Score: M)

Data is in CSV format (separator is ;)

Group;Subject;Query;Technique;Score
A;1;Q1;CC;0.9326
A;1;Q2;OT;0.8491
A;1;Q3;CC;0.6720
A;1;Q4;OT;0.8934
A;1;Q5;CC;0.7711
A;1;Q6;OT;0.9247
A;2;Q1;CC;0.9326
A;2;Q2;OT;0.8396
A;2;Q3;CC;0.8160
A;2;Q4;OT;0.8852
A;2;Q5;CC;0.8554
A;2;Q6;OT;0.9140
A;3;Q1;CC;0.8652
A;3;Q2;OT;0.8491
A;3;Q3;CC;0.7280
A;3;Q4;OT;0.8770
A;3;Q5;CC;0.8313
A;3;Q6;OT;0.8925
A;4;Q1;CC;0.9326
A;4;Q2;OT;0.8679
A;4;Q3;CC;0.6800
A;4;Q4;OT;0.8525
A;4;Q5;CC;0.8434
A;4;Q6;OT;0.9247
A;5;Q1;CC;0.9213
A;5;Q2;OT;0.8774
A;5;Q3;CC;0.9360
A;5;Q4;OT;0.8197
A;5;Q5;CC;0.9157
A;5;Q6;OT;0.8602
A;6;Q1;CC;0.9101
A;6;Q2;OT;0.8868
A;6;Q3;CC;0.9120
A;6;Q4;OT;0.9016
A;6;Q5;CC;0.9157
A;6;Q6;OT;0.8925
A;7;Q1;CC;0.9326
A;7;Q2;OT;0.8113
A;7;Q3;CC;0.8480
A;7;Q4;OT;0.9098
A;7;Q5;CC;0.8795
A;7;Q6;OT;0.9032
A;8;Q1;CC;0.9326
A;8;Q2;OT;0.8113
A;8;Q3;CC;0.9360
A;8;Q4;OT;0.8033
A;8;Q5;CC;0.9157
A;8;Q6;OT;0.8817
A;9;Q1;CC;0.9326
A;9;Q2;OT;0.8679
A;9;Q3;CC;0.8720
A;9;Q4;OT;0.8934
A;9;Q5;CC;0.9036
A;9;Q6;OT;0.9140
A;10;Q1;CC;0.8989
A;10;Q2;OT;0.8019
A;10;Q3;CC;0.7200
A;10;Q4;OT;0.8115
A;10;Q5;CC;0.8072
A;10;Q6;OT;0.8495
B;11;Q1;OT;0.8202
B;11;Q2;CC;0.9057
B;11;Q3;OT;0.7280
B;11;Q4;CC;0.7541
B;11;Q5;OT;0.7470
B;11;Q6;CC;0.9140
B;12;Q1;OT;0.8652
B;12;Q2;CC;0.8302
B;12;Q3;OT;0.7680
B;12;Q4;CC;0.8934
B;12;Q5;OT;0.7470
B;12;Q6;CC;0.9247
B;13;Q1;OT;0.7303
B;13;Q2;CC;0.8962
B;13;Q3;OT;0.7440
B;13;Q4;CC;0.8361
B;13;Q5;OT;0.7831
B;13;Q6;CC;0.8710
B;14;Q1;OT;0.8539
B;14;Q2;CC;0.8491
B;14;Q3;OT;0.8480
B;14;Q4;CC;0.9016
B;14;Q5;OT;0.7952
B;14;Q6;CC;0.9462
B;15;Q1;OT;0.8876
B;15;Q2;CC;0.8962
B;15;Q3;OT;0.8240
B;15;Q4;CC;0.8607
B;15;Q5;OT;0.8675
B;15;Q6;CC;0.9247
B;16;Q1;OT;0.8202
B;16;Q2;CC;0.8962
B;16;Q3;OT;0.8160
B;16;Q4;CC;0.9262
B;16;Q5;OT;0.8675
B;16;Q6;CC;0.9247
B;17;Q1;OT;0.9326
B;17;Q2;CC;0.8774
B;17;Q3;OT;0.8240
B;17;Q4;CC;0.8525
B;17;Q5;OT;0.8193
B;17;Q6;CC;0.9355
B;18;Q1;OT;0.8539
B;18;Q2;CC;0.8585
B;18;Q3;OT;0.7520
B;18;Q4;CC;0.9180
B;18;Q5;OT;0.8072
B;18;Q6;CC;0.9032
B;19;Q1;OT;0.8090
B;19;Q2;CC;0.8868
B;19;Q3;OT;0.7200
B;19;Q4;CC;0.9262
B;19;Q5;OT;0.7349
B;19;Q6;CC;0.9032
B;20;Q1;OT;0.9101
B;20;Q2;CC;0.8679
B;20;Q3;OT;0.6640
B;20;Q4;CC;0.9262
B;20;Q5;OT;0.8193
B;20;Q6;CC;0.9140

Papers | Home Page