SQL and Relational Databases - Reading Assignment


#41
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    NoSQL databases are faster when there is less functionality required, It is good when large volumes of growing data is involved.
  2. Do you have to define a strict structure for your data in NoSQL?
    No
  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    NoSQL databases are highly scalable whereas they are limited in functionality. Functionality however can be implemented in the language accessing the data.For example NoSQL doesn’t support ‘joins’ of two or more tables.
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No, RDBMS is the choice

#42
  1. Lower cost and more scalable for large quantities of data that are not relational in nature.
  2. No.
  3. Scalability is better but functionality is lower than RDMS.
  4. No, RDMS would be better.

#43
  1. **What are some of the advantages of NoSQL databases compared to SQL databases?**¨
    higher scalability and better performance

  2. Do you have to defined a strict structure for your data in NoSQL?
    No.

  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    It is very fast, but you can not work with relational data. therefore it is suited for application with a lot of data.

  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No, in that case you should use MySQL


#44
  1. What are some of the advantages of NoSQL databases compared to SQL databases?

Ans : In relational database you need to create the table, define schema, set the data types of fields etc before you can actually insert the data. In NoSQL you don’t have to worry about that, you can insert, update data on the fly.

  1. Do you have to defined a strict structure for your data in NoSQL?

Ans : No, You dont have to defined a strict structure for your data in NoSQL.

  1. What can you say about the trade-off between scalability and functionality in NoSQL?

Ans : Less functionality and High performance.

  1. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?

Ans : No…For relationships …go for SQL.