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

Year 2019, Volume: 7 Issue: 1, 314 - 325, 31.01.2019

Abdullah Talha Kabakuş

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

Cited By: 1

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

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

Abstract

Android an itibariyle dünyanın en çok kullanılan mobil işletim sistemidir. Android’in resmi olarak desteklediği
iki veritabanı yönetim sistemi SQLite ve Firebase’dir. Android Yazılım Geliştirme Kit’i, geliştiricilere bu
veritabanınlarında verilerini depolayan uygulamalar geliştirebilmeleri için dahili paketler sunmaktadır. Bu
aşamada, bu veritabanlarının performans karşılaştırmasının açığa çıkartılması gerekmektedir. Bu sebeple, bu
çalışma kapsamında en çok kullanılan veri işlemlerini kapsayan çeşitli deneyleri bu veritabanları üzerinde
yürüten bir Android uygulaması geliştirilmiştir. Deneysel sonuçlar, veri silme dışında SQLite’ın Firebase’e göre
daha iyi performans sağladığını göstermektedir. SQLite ile Firebase arasındaki performans farklılıkları (1) veri
işlem tipine ve (2) yönetilen veri boyutuna bağlı olarak değişkenlik göstermektedir.

Keywords

Android, SQLite, Firebase, Mobil işletim sistemi, Veritabanı

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.