SQL and Relational Databases - Reading Assignment

[Luca86R]

1. NoSQL database are more scalable than SQL database and permit to manage a big amount of data.
2. No
3. Depend on the structure of the data. If you prefer easy structure and scalability you have to use NoSQL database
   4.No

[crusader2]

1. Able to insert and update data on the fly.
   High scalability to deal with large amount of data.
   High availability with auto replication feature that overcomes data failure cases.

2. No.

3. In terms of functionality, RDBMS will be the advantage but with less performance. In terms of scalability, No SQL will have the advantage due to less structured data.

4. No. It is better to use RDBMS (SQL).

[harry]

@ivan

• What are some of the advantages of NoSQL databases compared to SQL databases?
• Do you have to defined a strict structure for your data in NoSQL?
• What can you say about the trade-off between scalability and functionality in NoSQL?
• If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?

1. Some of the advantages of NoSQL are, very easy to scale and fast operation as well as you can insert and update data on the go.
2. No, strict structure is not compatible with the way NoSQL process data.
3. The trade-off between scalability and functionality is important to make decision regarding your project which one is preferable. If you need high perfomance transaction data then consider NoSQL but if need more structure and consistant style then relational database is the one.
4. No, because its not a relationships data base system.

[Alexander_Scholten]

• What are some of the advantages of NoSQL databases compared to SQL databases?
  Scalable & fast
• Do you have to defined a strict structure for your data in NoSQL?
  No
• What can you say about the trade-off between scalability and functionality in NoSQL?
  SQL gives more functionality but less performance.
• If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
  No, go with SQL db.

[Woodz]

1. NoSQL data bases can be used on the fly and do not need to bet set up prior using it. They are a good choice for the large amounts of data and have a high scalability.
2. You do not
3. NoSQL data base is performance & scalability oriented, which is suited for the large amount ever-changing and unstructured data and, therefore, lacks some key functionality that relationship data bases have.
4. No, it is better to use a SQL data base, like in case of a bank, for instance.

[Raulitiu]

1. What are some of the advantages of NoSQL databases compared to SQL databases?
   More efficient and more scalable.

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 is high scalable but not that functional.

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

[SalJoaNoc]

1. High scalability and high availability
2. No strict structure required
3. More scalability with NoSQL but less functionality
4. No better to use SQL

[Jimo]

1. Much easier to scale up and much easier to manage huge amount of data.

2. No, it’s possible to update on the fly.

3. Hi scalability potential but less functionality.

4. Imortant relationsship or constrians you have to use SQL over NoSQL database.

[Rasa]

1. Higher Performance & Scalability

2. No

3. Less functionality means you can’t have constraints in NoSQL and that joins are not supported because it hinders the scalability.

4. No

[C_P]

1.What are some of the advantages of NoSQL databases compared to SQL databases?
Advantages of NoSQL over SQL include the ease of adapting or changing the data at any given time. In addition, NoSQL databases are more scalable as they are speedier to use and the format does not need to be predetermined, unlike SQL.

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? The trade-off is dependent on what the specific requirements are. For example,a reduction of functionality to improve speed and ease of use would be the right fit for certain situations where scaling is valued more, whereas if safety and functionality is the priority, then ease of use and scalability is not the primary focus.

4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
   No. If your data is relational it would be a job for SQL.

[Cryptojunkie]

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

• NoSQL databases ere more scalable and have high availability

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

• With NoSQL there is no strict structure

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

• You would be sacrificing some functionality for more scalability and better performance

4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
   Probably not. In this case you would be better using SQL

[vale]

1. Scalability and availability
2. No
3. SQL gives more functionality but less performance
4. No, it is better to use SQL database

[Ciprian]

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

• scalability
• speed
• can handle large 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?
   Depending on one’s needs he can choose between high performance(scalability) and high availability of data, or high functionality, complex relationships between data

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 SQL

[Hsu_Li]

1. Scalability, speed, large data handling
2. no
3. NoSQL is highly scalable and high performance, RDBMS are more functional and relational.
4. No

[Ho11and]

1. Easy to scale, faster performance, handles large amount of data.
2. NO
3. When large amount of data needs to be stored and retrieved & their relationship is not important it is a worthwhile trade of to use NoSQL.
4. No, RDBMS will be used.

[Bulmers]

1] High scalability and high availability
2] No, can be structured or semi-structured
3] Less functionality for high performance
4] No

[JohnX]

1. High scalability and high avalitbility.
2. No
3. With increased scalability functionality decreases.
4. No

[Maikimais]

1- Is best suited to treat large amounts of data, is scalable and fast. Also is not structured so this can be an advantage for certain kinds of data.
2- No strict structure for the data.
3- In NoSQL in order to gain scalability it sacrifices some functionality like relationships between tables, this relationships must be included in the logic.
4- No, is best to use SQL in that case

[Isaac_Marangoni]

1. NoSQL is apparently “high performance” and faster to scale.
2. No, maybe this is what makes it “scalable” and faster.
3. In most cases you do not need the functionality found in relational databases, but in some industries it is crucial such as Banking
4. No it is not.

[begood]

1. High escability, high availability, less needs to define and structure data.
2. No
   3.Trade off between security & large amount of data needs to be quickly stored and where relationships between data is not needed.
   4.No