Remove RATs from Your Code: Automated Optimization of Resource Inefficient Database Writes for Mobile Applications
Developers strive to build feature-filled apps that are responsive and consume as few resources as possible. Most of these apps make use of local databases to store and access data locally. Prior work has found that local database services have become one of the major drivers of a mobile device’s resource consumption. In this paper we propose an approach to reduce the energy consumption and improve runtime performance of database operations in Android apps by optimizing inefficient database writes. Our approach automatically detects database writes that happen within loops and that will trigger inefficient autocommit behaviors. Our approach then uses additional analyses to identify those that are optimizable and rewrites the code so that it is more efficient. We evaluated our approach on a set of marketplace Android apps. In this evaluation, our approach reduced energy and runtime by 25% - 90%, depending on the workload assumption, and needed, on average, thirty-six seconds to analyze and transform each app.
Wed 18 JulDisplayed time zone: Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna change
14:00 - 15:30 | Optimization and PerformanceISSTA Technical Papers at Zurich II Chair(s): Tevfik Bultan University of California, Santa Barbara | ||
14:00 20mTalk | Remove RATs from Your Code: Automated Optimization of Resource Inefficient Database Writes for Mobile Applications ISSTA Technical Papers Yingjun Lyu University of Southern California, Ding Li NEC Labs, William G.J. Halfond University of Southern California | ||
14:20 20mTalk | Badger: Complexity Analysis with Fuzzing and Symbolic Execution ISSTA Technical Papers Yannic Noller Humboldt-Universität zu Berlin, Rody Kersten Synopsys, Inc., Corina S. Păsăreanu NASA Ames Research Center | ||
14:40 20mTalk | Exploiting Community Structure for Floating-Point Precision Tuning ISSTA Technical Papers | ||
15:00 20mTalk | piCoq: Parallel Regression Proving for Large-Scale Verification Projects ISSTA Technical Papers Karl Palmskog University of Texas at Austin, Ahmet Celik University of Texas at Austin, USA, Milos Gligoric University of Texas at Austin | ||
15:20 10m | Q&A in groups ISSTA Technical Papers |