Print Email Facebook Twitter Search-Based Test Data Generation for SQL Queries Title Search-Based Test Data Generation for SQL Queries Author Castelein, Jeroen (TU Delft Electrical Engineering, Mathematics and Computer Science; TU Delft Software Technology) Contributor Finavaro Aniche, Maurício (mentor) Soltani, Mozhan (mentor) van Deursen, Arie (graduation committee) Bozzon, Alessandro (graduation committee) Bosman, Peter A.N. (graduation committee) Degree granting institution Delft University of Technology Programme Computer Science Date 2017-07-28 Abstract Software testing is an important, well-researched field.With the majority of modern-day applications using relational databases to manipulate their data, it is crucial that database interactions are tested as well.This is a complex task to perform manually, and thus researchers have been attempting to tackle this problem by means of automated test data generation.In their studies, they apply constraint-based techniques using SAT solvers to generate the test data. However, these techniques have known limitations such as solving subqueries.In this thesis, we present a novel search-based approach that uses a Genetic Algorithm to generate test data for SQL queries, which overcomes the limitations of previous research.We provide an implementation of our approach, EvoSQL.In our implementation, we instrument a real database to extract all the information necessary for the fitness function. By doing so, we support all queries using standard SQL syntax.We evaluate our approach on 2,135 queries from 4 real-world systems, of which EvoSQL is able to cover over 96% fully. Subject Search-Based Software TestingSQLDatabaseDatabase Testing To reference this document use: http://resolver.tudelft.nl/uuid:3b7e2cc6-4810-44a9-a19a-3cc8a260d495 Part of collection Student theses Document type master thesis Rights © 2017 Jeroen Castelein Files PDF MastersThesis_JeroenCastelein.pdf 423.76 KB Close viewer /islandora/object/uuid:3b7e2cc6-4810-44a9-a19a-3cc8a260d495/datastream/OBJ/view