A characteristic study of performance bugs in application-database interactions

Gu, Mengqi

Permalink

https://hdl.handle.net/2142/92978 Copy

Description

Title

A characteristic study of performance bugs in application-database interactions

Author(s)

Gu, Mengqi

Issue Date

2016-07-21

Director of Research (if dissertation) or Advisor (if thesis)

Xie, Tao

Department of Study

Computer Science

Discipline

Computer Science

Degree Granting Institution

University of Illinois at Urbana-Champaign

Degree Name

M.S.

Degree Level

Thesis

Keyword(s)

• Database applications
• Performance

Abstract

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.

Graduation Semester

2016-08

Type of Resource

text

Permalink

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

Copyright and License Information

Copyright 2016 Mengqi Gu

Owning Collections