Data storage model in low-cost mobile applications

I Made Sukarsa (Information Technology Department, Udayana University)
I Kadek Ari Melinia Antara (Information Technology Department, Udayana University)
Putu Wira Buana (Information Technology Department, Udayana University)
I Putu Agung Bayupati (Information Technology Department, Udayana University)
Ni Wayan Wisswani (Department of Informatic Management, Bali State Polytechnic)
Dina Wahyuni Puteri (Information Technology Department, Udayana University)

Indonesian Journal of Electrical Engineering and Computer Science
Vol 28, No 2: November 2022

Mobile applications that have data transactions between users require a database relational database management system (RDBMS) and RESTful API operating on the hosting service so that all users can access the data. Renting a hosting service is not cheap and creating a RESTful API takes plenty of time. As an alternative to hosting, a free version of the Cloud Firestore service gives full access rights to the database and has an application programming interface (API) to manage data or access data. However, the free version of Cloud Firestore has limitations in terms of storage capacity, read, write, and delete processes. Therefore, redesigning process of the database was carried out into a low-cost version of the database model consisting of SQLite database and a low-cost version of the NoSQL database to overcome this problem. The goal is to reduce storage space usage and read, write, and delete processing on Cloud Firestore. The low-cost version of the database was tested with 6,030 data. The results obtained were savings of 47.27% storage usage, 83.08% write usage, 91.26% read process usage, and 83.19% delete process usage compared to the test results of the relational database model.