* ICSE 2018 *
Sun 27 May - Sun 3 June 2018 Gothenburg, Sweden
Fri 1 Jun 2018 09:20 - 09:40 at J2 room - Performance and Maintenance Chair(s): Miryung Kim

Many web applications use databases for persistent data storage, and using Object Relational Mapping (ORM) frameworks is a common way to develop such database-backed web applications. Unfortunately, developing efficient ORM applications is challenging, as the ORM framework hides the underlying database query generation and execution. This problem is becoming more severe as these applications need to process an increasingly large amount of persistent data. Recent research has targeted specific aspects of performance problems in ORM applications. However, there has not been any systematic study to identify common performance antipatterns in real-world such applications, how they affect resulting application performance, and remedies for them. In this paper, we try to answer these questions through a comprehensive study of 12 representative real-world ORM applications. We generalize 9 ORM performance anti-patterns from more than 200 performance issues that we obtain by studying their bug-tracking systems and profiling their latest versions. To prove our point, we manually fix 64 performance issues in their latest versions and obtain a median speedup of 2× (and up to 39× max) with fewer than 5 lines of code change in most cases. Many of the issues we found have been confirmed by developers, and we have implemented ways to identify other code fragments with similar issues as well.

Fri 1 Jun
Times are displayed in time zone: (GMT+02:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna change

09:00 - 10:30: Technical Papers - Performance and Maintenance at J2 room
Chair(s): Miryung KimUniversity of California at Los Angeles, USA
icse-2018-Technical-Papers09:00 - 09:20
Yingfei XiongPeking University, Xinyuan Liu, Muhan Zeng, Lu ZhangPeking University, Gang Huang
icse-2018-Technical-Papers09:20 - 09:40
Research paper
Junwen YangUniversity of Chicago, Cong Yan, Pranav Subramaniam, Shan LuUniversity of Chicago, Alvin CheungUniversity of Washington
icse-2018-Technical-Papers09:40 - 10:00
Zhifei Chen, Bihuan ChenFudan University, Lu Xiao, Xiao WangPurdue University, USA, Lin Chen, Yang LiuNanyang Technological University, Singapore, Baowen Xu
icse-2018-Journal-first-papers10:00 - 10:20
Muhammad Moiz ArifConcordia University, Montreal, Canada, Weiyi ShangConcordia University, Canada, Emad ShihabConcordia University
icse-2018-Technical-Papers10:20 - 10:30