A performance analysis of a cloud database on mobile devices
Sylwester Kot
sylwester.kot@pollub.edu.plLublin University of Technology (Poland)
Jakub Smołka
Lublin University of Technology (Poland)
Abstract
The article presents a performance analysis of Firebase cloud database. Two services, namely Realtime Database and Cloud Firestore, are examined, and their query speed are compared to those of the local SQLite database. Basic CRUD operations were examined, taking into account the number of records in the database, the size of individual records and the complexity of the database structure. Upon completion of the research, it was concluded that Realtime Database outperforms Cloud Firestore and cloud databases are slower than the local database when it comes to operations on a single record. However, when working with a larger volume of data, cloud database can achieve better results than SQLite. The accuracy of the outcome is also influenced by the stability of the network connection and the distance from the cloud server.
Keywords:
performance, cloud database, Firebase, mobile deviceReferences
W. Al Shehri, Cloud Database Database as a Service, International Journal of Database Management Systems 5(2) (2013) 1-12.
DOI: https://doi.org/10.5121/ijdms.2013.5201
Google Scholar
D. Hammes, H. Medero, H. Mitchell, Comparison of NoSQL and SQL Databases in the Cloud, SAIS 2014 Proceedings (2014) 12-20.
Google Scholar
Y. Li, S. Manoharan, A performance comparison of SQL and NoSQL databases, IEEE Pacific Rim Conference on Communications, Computers and Signal Processing, PACRIM, Victoria, BC, Canada, August 27-August 29, 2013, IEEE (2013) 15-19.
DOI: https://doi.org/10.1109/PACRIM.2013.6625441
Google Scholar
M. Ohyver, J. V. Moniaga, I. Sungkawa, B. E. Subagyo, I. A. Chandra, The Comparison Firebase Realtime Database and MySQL Database Performance using Wilcoxon Signed-Rank Test, Procedia Computer Science 157 (2019) 396-405.
DOI: https://doi.org/10.1016/j.procs.2019.08.231
Google Scholar
C. H. Lee, Z. W. Shih, A Comparison of NoSQL and SQL Databases over the Hadoop and Spark Cloud Platforms using Machine Learning Algorithms, 2018 IEEE International Conference on Consumer Electronics-Taiwan, ICCE-TW, Taichung, Taiwan, May 19-May 21, 2018, IEEE (2018) 1-2.
DOI: https://doi.org/10.1109/ICCE-China.2018.8448621
Google Scholar
A. T. KABAKUŞ, A Performance Comparison of SQLite and Firebase Databases from A Practical Perspective, Düzce Üniversitesi Bilim ve Teknoloji Dergisi 7(1) (2019) 314-325.
DOI: https://doi.org/10.29130/dubited.441672
Google Scholar
D. Inupakutika, G. Rodriguez, D. Akopian, P. Lama, P. Chalela, A. G. Ramirez, On the Performance of Cloud-Based mHealth Applications: A Methodology on Measuring Service Response Time and a Case Study, IEEE Access 10 (2022) 53208-53224.
DOI: https://doi.org/10.1109/ACCESS.2022.3174855
Google Scholar
M. F. Younis, Z. S. Alwan, Monitoring the performance of cloud real-time databases: A firebase case study, 2023 Al-Sadiq International Conference on Communication and Information Technology, AICCIT, Al-Muthana, Iraq, July 4-July 6, 2023, IEEE (2023) 240-245.
DOI: https://doi.org/10.1109/AICCIT57614.2023.10217953
Google Scholar
Usage and limits | Firestore | Firebase, https://firebase.google.com/docs/firestore/quotas?hl=en [15.06.2023]
Google Scholar
Realtime Database Limits | Firebase Realtime Database, https://firebase.google.com/docs/database/usage/limits?hl=en [15.06.2023]
Google Scholar
Authors
Jakub SmołkaLublin University of Technology Poland
Statistics
Abstract views: 195PDF downloads: 232
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
