A characteristic study of performance bugs in application-database interactions

Environmental interactions (e.g., file I/O, network communication, database querying) are common bottlenecks of software applications. These interactions are also prone to performance bugs because developers may not understand the performance implication of the information sent to or from the environment (e.g., a database query sent to a database or a result set returned from the database). As a result, the performance bugs can further magnify the bottlenecks. Understanding the characteristics of these performance bugs is crucial for developers and testers to better address performance problems. Such understanding also provides guidance for researchers and tool vendors to develop effective tool support. However, there has been no study for understanding such characteristics in real-world software. To fill this gap, in this thesis, we present the first empirical study of bug reports for database-related performance bugs collected from popular real- world open-source projects (i.e., BugZilla, DNN, Joomla!, MediaWiki, Word- Press, Simple Machines, and Roundcube). We study common optimization opportunities, types of database-related performance bugs, and difficulties of fixing these bugs. Among the studied bug reports, we identify nine common bug types and seven common fix strategies. We also observe that bugs of certain types require more effort to diagnose and fix. Furthermore, we identify various opportunities for tool support to identify and diagnose these bugs.

Name thesis:degree_name

M.S.

Level thesis:degree_level

Thesis

Discipline thesis:degree_discipline

Computer Science

Grantor

University of Illinois at Urbana-Champaign

Year dc:date

2016

Author dc:creator

• Gu, Mengqi

Contributors dc:contributor

• Xie, Tao

• Database applications
• Performance

Statement dc:rights

• Copyright 2016 Mengqi Gu

Language dc:language

en

Handle dc:identifier

http://hdl.handle.net/2142/92978

OAI identifier oai:identifier

oai:www.ideals.illinois.edu:2142/92978