DSC-McMaster-U / mac-FAQ-chatbot

MIT License
4 stars 0 forks source link

DB : Create a No-SQL database for library #15

Open DharmikJoshi05 opened 7 months ago

Yunfei-Ma-McMaster commented 7 months ago

Update: My understanding of SQL and NoSQL in the context of BigQuery

In Google BigQuery, the distinction between SQL and NoSQL does not apply in the same way it does for traditional database systems. BigQuery is fundamentally a fully managed, serverless, and highly scalable data warehouse with an SQL interface for querying data. All tables in BigQuery are accessed using SQL queries. However, the structure of the data within these tables can vary, allowing you to work with data that is more typical of NoSQL databases (like nested and repeated fields, and semi-structured data).

For example related_topics and embedding are of mode REPEATED which indicates that we can work with the data in a NoSQL way.