Development of SQL and NoSQL Database Integration Using Query Direct Access and Change Data Capture Approaches in an Android Application

One implementation of a hybrid database is in Android applications. In the context of the dynamic and diverse development of Android applications, a strategic approach to selecting database technology is essential. The researchers attempted to integrate SQL and NoSQL databases in an Android application to simplify the utilization of physical servers, reduce costs, and enhance response time and application scalability. This development leverages Firebase Cloud Server for NoSQL and a single server for SQL, thus saving memory usage by storing NoSQL in the cloud and SQL and local storage. This improvement is deployed in a student learning style data application with the goal of improving the application’s performance in recording students’ learning styles. With a more optimized and faster database, animations and images in Augmented Reality and Virtual reality applications can be displayed more quickly and without delay. The proposed method consists of an architecture integrating SQL databases on a local server and NoSQL on Firebase Firestore, implementing a query direct access and change data capture approach. The testing results showed that the execution time for CDC was 5 minutes and 38 seconds, whereas for QDA, the rendering time of the application interface was 1 minute and 45 seconds. Furthermore, all applications using SQL and NoSQL database types were successfully executed on various Android versions, ranging from Android 8 to Android 11.