Localizing SQL Faults in Database Applications
Persistent URL
Author(s)
Clark, Sarah R.
Cobb, Jake
Kapfhammer, Gregory M.
Jones, James A.
Harrold, Mary Jean
Date Issued
January 1, 2011
Abstract
This paper presents a new fault-localization technique designed for applications that interact with a relational database. The technique uses dynamic information specific to the application's database, such as Structured Query Language (SQL) commands, to provide a fault-location diagnosis. By creating statement-SQL tuples and calculating their suspiciousness, the presented method lets the developer identify the database commands and the program statements likely to cause the failures. The technique also calculates suspiciousness for statement-attribute tuples and uses this information to identify SQL fragments that are statistically likely to be responsible for the suspiciousness of that SQL command. The paper reports the results of two empirical studies. The first study compares existing and database-aware fault-localization methods, and reveals the strengths and limitations of prior techniques, while also highlighting the effectiveness of the new approach. The second study demonstrates the benefits of using database information to improve understanding and reduce manual debugging effort.
Journal
Proceedings of the 26th IEEE/ACM International Conference on Automated Software Engineering
Department
Computer Science
Citation
2011
Publisher
IEEE
DOI
10.1109/ASE.2011.6100056
Type of Publication
Research Article
File(s)![Thumbnail Image]()
Name
Kapfhammer_ASE_2011.pdf
Size
310.6 KB
Format
Adobe PDF
Checksum (MD5)
6c9a19dea496ae1b4d61482ad4521f77