* 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.

Conference Day
Fri 1 Jun

Displayed time zone: Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna change

09:00 - 10:30
Performance and MaintenanceTechnical Papers / Journal first papers at J2 room
Chair(s): Miryung KimUniversity of California at Los Angeles, USA
09:00
20m
Talk
Identifying Patch Correctness in Test-Based Program Repair
Technical Papers
Yingfei XiongPeking University, Xinyuan Liu, Muhan Zeng, Lu ZhangPeking University, Gang Huang
Pre-print
09:20
20m
Research paper
How not to structure your database-backed web applications: a study of performance bugs in the wild
Technical Papers
Junwen YangUniversity of Chicago, Cong Yan, Pranav Subramaniam, Shan LuUniversity of Chicago, Alvin CheungUniversity of Washington
Pre-print
09:40
20m
Talk
Speedoo: Prioritizing Performance Optimization Opportunities
Technical Papers
Zhifei Chen, Bihuan ChenFudan University, Lu Xiao, Xiao WangPurdue University, USA, Lin Chen, Yang LiuNanyang Technological University, Singapore, Baowen Xu
10:00
20m
Talk
Empirical Study on the Discrepancy between Performance Testing Results from Virtual and Physical Environments
Journal first papers
Muhammad Moiz ArifConcordia University, Montreal, Canada, Weiyi ShangConcordia University, Canada, Emad ShihabConcordia University
10:20
10m
Talk
Q&A in groups
Technical Papers