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.
References
Udział w rynku systemów operacyjnych na świecie w roku 2024, https://gs.statcounter.com/os-market-share, [12.02.2024].
Statystyki użycia systemu operacyjnego Android w roku 2024, https://www.businessofapps.com/data/android-statistics, [13.02.2024].
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].
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].
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.
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.
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.
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.
Oficjalna dokumentacja bazy danych SQLite, https://www.sqlite.org/docs.html, [17.02.2024].
Oficjalna dokumentacja bazy danych SnappyDB, https://github.com/nhachicha/SnappyDB, [17.02.2024].
Oficjalne repozytorium bazy danych ObjectBox, https://github.com/objectbox/objectbox-java, [17.02.2024].
Oficjalna dokumentacja bazy danych Couchbase Lite, https://docs.couchbase.com/couchbase-lite/current/index.html, [17.02.2024].