SQL INTERFACE FOR CRUD OPERATIONS ON CLOUD FIRESTORE
Cloud Firestore is a document-oriented NoSQL database developed by Google. Cloud Firestore provides two ways to access data, namely through Firebase Console and Cloud Firestore API. Cloud Firestore API has the disadvantages of specific syntax and limitations for complex queries, while the disadva...
Saved in:
| Main Author: | |
|---|---|
| Format: | Final Project |
| Language: | Indonesia |
| Online Access: | https://digilib.itb.ac.id/gdl/view/74189 |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| Institution: | Institut Teknologi Bandung |
| Language: | Indonesia |
| Summary: | Cloud Firestore is a document-oriented NoSQL database developed by Google.
Cloud Firestore provides two ways to access data, namely through Firebase
Console and Cloud Firestore API. Cloud Firestore API has the disadvantages of
specific syntax and limitations for complex queries, while the disadvantage of
Firebase Console is that data management is less efficient because it must be done
one by one. On the other hand, SQL is a very popular query language and is
capable of performing complex queries.
In this final project, a library has been created to perform SQL queries to Cloud
Firestore. The library will translate SQL queries to Cloud Firestore API and then
execute the queries on the database. The library can perform four statements
namely INSERT, UPDATE, DELETE, and SELECT including some basic clauses
in it. The library also supports some complex query types that Cloud Firestore
API does not support such as JOIN, subquery, and aggregation functions. In this
final project, an application has also been created as a graphical interface of the
library.
The library test results show that SQL queries have provided appropriate results.
The use of SQL queries is also more efficient and makes it easier to manage data
on Cloud Firestore compared to existing methods. Application testing results
show that all features have run well. |
|---|