kirancodes.me
To Proof Maintenance & Beyond!
FSE 2018

PowerStation: automatically detecting and fixing inefficiencies of database-backed web applications in IDE

Junwen Yang, Cong Yan, Pranav Subramaniam, Shan Lu, Alvin Cheung

PDFDOI 10.1145/3236024.3264589dblp

Abstract

Modern web applications are built using a myriad of software components, and each of them exposes different programming models (e.g., application logic expressed in an imperative language, database queries expressed using declarative SQL). To improve programmer productivity, Object Relational Mapping (ORM) frameworks have been developed to allow developers build web applications in an object-oriented manner. Despite such frameworks, prior work has found that developers still struggle in developing performant ORM-based web applications. This paper presents PowerStation, a RubyMine IDE plugin for optimizing web applications developed using the Ruby on Rails ORM. Using automated static analysis, PowerStation detects ORM-related inefficiency problems and suggests fixes to developers. Our evaluation using 12 real-world applications shows that PowerStation can automatically detects 1221 performance issues across them. A tutorial on using PowerStation can be found at https://youtu.be/rAV8CGuSj6k.

BibTeX
@inproceedings{Yang-al:FSE18,
  author    = {Junwen Yang and
               Cong Yan and
               Pranav Subramaniam and
               Shan Lu and
               Alvin Cheung},
  title     = {{PowerStation:} automatically detecting and fixing inefficiencies of database-backed web applications in {IDE}},
  booktitle = {{ESEC/SIGSOFT} {FSE}},
  pages     = {884--887},
  publisher = {{ACM}},
  year      = {2018},
}

Related papers