A Performance Comparison of SQLite and Firebase Databases from A Practical Perspective

Abdullah Talha Kabakuş

doi:10.29130/dubited.441672

EN TR

A Performance Comparison of SQLite and Firebase Databases from A Practical Perspective

Abstract

Android is currently the most used mobile operating system all over the world. The two database management systems that Android officially supports are SQLite and Firebase. Android SDK provides built-in packages to let developers implement applications which store its data on these databases. At this point, it is necessary to reveal the performance comparison of these databases. For this reason, an Android application that evaluates several experiments which cover the most used data operations on these databases is implemented within this study. The experimental result indicates that SQLite provides better performance compared to Firebase except deleting data. The performance differences between SQLite and Firebase vary through (1) the type of data operation, and (2) the size of data that is managed.

Keywords

Android,SQLite,Firebase,Mobile operating system,Database

References

[1] B. Popper, “Google announces over 2 billion monthly active devices on Android,” The Verge, 2017. [Online]. Available: https://www.theverge.com/2017/5/17/15654454/android-reaches-2-billion-monthly-active-users. [Accessed: 07-Jul-2018].
[2] D. Burke, “Android: celebrating a big milestone together with you,” Google, 2017. [Online]. Available: https://www.blog.google/products/android/2bn-milestone/. [Accessed: 07-Jul-2018].
[3] “Smartphone OS global market share 2009-2017,” Statista, 2018. [Online]. Available: https://www.statista.com/statistics/266136/global-market-share-held-by-smartphone-operating-systems/. [Accessed: 07-Jul-2018].
[4] Padmini, Android App Development: A Complete Tutorial For Beginners. Educreation Publishing, 2016.
[5] P. K. Dixit, Android. Vikas, 2016. [6] S. Hashimi, S. Komatineni, and D. MacLean, Pro Android 3. Apress, 2011.
[7] I. Krajci and D. Cummings, Android on x86 : an introduction to optimizing for Intel architecture, 1st ed. Apress, 2013.
[8] “Save data using SQLite | Android Developers.” [Online]. Available: https://developer.android.com/training/data-storage/sqlite. [Accessed: 05-Jul-2018].
[9] P. Mainkar, Expert Android Programming: Master skills to build enterprise grade Android applications, 1st ed. Birmingham, UK: Packt Publishing, 2017.
[10] E. Obugyei and N. Raman, Learning Kotlin by building Android Applications: Explore the fundamentals of Kotlin while building real-world Android applications. Packt Publishing, 2018.
[11] D. Bartholomew, “SQL vs. NoSQL,” Linux J., vol. 2010, no. 195, pp. 54–59, 2010.

[12] Y. Li and S. Manoharan, “A performance comparison of SQL and NoSQL databases,” in IEEE Pacific RIM Conference on Communications, Computers, and Signal Processing - Proceedings, 2013, pp. 15–19.
[13] M. Carro, “NoSQL Databases,” CoRR, vol. abs/1401.2, 2014.
[14] J. D. Cook, “ACID versus BASE for database transactions,” 2009. [Online]. Available: https://www.johndcook.com/blog/2009/07/06/brewer-cap-theorem-base/. [Accessed: 07-Jul-2018].
[15] S. K. Gajendran, “A Survey on NoSQL Databases,” 2012.
[16] D. Pritchett, “Base: an Acid Alternative,” Queue, vol. 6, no. 3, pp. 48–55, 2008.
[17] N. Leavitt, “Will NoSQL Databases Live Up to Their Promise?,” Computer (Long. Beach. Calif)., vol. 43, no. 2, pp. 12–14, 2010.
[18] L. Moroney, The Definitive Guide to Firebase: Build Android Apps on Google’s Mobile Platform. Seattle, WA, USA: Apress, 2017.
[19] N. Chatterjee, S. Chakraborty, A. Decosta, and A. Nath, “Real-time Communication Application Based on Android Using Google Firebase,” Int. J. Adv. Res. Comput. Sci. Manag. Stud., 2018.
[20] R. Das, S. Mondal, and N. Mukherjee, “MoRe-care: Mobile-assisted remote healthcare service delivery,” in 2018 10th International Conference on Communication Systems & Networks (COMSNETS), 2018, pp. 677–681.
[21] S. Sakr, A. Liu, D. M. Batista, and M. Alomari, “A Survey of Large Scale Data Management Approaches in Cloud Environments,” Commun. Surv. Tutorials, IEEE, 2011.
[22] M. Indrawan-Santiago, “Database research: Are we at a crossroad? Reflection on NoSQL,” in Proceedings of the 2012 15th International Conference on Network-Based Information Systems, NBIS 2012, 2012, pp. 45–51.
[23] R. Hecht and S. Jablonski, “NoSQL evaluation: A use case oriented survey,” in 2011 International Conference on Cloud and Service Computing (CSC 2011), 2011, pp. 336–341.
[24] A. Boicea, F. Radulescu, and L. I. Agapin, “MongoDB vs Oracle - Database comparison,” in Proceedings of 3rd International Conference on Emerging Intelligent Data and Web Technologies, EIDWT 2012, 2012, pp. 330–335.
[25] C. Lee and Z. Shih, “A Comparison of NoSQL and SQL Databases over the Hadoop and Spark Cloud Platforms using Machine Learning Algorithms,” in 2018 IEEE International Conference on Consumer Electronics-Taiwan (ICCE-TW), 2018, pp. 1–2.
[26] Z. Parker, S. Poe, and S. V. Vrbsky, “Comparing NoSQL MongoDB to an SQL DB,” in Proceedings of the 51st ACM Southeast Conference on - ACMSE ’13, 2013.
[27] S. Agarwal and K. Rajan, “Analyzing the performance of NoSQL vs. SQL databases for Spatial and Aggregate queries Analyzing the performance of NoSQL vs. SQL databases for Spatial and Aggregate queries,” in Free and Open Source Software for Geospatial (FOSS4G), 2017.
[28] V. Abramova, J. Bernardino, and P. Furtado, “Which NoSQL Database? A Performance Overview,” Open J. Databases, vol. 1, no. 2, pp. 17–24, 2014.
[29] B. F. Cooper, A. Silberstein, E. Tam, R. Ramakrishnan, and R. Sears, “Benchmarking cloud serving systems with YCSB,” in Proceedings of the 1st ACM symposium on Cloud computing - SoCC ’10, 2010, pp. 143–154.

Details

Primary Language

English

Subjects

Engineering

Journal Section

Research Article

Authors

Abdullah Talha Kabakuş ^*
Türkiye

Publication Date

January 31, 2019

Submission Date

July 8, 2018

Acceptance Date

November 5, 2018

Published in Issue

Year 2019 Volume: 7 Number: 1

DOI

https://doi.org/10.29130/dubited.441672

IZ

https://izlik.org/JA84TP57AT

APA

Kabakuş, A. T. (2019). A Performance Comparison of SQLite and Firebase Databases from A Practical Perspective. Duzce University Journal of Science and Technology, 7(1), 314-325. https://doi.org/10.29130/dubited.441672

AMA

1.Kabakuş AT. A Performance Comparison of SQLite and Firebase Databases from A Practical Perspective. DUBİTED. 2019;7(1):314-325. doi:10.29130/dubited.441672

Chicago

Kabakuş, Abdullah Talha. 2019. “A Performance Comparison of SQLite and Firebase Databases from A Practical Perspective”. Duzce University Journal of Science and Technology 7 (1): 314-25. https://doi.org/10.29130/dubited.441672.

EndNote

Kabakuş AT (January 1, 2019) A Performance Comparison of SQLite and Firebase Databases from A Practical Perspective. Duzce University Journal of Science and Technology 7 1 314–325.

IEEE

[1]A. T. Kabakuş, “A Performance Comparison of SQLite and Firebase Databases from A Practical Perspective”, DUBİTED, vol. 7, no. 1, pp. 314–325, Jan. 2019, doi: 10.29130/dubited.441672.

ISNAD

Kabakuş, Abdullah Talha. “A Performance Comparison of SQLite and Firebase Databases from A Practical Perspective”. Duzce University Journal of Science and Technology 7/1 (January 1, 2019): 314-325. https://doi.org/10.29130/dubited.441672.

JAMA

1.Kabakuş AT. A Performance Comparison of SQLite and Firebase Databases from A Practical Perspective. DUBİTED. 2019;7:314–325.

MLA

Kabakuş, Abdullah Talha. “A Performance Comparison of SQLite and Firebase Databases from A Practical Perspective”. Duzce University Journal of Science and Technology, vol. 7, no. 1, Jan. 2019, pp. 314-25, doi:10.29130/dubited.441672.

Vancouver

1.Abdullah Talha Kabakuş. A Performance Comparison of SQLite and Firebase Databases from A Practical Perspective. DUBİTED. 2019 Jan. 1;7(1):314-25. doi:10.29130/dubited.441672

Cited By

performance analysis of a cloud database on mobile devices

Journal of Computer Sciences Institute

https://doi.org/10.35784/jcsi.3798

A Performance Comparison of SQLite and Firebase Databases from A Practical Perspective

Abstract

Keywords

Pratik Açıdan SQLite ve Firebase Veritabanlarının Bir Performans Karşılaştırması

Abstract

Keywords

References

Details

Primary Language

Subjects

Journal Section

Authors

Publication Date

Submission Date

Acceptance Date

Published in Issue

DOI

IZ

Cite

Cited By

performance analysis of a cloud database on mobile devices