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.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsReferences
Ahmed, S.: MobiGen: a mobility generator for environment aware mobility model (2009). http://arrow.monash.edu.au/hdl/1959.1/109933
Box, D., Hejlsberg, A.: LinQ: NET language-integrated query. MSDN Developer Centre 89 (2007)
Campbell, A.T., Eisenman, S.B., Lane, N.D., Miluzzo, E., Peterson, R.A., Lu, H., Zheng, X., Musolesi, M., Fodor, K., Ahn, G.-S.: The rise of people-centric sensing. IEEE Internet Comput. 12(4), 12–21 (2008)
Cheung, A., Arden, O., Madden, S., Solar-Lezama, A., Myers, A.C.: StatusQuo: making familiar abstractions perform using program analysis. In: CIDR (2013)
Cooper, B.F., Silberstein, A., Tam, E., Ramakrishnan, R., Sears, R.: Benchmarking cloud serving systems with YCSB. In: SOCC. ACM, New York, NY, USA (2010)
Transaction Processing Performance Council. TPC-C specification. http://www.tpc.org/tpcc/
Transaction Processing Performance Council. TPC-DS specification. http://www.tpc.org/tpcds/
Transaction Processing Performance Council. TPC-H specification. http://www.tpc.org/tpch/
Dittrich, J.: The case for small data management. In: CIDR (2015)
Jeong, S., Lee, K., Lee, S., Son, S., Won, Y.: I/O stack optimization for smartphones. In: USENIX ATC, pp. 309–320. USENIX Association, Berkeley, CA, USA (2013)
Kang, W.-H., Lee, S.-W., Moon, B., Gi-Hwan, O., Min, C.: X-FTL: Transactional FTL for SQLite databases. In: SIGMOD (2013)
Kim, J.-M., Kim, J.-S.: AndroBench: benchmarking the storage performance of android-based mobile devices. In: Sambath, S., Zhu, E. (eds.) Frontiers in Computer Education. AISC, vol. 133, pp. 667–674. Springer, Heidelberg (2012)
Klasnja, P., Consolvo, S., McDonald, D.W., Landay, J.A., Pratt, W.: Using mobile & personal sensing technologies to support health behavior change in everyday life: lessons learned. In: AMIA (2009)
Lam, S.C.K., Wong, K.L., Wong, K.O., Wong, W., Mow, W.H.: A smartphone-centric platform for personal health monitoring using wireless wearable biosensors. In: ICICS, December 2009
Madden, S.R., Franklin, M.J., Hellerstein, J.M., Hong, W.: TinyDB: an acquisitional query processing system for sensor networks. ACM TODS 30(1), 122–173 (2005)
Nandugudi, A., Maiti, A., Ki, T., Bulut, F., Demirbas, M., Kosar, T., Qiao, C., Ko, S.Y., Challen, G.: PhoneLab: a large programmable smartphone testbed. In: SenseMine, pp. 4:1–4:6 (2013)
O’Neil, P., O’Neil, E., Chen, X., Revilak, S.: The star schema benchmark and augmented fact table indexing. In: Nambiar, R., Poess, M. (eds.) TPCTC 2009. LNCS, vol. 5895, pp. 237–252. Springer, Heidelberg (2009)
Owens, M., Allen, G.: SQLite. Springer, Heidelberg (2010)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2016 Springer International Publishing Switzerland
About this paper
Cite this paper
Kennedy, O., Ajay, J., Challen, G., Ziarek, L. (2016). Pocket Data: The Need for TPC-MOBILE. In: Nambiar, R., Poess, M. (eds) Performance Evaluation and Benchmarking: Traditional to Big Data to Internet of Things. TPCTC 2015. Lecture Notes in Computer Science(), vol 9508. Springer, Cham. https://doi.org/10.1007/978-3-319-31409-9_2
Download citation
DOI: https://doi.org/10.1007/978-3-319-31409-9_2
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-31408-2
Online ISBN: 978-3-319-31409-9
eBook Packages: Computer ScienceComputer Science (R0)