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.


#45
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
  1. Better performance (for a certain task the NoSQL DB is optimized for)
  2. Horizontal scalability (in a distributed cluster). Easy to add new nodes and replicate comparing to traditional SQL databases.
  1. Do you have to defined a strict structure for your data in NoSQL?

Typically you do not.

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

The general trade-off is described by the CAP theorem. Typically the NoSQL databases give up on the consistency part to achieve better performance and scalability.

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

Most likely the correct answer is supposed to be “do not use NoSQL for such data”. However, I find “a database with consistency trait (as defined in CAP theorem) should be used for such data”. Again, let’s recall dBase, Clipper and FoxPro (they are capable of doing the job but they do not have SQL).


#46
  • What are some of the advantages of NoSQL databases compared to SQL databases?
    Scalability and Performance vs. SQL’s functionality

  • Do you have to defined a strict structure for your data in NoSQL?
    No. NoSQL is scalable and built to expand for changes in structure.

  • What can you say about the trade-off between scalability and functionality in NoSQL?
    It seems that scalability can become functionally sound yet not the other way around. I would rather be able to make small updates and changes along the way since most projects will have variable data. I also feel secure with NoSQL; knowing that the data is replicated with a high performance. The high performance is needed in media and other arenas that carry large volumes of data.

  • If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    In this instance the solidified relationships call for the tight, static structure that SQL can guarantee.


#47
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    High scalability - sharding for the horizontal scaling.
  2. Do you have to defined a strict structure for your data in NoSQL?
    Auto replication (in MangoDB)
  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    Less functionality while higher performance.
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    Nope

#48
  1. scalability, fast response, no need to define the structure.
  2. No
  3. where you have large amount of data and need fast response and relationship is not that important.
  4. No.

#49

1.What are some of the advantages of NoSQL databases compared to SQL databases? A: NoSQL scale easyer, datastruct may change overtime, better for big data amounts to store or retreive.

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

3.What can you say about the trade-off between scalability and functionality in NoSQL? A: Any trade-off must be taken into consideration.

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


#50
  1. High scalability via horizontal scaling, auto replication gives it high availability.
  2. No. There are no constraints nor joins.
  3. It’s appropriate for certain requirements- i.e. high data volume
  4. Absolutely not.

#51
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    no specific data structure needed to define, no 3rd tables, scalable, performing better, faster, good for huge amounts of data
  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?
    You trade off precision at any point in time for performance, esp. in retrieving data. You sacrifice ACID. :-p
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No. Then you use RDBMS.

#52
  1. Some advantages are the ability to scale, performance when handling large amounts of data and not having to prepare the DB through definitions and schemas

  2. No, you do not have to define a strict structure in NoSQL

  3. The trade off is security, and relational functionality. But you gain performance and scaling.

  4. No, if you have important relationships, a RDBMS is better.


#53
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    Quicker, Easier to scale, Less requirement to structure data, easy to scale when data increases.
  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?
    NoSQL relationship provides for greater scalability but reduces functionality. That is the tradeoff .
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No, it is better to use an SQL database.

#54
  1. What are some of the advantages of NoSQL databases compared to SQL databases? - can insert and update data on the fly, dealing with huge amount of data,
  2. Do you have to defined a strict structure for your data in NoSQL? - no, it is semi structured data, less functionality and high performance
  3. What can you say about the trade-off between scalability and functionality in NoSQL? - NoSQL is not geared towards Functionality. It allows for huge amount of data & performance that is growing continuously.
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL? - No, it would be better to use a RDMBS

#55
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    High scalability, high availability.
  2. Do you have to defined a strict structure for your data in NoSQL?
    No you cant, the advantages of noSQL is build in a way of non/semi structured data which have less functionality and high performance.
  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    With less functionality, it reduce the complexity of the database which gives scalability and performance a great boost.
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No, it would be better to use RDMBS.

#56
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    higher speed, compatibility
  2. Do you have to defined a strict structure for your data in NoSQL?
    no, it is semi structured
  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    it is more scalable but less functional. DB type should be determined by requirements
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    RDMB more suitable for this, but it can be implemented on application level.

#57
  1. NOSQL offers high scalability and the ability to store semi-structured data that may change.
  2. No
  3. The tradeoff is that the high scalability is achieved at the expense of lower funtionality.
    4.NO

#58
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    easy to scale and faster in some kind of operation to perform on database, manage huge amount of data
  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?
    we get less functionality, for example no constraints and no Joins, but we get scalability and performance
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No, it is better to use RDBMS