2026-09-22T18:46:25Zhttps://ubir.buffalo.edu/oai/request

oai:ubir.buffalo.edu:10477/781172025-09-18T03:15:20Zcom_10477_77914col_10477_77915

Towards Automatic Generation of Smartphone Database Benchmarks through Workload characterization of smartphone databases Mitra, Gourab; 0000-0001-7709-0858 Kennedy, Oliver Computer Science and Engineering computer science M.S. In this dissertation, we introduce the first steps of a framework to create a benchmarking tool which aims to emulate the workloads of Android applications to compare different mobile database management system implementations. First, we describe a clustering scheme where we analyze the query logs to group the SQL queries by semantic similarity. Then, we introduce a session identification technique for mobile query workloads where we identify bursts of activities created by the users' actions. Finally, we elaborate on using these clusters and session information to model common behaviors and unusual patterns. We demonstrate that these common patterns can be used to realistically emulate synthetic workloads created by Android applications, allowing to test the performance of different mobile database management systems. We present results over real world data traces gathered in the wild as well as data traces gathered where users are asked to note their activities. 2018-06-28T20:34:20Z 2018-06-28T20:34:20Z 2018 2018-05-18 10:16:42 Text Thesis http://hdl.handle.net/10477/78117 eng Users of works found in University at Buffalo Institutional Repository (UBIR) are responsible for identifying and contacting the copyright owner for permission to reuse. University at Buffalo Libraries do not manage rights for copyright-protected works and cannot assist with permissions. Copyright retained by author. application/pdf State University of New York at Buffalo