Comparative analysis of database types in mobile applications running on the Android operating system
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 liteReferences
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
Statistics
Abstract views: 181PDF downloads: 135
