February 2018
Intermediate to advanced
246 pages
6h 3m
English
At first, one might be tempted to go with NoSQL because then we don't need to worry about structuring our data and join queries. However, it is important to realize that, instead of writing these queries in SQL form, we will instead be retrieving all the data into the user space, that is, the program, and then write the manual join queries within the program.
Instead, if we rely upon relational databases, we can be assured of smaller storage space, more efficient join queries, and data with well-defined schemas. All relational databases and some of the NoSQL databases provide indexing, which also helps in optimizing for faster search queries. However, one major drawback of relational databases with using ...
Read now
Unlock full access