{"id":{"repo_id":"uiuc","oai_identifier":"oai:www.ideals.illinois.edu:2142/92978"},"canonical_url":"https://search.dev.ndltd.org/etd/uiuc/oai:www.ideals.illinois.edu:2142/92978","repository":{"repo_id":"uiuc","name":"University of Illinois - Urbana-Champaign","base_url":"https://www.ideals.illinois.edu/oai-pmh"},"display":{"title":"A characteristic study of performance bugs in application-database interactions","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.","abstract_html":"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.","abstract_has_math":false,"creators":["Gu, Mengqi"],"institution":"University of Illinois at Urbana-Champaign","degree_name":"M.S.","degree_level":"Thesis","degree_discipline":"Computer Science","degree_department":null,"school":null,"contributors":["Xie, Tao"],"advisors":[],"committee_chairs":[],"committee_members":[],"year":2016,"date_issued":"2016-11-10T18:35:35Z","date_published":"2016-11-10T18:35:35Z","updated_at":"2026-07-22T22:26:35Z","subjects":["Database applications","Performance"],"languages":["en"],"rights":["Copyright 2016 Mengqi Gu"],"rights_urls":[],"identifier_entries":[]},"links":{"outbound_url":"http://hdl.handle.net/2142/92978","outbound_label":"Handle","outbound_source":"dc:identifier"},"metadata_groups":[{"id":"people","label":"People","entries":[{"key":"dc:contributor","label":"Contributor","values":["Xie, Tao"]},{"key":"dc:creator","label":"Author","values":["Gu, Mengqi"]}]},{"id":"academic_context","label":"Academic Context","entries":[{"key":"dc:date","label":"Dc Date","values":["2016-11-10T18:35:35Z","2018-11-11T10:15:32Z","2016-07-21","2016-08"]},{"key":"dc:type","label":"Dc Type","values":["text"]},{"key":"thesis:degree_discipline","label":"Discipline","values":["Computer Science"]},{"key":"thesis:degree_level","label":"Degree Level","values":["Thesis"]},{"key":"thesis:degree_name","label":"Degree Name","values":["M.S."]},{"key":"thesis:institution_name","label":"Thesis Institution Name","values":["University of Illinois at Urbana-Champaign"]}]},{"id":"subjects_keywords","label":"Subjects and Keywords","entries":[{"key":"dc:subject","label":"Dc Subject","values":["Database applications","Performance"]}]},{"id":"language_rights","label":"Language and Rights","entries":[{"key":"dc:language","label":"Dc Language","values":["en"]},{"key":"dc:rights","label":"Dc Rights","values":["Copyright 2016 Mengqi Gu"]}]},{"id":"identifiers","label":"Identifiers","entries":[{"key":"dc:identifier","label":"Identifier","values":["http://hdl.handle.net/2142/92978"]}]},{"id":"additional","label":"Additional Metadata","entries":[{"key":"dc:description","label":"Description","values":["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."]},{"key":"dc:format","label":"Dc Format","values":["application/pdf"]},{"key":"dc:title","label":"Title","values":["A characteristic study of performance bugs in application-database interactions"]}]}],"canonical_facts":{"dc:contributor":["Xie, Tao"],"dc:creator":["Gu, Mengqi"],"dc:date":["2016-11-10T18:35:35Z","2018-11-11T10:15:32Z","2016-07-21","2016-08"],"dc:description":["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."],"dc:format":["application/pdf"],"dc:identifier":["http://hdl.handle.net/2142/92978"],"dc:language":["en"],"dc:rights":["Copyright 2016 Mengqi Gu"],"dc:subject":["Database applications","Performance"],"dc:title":["A characteristic study of performance bugs in application-database interactions"],"dc:type":["text"],"thesis:degree_discipline":["Computer Science"],"thesis:degree_level":["Thesis"],"thesis:degree_name":["M.S."],"thesis:institution_name":["University of Illinois at Urbana-Champaign"]},"updated_at":"2026-07-22T22:26:35Z"}