Database-Access Performance Antipatterns in Database-Backed Web Applications

Shudi Shao, Zhengyi Qiu, Xiao Yu, Wei Yang, Guoliang Jin, Tao Xie, Xintao Wu

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

Database-backed web applications are prone to performance bugs related to database accesses. While much work has been conducted on database-access antipatterns with some recent work focusing on performance impact, there still lacks a comprehensive view of database-access performance antipatterns in database-backed web applications. To date, no existing work systematically reports known antipatterns in the literature, and no existing work has studied database-access performance bugs in major types of web applications that access databases differently.To address this issue, we first summarize all known database-access performance antipatterns found through our literature survey, and we report all of them in this paper. We further collect database-access performance bugs from web applications that access databases through language-provided SQL interfaces, which have been largely ignored by recent work, to check how extensively the known antipatterns can cover these bugs. For bugs not covered by the known antipatterns, we extract new database-access performance antipatterns based on real-world performance bugs from such web applications. Our study in total reports 24 known and 10 new database-access performance antipatterns. Our results can guide future work to develop effective tool support for different types of web applications.

Original languageEnglish (US)
Title of host publicationProceedings - 2020 IEEE International Conference on Software Maintenance and Evolution, ICSME 2020
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages58-69
Number of pages12
ISBN (Electronic)9781728156194
DOIs
StatePublished - Sep 2020
Event36th IEEE International Conference on Software Maintenance and Evolution, ICSME 2020 - Virtual, Adelaide, Australia
Duration: Sep 27 2020Oct 3 2020

Publication series

NameProceedings - 2020 IEEE International Conference on Software Maintenance and Evolution, ICSME 2020

Conference

Conference36th IEEE International Conference on Software Maintenance and Evolution, ICSME 2020
CountryAustralia
CityVirtual, Adelaide
Period9/27/2010/3/20

Keywords

  • characteristic study
  • database-backed web applications
  • performance antipatterns
  • performance bugs

ASJC Scopus subject areas

  • Software
  • Safety, Risk, Reliability and Quality
  • Modeling and Simulation

Fingerprint Dive into the research topics of 'Database-Access Performance Antipatterns in Database-Backed Web Applications'. Together they form a unique fingerprint.

Cite this