TY - GEN
T1 - Database-Access Performance Antipatterns in Database-Backed Web Applications
AU - Shao, Shudi
AU - Qiu, Zhengyi
AU - Yu, Xiao
AU - Yang, Wei
AU - Jin, Guoliang
AU - Xie, Tao
AU - Wu, Xintao
N1 - Publisher Copyright:
© 2020 IEEE.
PY - 2020/9
Y1 - 2020/9
N2 - 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.
AB - 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.
KW - characteristic study
KW - database-backed web applications
KW - performance antipatterns
KW - performance bugs
UR - http://www.scopus.com/inward/record.url?scp=85096705571&partnerID=8YFLogxK
UR - http://www.scopus.com/inward/citedby.url?scp=85096705571&partnerID=8YFLogxK
U2 - 10.1109/ICSME46990.2020.00016
DO - 10.1109/ICSME46990.2020.00016
M3 - Conference contribution
AN - SCOPUS:85096705571
T3 - Proceedings - 2020 IEEE International Conference on Software Maintenance and Evolution, ICSME 2020
SP - 58
EP - 69
BT - Proceedings - 2020 IEEE International Conference on Software Maintenance and Evolution, ICSME 2020
PB - Institute of Electrical and Electronics Engineers Inc.
T2 - 36th IEEE International Conference on Software Maintenance and Evolution, ICSME 2020
Y2 - 27 September 2020 through 3 October 2020
ER -