Title :
Database-Aware Fault Localization for Dynamic Web Applications
Author :
Hung Viet Nguyen ; Hoan Anh Nguyen ; Tung Thanh Nguyen ; Nguyen, Tuan N.
Author_Institution :
Electr. & Comput. Eng. Dept., Iowa State Univ., Ames, IA, USA
Abstract :
Localizing and fixing software faults is an important maintenance task. In a dynamic Web application, localizing the faults is challenging due to its dynamic nature and the interactions between the application and databases. The faults could occur in the statements in the host program or inside the queries that are sent from the application to be executed in the database engines. This paper presents SQLook, a novel database- aware fault localization method that is able to locate output faults in PHP statements of a dynamic Web application as well as in SQL queries. In SQLook, a PHP interpreter is instrumented to execute an SQL query and to monitor the evaluation of those SQL predicates to determine if they affect the output process of individual data records. It performs row-based slicing across PHP statements and SQL queries to record the entities that are involved in the output of each data row. Our empirical evaluation shows that SQLook can achieve higher accuracy than the state- of-the-art database-aware fault localization approach.
Keywords :
Internet; SQL; database management systems; program slicing; software engineering; software fault tolerance; PHP interpreter; SQL queries; SQLook; database engines; database- aware fault localization method; database-aware fault localization; dynamic Web applications; row-based slicing across; software faults; software maintenance task; Accuracy; Databases; Educational institutions; Engines; Instruments; Measurement; Monitoring; Database-aware; Dynamic Web; Fault Localization;
Conference_Titel :
Software Maintenance (ICSM), 2013 29th IEEE International Conference on
Conference_Location :
Eindhoven
DOI :
10.1109/ICSM.2013.71