Comparative analysis of database types in mobile applications running on the Android operating system

Adrian Bartoszek

adrian.bartoszek@pollub.edu.pl
Lublin University of Technology (Poland)

Abstract

The article focused on conducting a detailed comparative analysis of the different types of databases used in mobile applications on the Android platform. The research included four main types of databases: relational (SQLite), key-value (SnappyDB), object-oriented (ObjectBox) and non-relational (Couchbase Lite). The analysis focused on four key operations: writing, reading, editing and deleting data. In addition, the work evaluated each database type in terms of resource consumption, such as RAM and CPU. This research aimed to provide a comprehensive perspective on the performance and efficiency of each database type in the context of mobile applications on the Android platform. The research confirmed that the ObjectBox database has better performance than the other analyzed databases.


Keywords:

sqlite, snappydb, objectbox, couchbase lite

Udział w rynku systemów operacyjnych na świecie w roku 2024, https://gs.statcounter.com/os-market-share, [12.02.2024].
  Google Scholar

Statystyki użycia systemu operacyjnego Android w roku 2024, https://www.businessofapps.com/data/android-statistics, [13.02.2024].
  Google Scholar

Bliższe spojrzenie na 3 najlepsze wbudowane bazy danych: SQLite, RocksDB, and DuckDB, https://hackernoon.com/a-closer-look-at-the-top-3-embedded-databases-sqlite-rocksdb-and-duckdb, [13.02.2024].
  Google Scholar

Jak wybrać wbudowaną bazę danych, https://dev.to/objectbox/embedded-databases-what-is-an-embedded-database-and-how-to-choose-one-27m8, [15.02.2024].
  Google Scholar

K. Wałachowski, G. Kozieł, Comparative analysis of database systems dedicated for Android, Journal of Computer Sciences Institute 15 (2020) 126–132, https://doi.org/10.35784/jcsi.2043.
  Google Scholar

N. Obradovic, A. Kelec, I. Dujlovic, Performance analysis on Android SQLite database, 2019 18th International Symposium INFOTEH-JAHORINA (INFOTEH) (2019) 1-4, https://doi.org/10.1109/INFOTEH.2019.8717652.
  Google Scholar

C. Ferreira, M. Lopes, L. Correia, C. Wanzeller, F. Sa, P. Martins, Database Performance on Android Devices, A Comparative Analysis, 2023 Marketing and Smart Technologies 337 (2023) 261-273, https://doi.org/10.1007/978-981-19-9099-1_18.
  Google Scholar

K. Kussainov, B. Kumalakov, Mobile Data Store Platforms: Test Case based Performance Evaluation, Proceedings of the 8th International Joint Conference on Knowledge Discovery, Knowledge Engineering and Knowledge Management 0IC3K (2016) 95-99, https://doi.org/10.5220/0006032300950099.
  Google Scholar

Oficjalna dokumentacja bazy danych SQLite, https://www.sqlite.org/docs.html, [17.02.2024].
  Google Scholar

Oficjalna dokumentacja bazy danych SnappyDB, https://github.com/nhachicha/SnappyDB, [17.02.2024].
  Google Scholar

Oficjalne repozytorium bazy danych ObjectBox, https://github.com/objectbox/objectbox-java, [17.02.2024].
  Google Scholar

Oficjalna dokumentacja bazy danych Couchbase Lite, https://docs.couchbase.com/couchbase-lite/current/index.html, [17.02.2024].
  Google Scholar

Download


Published
2024-06-30

Cited by

Bartoszek, A. (2024). Comparative analysis of database types in mobile applications running on the Android operating system. Journal of Computer Sciences Institute, 31, 82–88. https://doi.org/10.35784/jcsi.5915

Authors

Adrian Bartoszek 
adrian.bartoszek@pollub.edu.pl
Lublin University of Technology Poland

Statistics

Abstract views: 19
PDF downloads: 6


License

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.