On automated prepared statement generation to remove SQL injection vulnerabilities

Stephen Thomas,Laurie Williams,Tao Xie
DOI: https://doi.org/10.1016/j.infsof.2008.08.002
IF: 3.9
2009-01-01
Information and Software Technology
Abstract:Since 2002, over 10% of total cyber vulnerabilities were SQL injection vulnerabilities (SQLIVs). This paper presents an algorithm of prepared statement replacement for removing SQLIVs by replacing SQL statements with prepared statements. Prepared statements have a static structure, which prevents SQL injection attacks from changing the logical structure of a prepared statement. We created a prepared statement replacement algorithm and a corresponding tool for automated fix generation. We conducted four case studies of open source projects to evaluate the capability of the algorithm and its automation. The empirical results show that prepared statement code correctly replaced 94% of the SQLIVs in these projects.
What problem does this paper attempt to address?