Data Structure Comparison Between MySql Relational Database and Firebase Database NoSql on Mobile Based Tourist Tracking Application

Sudiartha, I K G; Indrayana, I Nyoman Eddy; Suasnawa, I Wayan; Asri, Sri Andriati; Sunu, Putu Wijaya

doi:10.1088/1742-6596/1569/3/032092

Cited by 12 publications

(8 citation statements)

References 6 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…1 𝑑𝑜𝑐𝑢𝑚𝑒𝑛𝑡 × 1000 = 1.000 𝑑𝑜𝑐𝑢𝑚𝑒𝑛𝑡 𝑟𝑒𝑎𝑑𝑠 (10) With 1,000 documents reads per day, the cost will be $0 because it is still under the free daily quota of 50,000 free documents read per day.…”

Section: Document Read Countsmentioning

confidence: 99%

“…Server-side coding is no longer necessary for programmers because firebase has handled it. Because firebase has dealt with the server side, programmers designing client-server applications appear to be coding as if they were writing a stand-alone program (client side) [10]. Google cloud firestore is a not only structured query language (NoSQL), document-based cloud-host database solution.…”

Section: Introductionmentioning

confidence: 99%

“…In many recent studies, there have been many discussions on comparing SQL with NoSQL database performance [10], [16]- [21]. Implement SQL and NoSQL databases in mobile applications, analyzing BIG data's type, pros, cons, characteristics, and features on SQL and NoSQL databases [22]- [24].…”

Section: Introductionmentioning

confidence: 99%

See 2 more Smart Citations

Cloud computing: google firebase firestore optimization analysis

Semma¹,

Ali²,

Saerozi³

et al. 2023

IJEECS

View full text Add to dashboard Cite

Cloud computing is a new paradigm that provides end users with a secure, personalized, dynamic computing environment with guaranteed service quality. One popular solution is Google cloud firestore, a global-scale not only structured query language (NoSQL) document database for mobile and web apps. Recent research on cloud-based NoSQL databases often discusses the difference between them and SQL databases and their performance. However, using cloud-based NoSQL databases such as firestore is tricky without any scientific comparison methodology, and it needs analysis of how its particular systems work. This study aims to discover what is the best design that could be implemented to optimize data read cost, response size, and time regarding the cloud firestore database. In this study, we develop a grade point average (GPA)-report mocking application to assess data read based on our institution’s needs. This application consists of three functions. Add the graduated GPA and students’ names, and view the ten highest GPAs, GPA average, and total graduated students. The finding indicates that aggregating data on the client side or utilizing the Google cloud function trigger, then updating aggregation data in one transaction significantly reduces document read count (cost), response size, and time.

show abstract

Section: Document Read Countsmentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

Cloud computing: google firebase firestore optimization analysis

Semma¹,

Ali²,

Saerozi³

et al. 2023

IJEECS

View full text Add to dashboard Cite

show abstract

“…It is a type of database that allows synchronizing data in real time by storing it in the cloud, unlike other firebase, it does not use tables, much less records. But rather converts them into a JSON format with a password for each user at the same time, allows you to update the Data without the need to enter codes, they are simply saved or updated with the simple fact of being connected to the server [20].…”

Section: ) Firebasementioning

confidence: 99%

Geolocation Mobile Application to Create New Routes for Cyclists

Aguirre¹,

Andrade–Arenas²

2022

IJACSA

View full text Add to dashboard Cite

In Peru in recent decades it has undergone unexpected changes, often generating chaos among the population, such as the excess of vehicles that travel daily on the roads generating pollution. This has led people to seek alternatives, such as the use of bike, as a means of transportation. The objective is develop a mobile application for the creation of alternative routes for cyclists. For them we have carried out a survey of 50 people dedicated to the field of cycling as well as people who do not exercise it in order to collect data, analyze it and create mechanisms that help these users. This application was developed in Android Studio implementing free libraries to achieve its geolocation in a way that provides all the facilities for the cyclist to move. For the process of creating this application, the Scrum methodology was used, the design of the prototype is done in Adobe Photoshop. It was obtained as results of the investigation carried out in the survey that 75% of the people are satisfied with the use of the application, 60% responded defining it as very good and 100% answered yes they would recommend the application.The investigation is of importance, since it would allow as future work the reduction of environmental contamination.

show abstract

“…Orang tua ingin mendapatkan notifikasi jika anak beraktivitas di luar area yang tidak diizinkan. Ini untuk mengurangi kejadian yang tidak diinginkan dari orang tua, terhadap anak-anaknya Kini, teknologi GPS hadir di tengah-tengah kita untuk membantu menentukan posisi suatu benda di bumi [4,5]. Teknologi GPS [6] ini dapat digabungkan dengan pembatasan virtual (geofence) untuk membatasi pergerakan suatu objek di suatu area tertentu [7].…”

Section: Pendahuluanunclassified

Aplikasi Pembatasan Area Virtual (Geofence) Untuk Pemantauan Aktifitas Anak-Anak Menggunakan Smartphone Dan Smart Watch

Indrayana¹,

Sutawinaya²,

Pratiwi³

et al. 2020

View full text Add to dashboard Cite

Pemantauan pergerakan anak-anak sangat dibutuhkan oleh orang tua untuk menghindari hal hal yang tidak diinginkan. Teknologi GPS dapat dimanfaatkan untuk melakukan pengawasan melalui smartphone yang dikombinasikan dengan pembatasan area secara virtual(geofence) untuk meningkatkan pengawasan pada saat orang tua tidak berada di dekat anak-anaknya. Pembatasan area secara virtual ini akan membantu memberikan sinyal otomatis kepada orang tua pada saat anak-anak melakukan pergerakan diluar area yang diijinkan. Aplikasi ini dibangun menggunakan metode Unified System Development Process(USDP) dan menerapkan rumus Haversine untuk menghitung jarak antara 2 posisi di bumi. Rumus Haversine ini digunakan dalam proses mendeteksi apakah suatu objek berada pada area yang diijinkan ataukah tidak. Pembatasan area virtual dalam aplikasi ini menggunakan bentuk lingkaran. Aplikasi ini membutuhkan 2 aktor yaitu aktor orang tua yang bertindak sebagai pemantau dan aktor anak yang bertindak sebagai objek yang dipantau. Orang tua menggunakan smartphone android untuk melihat pergerakan anak melalui google map dan sekaligus untuk mengatur geofence si anak sehingga lebih mudah melakukan pemantauan. Sedangkan si anak menggunakan smartwatch untuk mengirimkan koordinat latitude dan longitude posisinya ke server database firebase. Perangkat smartwatch yang digunakan si anak ini, lebih ringan dan lebih praktis karena dipakai di tangan

show abstract

Data Structure Comparison Between MySql Relational Database and Firebase Database NoSql on Mobile Based Tourist Tracking Application

Cited by 12 publications

References 6 publications

Cloud computing: google firebase firestore optimization analysis

Cloud computing: google firebase firestore optimization analysis

Geolocation Mobile Application to Create New Routes for Cyclists

Aplikasi Pembatasan Area Virtual (Geofence) Untuk Pemantauan Aktifitas Anak-Anak Menggunakan Smartphone Dan Smart Watch

Contact Info

Product

Resources

About