2026-09-19T13:29:59Z https://www.ideals.illinois.edu/oai-pmh

oai:www.ideals.illinois.edu:2142/92978 2023-07-11 col_2142_5131 com_2142_5130

Xie, Tao Gu, Mengqi 2016-11-10T18:35:35Z 2016-11-10T18:35:35Z 2018-11-11T10:15:32Z 2016-07-21 2016-08 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. Submission published under a 24 month embargo labeled 'U of I Access', the embargo will last until 2018-08-01 The student, Mengqi Gu, accepted the attached license on 2016-07-21 at 14:18. The student, Mengqi Gu, submitted this Thesis for approval on 2016-07-21 at 14:25. This Thesis was approved for publication on 2016-07-21 at 16:31. DSpace SAF Submission Ingestion Package generated from Vireo submission #10056 on 2016-11-10 at 12:27:38 Made available in DSpace on 2016-11-10T18:35:35Z (GMT). No. of bitstreams: 2 GU-THESIS-2016.pdf: 260125 bytes, checksum: 6b76cc9e1c01d4da42f5aaeca44c988a (MD5) LICENSE.txt: 4206 bytes, checksum: 6223b79b120ebea3fe24e08ecadae708 (MD5) Previous issue date: 2016-07-21 Embargo set by: Seth Robbins for item 95398 Lift date: 2018-11-10T18:35:44Z Reason: Author requested U of Illinois access only (OA after 2yrs) in Vireo ETD system Embargo set by: Seth Robbins for item 95398 Lift date: 2018-11-10T18:37:47Z Reason: Author requested U of Illinois access only (OA after 2yrs) in Vireo ETD system Embargo set by: Seth Robbins for item 95398 Lift date: 2018-11-10T18:39:22Z Reason: Author requested U of Illinois access only (OA after 2yrs) in Vireo ETD system Embargo set by: Seth Robbins for item 95398 Lift date: 2018-11-10T18:43:22Z Reason: Author requested U of Illinois access only (OA after 2yrs) in Vireo ETD system U of I Only Restriction Lifted for Item 95398 on 2018-11-11T10:15:32Z. application/pdf http://hdl.handle.net/2142/92978 en Copyright 2016 Mengqi Gu Database applications Performance A characteristic study of performance bugs in application-database interactions text text Computer Science Computer Science University of Illinois at Urbana-Champaign Thesis M.S.