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.
The ever-growing volume of data generated by Internet of Things (IoT) devices necessitates efficient storage and retrieval mechanisms. This paper proposes a data collection system tailored to ...accommodate the unique characteristics of IoT data. The system aimed at optimizing the storage space within the Firestore, a NoSQL schemeless cloud-based database, by implementing the data binning technique, grouping similar values and replacing the original data with its group name, and the GZIP lossless data compression technique to enhance data retrieval performance to dynamic web pages. The proposed data storage scheme comprises two collections: the Temporary Collection, where formatted data of IoT devices is temporarily stored every one-second interval, and the Archived Collection, where data older than one hour is compressed and archived. We also developed a web-based dashboard to visualize the data of the past hour by extracting a dataset from the Temporary Collection, while historical data is retrieved by decompressing data from the Archived Collection only. Experimental results reveal a compression ratio of 4.538:1 and a space-saving ratio of 0.789, promising substantial cost savings on cloud-based platforms by reducing data size for storage and transmission. With a reasonable decompression time of 11.26 milliseconds and a significantly lower response time of 130.2 milliseconds compared to 1916.36 milliseconds of test cases, the proposed system remarkably improves real-time data processing, contributing to enriched user experiences and informed decision-making within the IoT web-based dashboard.
Participation plays a key role in the classroom culture. When calling out the students' names at the beginning and end of a lecture, lecturers may miss a student, or someone may respond several times ...to substitute their peers. Face identification can be difficult when using low-definition video and other information systems with the assistance of facial recognition technologies. This necessitates the need to develop a novel device to quickly and accurately identify human faces from images and videos. Many algorithms and techniques have been recently developed to improve the facial recognition accuracy. Deep learning has been recently implemented in various real-time applications to identify and perceive multiple faces at the same time. When it comes to computers, however, it is unrealistic to attempt any of the human identity. The identification of the human identity is a critical aspect of biometrics. The biometric results are consistent with human characteristics. Remote and applied facial expressions can be used to enhance the results. Computers that identify and recognize faces can be used for a variety of purposes, including criminal recognition, network surveillance, biometric authentication, and so on. In this paper, an automated system for attendance recognition is proposed.
SQL Interface For CRUD Operations On Cloud Firestore Hidayat Denira, Farhan Nur; Azizah, Fazat Nur
2023 IEEE International Conference on Data and Software Engineering (ICoDSE),
2023-Sept.-7
Conference Proceeding
Google developed Cloud Firestore, a document-oriented NoSQL database. Cloud Firestore data may be accessed in two different ways: first, through the Firebase Console, and second, through the Cloud ...Firestore API. While Firebase Console data management is less efficient because each individual document must be managed individually, Cloud Firestore API has the disadvantages of specific syntax and limitations for complex queries. On the other hand, SQL is a popular query language that can handle complex queries. This paper discusses a library designed to execute SQL queries to Cloud Firestore. The library converts SQL queries into Cloud Firestore API statements, which are subsequently used to run the queries on the database. The library executes INSERT, UPDATE, DELETE, and SELECT SQL-based CRUD (Create, Read, Update, Delete) statements. Additionally, the library includes JOIN, subquery, and aggregate functions, three complex query types that the Cloud Firestore API does not support. We also developed an application as the library's graphical user interface. The results of the library test indicate that SQL queries produced the expected results. Compared to other methods, the usage of SQL queries is easier and more concise to manage data on Cloud Firestore. Application testing results show that all features have run well.
In educational institutions, the performance of the student is directly related to the attendance percentage of the student, which is also the factor that will decide the eligibility of a student to ...write the exams of that particular course. Moreover, recording student attendance manually by teacher intervention is a taxing and time-consuming process if the strength of the class is highTo avoid this, we have implemented an automatic attendance taking system which involves QR codes which are scanned by the student to give their attendance. Biometric authentication and time limited QR codes have been seen as a possible way to avoid fake attendance in a quick and easy manner.
In the tracking system developed, additional devices that are inserted must be able to provide information on the location of the movement and the condition of the achine to detect any theft ...attempts. The information must be received by the server as soon as possible and then sent to the user. Because the enhancements developed are based on ESP32, a fairly light communication is needed to send all the information obtained from the vehicle to the server. The information received by the server will then be processed to determine whether there is an indication of an attempted theft or not. If there is an attempt at theft, the user will receive a notification that his vehicle is being stolen and the current position information of the vehicle can be seen on his string. Therefore, in this project, a tracking device was developed with communication using the MQTT protocol, Google Cloud IoT Core as an MQTT server, Google Firebase as a database, and firebase as a notifier if an attempted theft was indicated. Testing of the implementation results is carried out by checking the connectivity between the tracker and Google Cloud IoT Core, connectivity between Google Cloud IoT Core and Firebase Firestore, and sending notifications to users. From the results of the tests that have been carried out, information is obtained that the system is able to store 318 location history data and is able to provide notifications to users if there are indications of theft.
This paper conveys the importance of using suitable data visualizations for electrical energy consumption and the effect it carries on reducing said consumption. Data visualization tools construct an ...important pillar in energy micro-moments, i.e., the concept of providing the right information at the right time in the right way for a specific power consumer. Such behavioral change can be triggered with the help of good recommendations and suitable visualizations to convey the right message. A questionnaire is built as a mobile application to evaluate different groups of conventional and novel visualizations. Conventional charts are restricted to bar, line and stacked area charts, while novel visualizations contain heatmap, spiral and appliance-level stacked bar charts. Significant findings gathered from participants' responses indicate that they are slightly inclined towards conventional charts. However, their understanding of the novel charts is better by 8% when the analysis questions are investigated. Finally, a question is answered on whether a group of visualizations should be discarded completely, or some modifications can be applied.
Mobile based Inventory Management System with QR code Kar, Shayantani; Bhimrajka, Shresth; Kumar, Aditya ...
2022 IEEE International Conference on Electronics, Computing and Communication Technologies (CONECCT),
2022-July-8
Conference Proceeding
This work proposes an inventory management system that manages the stock details of a system with various agents and factors to make up an inventory. The ever-evolving era of automation is always ...thriving to replace the conventional way of manual efforts. Nowadays it is extremely important to have an easy access to data in a visually representable form via an app for a user-friendly system. Managing the data manually tends to be enormous and existing systems fail to maintain every inventory in the shipment process accurately. This article focuses on developing an Inventory management system of multiple organizations in a secure manner by having two authentication mechanisms when a user logs in. It mainly stores data with the help of Quick Response (QR) code and keeps an eye on the various activities. The goal is to maintain an error-free record with a track of all the activities of every employee in an organization.
Due to the global epidemic situation of the Coronavirus Disease 2019 (Covid-19), in addition to serving patients with suspected symptoms and sickness from COVID-19, the hospital also provides ...services to patients outside requiring a lot of treatment causing a large number of queues in patients. It takes a long time to wait to see the doctor. The researcher therefore developed a teleconsultation platform. Hence, that patients can talk or seek advice from a doctor without the need to go to the hospital, allow patients to schedule appointments to see a doctor. Also, the patient can talk to the doctor via video calling developed in the system. Moreover, doctors can dispense medicines to patients by mail. To increase the efficiency of the system more and to support a wide range of applications, any devices, real-time data updates, appointment notification via chatbot using Cloud Firestore and Realtime Databases, a NoSQL database, and study the performance gained. The results obtained from the test were satisfactory, with an average tracing server response of 107 ms + 0.14%, and an average handling latency in Thailand at 108 ms.
The need for technological solutions that can help improve interactivity in online learning environments is increasing during the COVID-19 pandemic. One technological solution that has been proven is ...the use of gamified online quizzes such as Kahoot!. One of the issues when using existing third-party platforms is related to integration with existing learning platforms. Institutions that have sufficient resources can solve this by developing solutions that are easily integrated with existing learning platforms. This paper discusses how to use database technology that can handle real-time data updates to develop a gamified online quiz system. In this experimental study, UML use cases and sequence diagrams were used to describe the functional requirements and behavior of the system. Further, entity-relationship model was also used to help the database implementation process. Two database technologies, namely Cloud Firestore and CouchDB, were compared to see how they perform in handling real-time data updates and how much they cost. The comparison results show that Cloud Firestore is better in terms of latency and more cost-effective than CouchDB.