Pocket data: The need for TPC-mobile

Oliver Kennedy, Jerry Ajay, Geoffrey Challen, Lukasz Ziarek

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Abstract

Embedded database engines such as SQLite provide a convenient data persistence layer and have spread along with the applications using them to many types of systems, including interactive devices such as smartphones. Android, the most widely-distributed smartphone platform, both uses SQLite internally and provides interfaces encouraging apps to use SQLite to store their own private structured data. As similar functionality appears in all major mobile operating systems, embedded database performance affects the response times and resource consumption of billions of smartphones and the millions of apps that run on them—making it more important than ever to characterize smartphone embedded database workloads. To do so, we present results from an experiment which recorded SQLite activity on 11 Android smartphones during one month of typical usage. Our analysis shows that Android SQLite usage produces queries and access patterns quite different from canonical server workloads. We argue that evaluating smartphone embedded databases will require a new benchmarking suite and we use our results to outline some of its characteristics.

Original languageEnglish (US)
Title of host publicationPerformance Evaluation and Benchmarking
Subtitle of host publicationTraditional to Big Data to Internet of Things - 7th TPC Technology Conference, TPCTC 2015, Revised Selected Papers
EditorsRaghunath Nambiar, Meikel Poess
PublisherSpringer-Verlag Berlin Heidelberg
Pages8-52
Number of pages45
ISBN (Print)9783319314082
DOIs
StatePublished - Jan 1 2016
Externally publishedYes
Event7th TPC Technology Conference on Performance Evaluation and Benchmarking, TPCTC 2015 held in conjunction with 40th International Conference on Very Large Data Bases, VLDB 2015 - Kohala Coast, United States
Duration: Aug 31 2015Sep 4 2015

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume9508
ISSN (Print)0302-9743
ISSN (Electronic)1611-3349

Other

Other7th TPC Technology Conference on Performance Evaluation and Benchmarking, TPCTC 2015 held in conjunction with 40th International Conference on Very Large Data Bases, VLDB 2015
CountryUnited States
CityKohala Coast
Period8/31/159/4/15

Keywords

  • Android
  • Client-side
  • Embedded database
  • Smartphone
  • Sqlite

ASJC Scopus subject areas

  • Theoretical Computer Science
  • Computer Science(all)

Fingerprint Dive into the research topics of 'Pocket data: The need for TPC-mobile'. Together they form a unique fingerprint.

Cite this