Pocket data: The need for TPC-mobile

Oliver Kennedy; Jerry Ajay; Geoffrey Challen; Lukasz Ziarek

doi:10.1007/978-3-319-31409-9_2

Pocket data: The need for TPC-mobile

Oliver Kennedy, Jerry Ajay, Geoffrey Challen, Lukasz Ziarek

Research output: Chapter in Book/Report/Conference proceeding › Conference 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 language	English (US)
Title of host publication	Performance Evaluation and Benchmarking
Subtitle of host publication	Traditional to Big Data to Internet of Things - 7th TPC Technology Conference, TPCTC 2015, Revised Selected Papers
Editors	Raghunath Nambiar, Meikel Poess
Publisher	Springer
Pages	8-52
Number of pages	45
ISBN (Print)	9783319314082
DOIs	https://doi.org/10.1007/978-3-319-31409-9_2
State	Published - 2016
Externally published	Yes
Event	7th 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 2015 → Sep 4 2015

Publication series

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

Other

Other	7th TPC Technology Conference on Performance Evaluation and Benchmarking, TPCTC 2015 held in conjunction with 40th International Conference on Very Large Data Bases, VLDB 2015
Country/Territory	United States
City	Kohala Coast
Period	8/31/15 → 9/4/15

Keywords

Android
Client-side
Embedded database
Smartphone
Sqlite

ASJC Scopus subject areas

Theoretical Computer Science
General Computer Science

Online availability

10.1007/978-3-319-31409-9_2

Library availability

Discover UIUC Full Text

Cite this

Kennedy, O., Ajay, J., Challen, G., & Ziarek, L. (2016). Pocket data: The need for TPC-mobile. In R. Nambiar, & M. Poess (Eds.), Performance Evaluation and Benchmarking: Traditional to Big Data to Internet of Things - 7th TPC Technology Conference, TPCTC 2015, Revised Selected Papers (pp. 8-52). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 9508). Springer. https://doi.org/10.1007/978-3-319-31409-9_2

Pocket data: The need for TPC-mobile. / Kennedy, Oliver; Ajay, Jerry; Challen, Geoffrey et al.
Performance Evaluation and Benchmarking: Traditional to Big Data to Internet of Things - 7th TPC Technology Conference, TPCTC 2015, Revised Selected Papers. ed. / Raghunath Nambiar; Meikel Poess. Springer, 2016. p. 8-52 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 9508).

Research output: Chapter in Book/Report/Conference proceeding › Conference contribution

Kennedy, O, Ajay, J, Challen, G & Ziarek, L 2016, Pocket data: The need for TPC-mobile. in R Nambiar & M Poess (eds), Performance Evaluation and Benchmarking: Traditional to Big Data to Internet of Things - 7th TPC Technology Conference, TPCTC 2015, Revised Selected Papers. Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), vol. 9508, Springer, pp. 8-52, 7th 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, 8/31/15. https://doi.org/10.1007/978-3-319-31409-9_2

Kennedy O, Ajay J, Challen G, Ziarek L. Pocket data: The need for TPC-mobile. In Nambiar R, Poess M, editors, Performance Evaluation and Benchmarking: Traditional to Big Data to Internet of Things - 7th TPC Technology Conference, TPCTC 2015, Revised Selected Papers. Springer. 2016. p. 8-52. (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)). doi: 10.1007/978-3-319-31409-9_2

Kennedy, Oliver ; Ajay, Jerry ; Challen, Geoffrey et al. / Pocket data : The need for TPC-mobile. Performance Evaluation and Benchmarking: Traditional to Big Data to Internet of Things - 7th TPC Technology Conference, TPCTC 2015, Revised Selected Papers. editor / Raghunath Nambiar ; Meikel Poess. Springer, 2016. pp. 8-52 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).

@inproceedings{12690e51f84a4cfb9169d3559550e905,

title = "Pocket data: The need for TPC-mobile",

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.",

keywords = "Android, Client-side, Embedded database, Smartphone, Sqlite",

author = "Oliver Kennedy and Jerry Ajay and Geoffrey Challen and Lukasz Ziarek",

note = "Publisher Copyright: {\textcopyright} Springer International Publishing Switzerland 2016.; 7th TPC Technology Conference on Performance Evaluation and Benchmarking, TPCTC 2015 held in conjunction with 40th International Conference on Very Large Data Bases, VLDB 2015 ; Conference date: 31-08-2015 Through 04-09-2015",

year = "2016",

doi = "10.1007/978-3-319-31409-9_2",

language = "English (US)",

isbn = "9783319314082",

series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",

publisher = "Springer",

pages = "8--52",

editor = "Raghunath Nambiar and Meikel Poess",

booktitle = "Performance Evaluation and Benchmarking",

address = "Germany",

}

TY - GEN

T1 - Pocket data

T2 - 7th TPC Technology Conference on Performance Evaluation and Benchmarking, TPCTC 2015 held in conjunction with 40th International Conference on Very Large Data Bases, VLDB 2015

AU - Kennedy, Oliver

AU - Ajay, Jerry

AU - Challen, Geoffrey

AU - Ziarek, Lukasz

N1 - Publisher Copyright: © Springer International Publishing Switzerland 2016.

PY - 2016

Y1 - 2016

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

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

KW - Android

KW - Client-side

KW - Embedded database

KW - Smartphone

KW - Sqlite

UR - http://www.scopus.com/inward/record.url?scp=84961645031&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84961645031&partnerID=8YFLogxK

U2 - 10.1007/978-3-319-31409-9_2

DO - 10.1007/978-3-319-31409-9_2

M3 - Conference contribution

AN - SCOPUS:84961645031

SN - 9783319314082

T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

SP - 8

EP - 52

BT - Performance Evaluation and Benchmarking

A2 - Nambiar, Raghunath

A2 - Poess, Meikel

PB - Springer

Y2 - 31 August 2015 through 4 September 2015

ER -

Pocket data: The need for TPC-mobile

Abstract

Publication series

Other

Keywords

ASJC Scopus subject areas

Online availability

Library availability

Related links

Fingerprint

Cite this