SQL and Relational Databases - Reading Assignment

[dbleal]

@ivan

Leave your answers to the questions below in this thread. If you have any questions or you want to discuss something connected to the assignment feel free to do it in this thread as well, but please everything to the topic.

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

• Scalability and the no-need to structure data upfront
• No
• The higher scalability sacrifices the functionality component
• No, you must adopt a RDbMS

[ShreyPanda]

1. What are some of the advantages of NoSQL databases compared to SQL databases?
   SQL databases require you to create the table, define schema, set the data types of fields etc. before actually inserting the data. NoSQL databases of not have this requirement- you can insert/ update data whenever. NoSQL databases are easy to scale and are faster in most types of operations that are performed on a database. NoSQL is ideal when dealing with large amounts of data. There are also various types of NoSQL databases available.

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= high scalability- meaning that when your data is continuously changing/ you need to update the data/ need something flexible- a feature of the NoSQL database is that it can handle the large quantity of data in an efficient manner.

4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
   No, NoSQL is better used for key-value pairs with lots of info. SQL databases are best suited for relationships.

[magicrypto]

1. What are some of the advantages of No SQL databases compared to SQL database?
no structured and and changing over time
low cost
availabiliy
Easily scalable
can store a Hugh amount of data
SQL
we need to define structure and schema of data first and then only we can process the data.
we need to define structure and schema of data first and then only we can process the data.
is compatible with most of the today’s world application.
secure
no coding needed
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?
less functionality than RSBMS and easier scalability

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

[Jean-Sebastien_Neveu]

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

High scalability and high availability.

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?

If the nature of the data is non-relational, or a huge amount of data needs to be stored, or the data does not need to be restructures or changed over time, then NoSQL’s scalability benefits outweigh the lack of functionality.

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

No SQL is better.

[Rickspider]

1. NoSQL can hold more data and access it faster, as it does not need to be stored in order and data can just be “piled” on top of it.

2. No.

3. SQL is more structured, which can make data easier to understand, but requires more effort in the adding of data and fetching of it. NoSQL is less so, which means it can access data and file data faster, but at the cost of structure and some safety.

4. No. SQL works betterr for relationships.

[Gry]

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

More scalability
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?
SQL is more structured and the data in it easier to understand. NoSQL sacrifices a little security for the ability to access data and add data faster.
4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
SQL would be better.

[TheOldOne]

1. What are some of the advantages of NoSQL databases compared to SQL databases?
   quicker and easier to scale, less requirement to structure data and handles massive amounts of data better.
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?
   Structured data gives more functionality but has a lesser performance.
4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
   No

[SDMRDEL7890]

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

   • NoSQL`
     Non-relational
     Low cost
     Various kinds of NoSQL DB available
     Easily scalable
     No need for detailed DB structuring

   *SQL
   Speed
   Well defined global standards
   Atomic transactions - Secure
   No coding needed

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? :

   High Scalability and High Availability

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

   YES

[flrnblock]

1 - NoSQL DB has an higher scalability and availability than SQL DB

2 - No

3 - SQL: Structured and Safe x NoSQL: High Scalability, Availability and quick to implement

4 - No. SQL is way better.

[DevinWiggins]

1. What are some of the advantages of NoSQL databases compared to SQL databases? You do not have to input table information. NoSQL can handle vast amounts of data and is easily scalable.
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? It is an inverse relationship
4. If your data has important relationships that you need to keep track of, is it good to use NoSQL? No, better to go with SQL

[Selim]

Hi everyone,

1. High scalability and high availability
2. No
3. Functionality comes with a cost (performance, it makes it slower), so if you don’t need functionality that much, you can choose noSQL and have a better scalability.
4. In this case no. In that case it is indeed better to use a RDBMS

[HolistikBit]

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

SQL
Speed is compromised in large data
Well defined global standards
Atomic transactions - Secure
No coding needed

NoSQL
Non-relational
Easy scalability
Various kinds of NoSQL DB available
Easily scalable
No need for detailed DB structuring

2. Do you have to defined a strict structure for your data in NoSQL?
   No. Constraints and Joins support is not required at the database level.

3. What can you say about the trade-off between scalability and functionality in NoSQL?
   Although it is not as secure, it is reasonable to use NoSQL for database for high scalability. It also offers high availability, in the case of any failure, data replicates itself to the previous consistent state.

4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
   No, as the data recipient may not be receiving the most up to date consistent state of the data.

[Mroman]

1. NoSQL database does not need to be structured, therefore allows for more flexibility. Just need to start input the data. Along the way the input can change without affecting the table. It helps with huge amount of data or when in the beginning not sure about how to structure them.
2. No, it does not required to have a strict structure.
3. NoSQL works better for non structure database, when there is not relationship between the data.
4. For database that the user want to query for relationship data is better the use of SQL database.

[gunnarseay]

1.) Some advantages of NoSQL databases compared to SQL databases are high scalability, high availability, the ability to retrieve large amounts of data, sharding/preservation of data, and faster operation times for certain retrievals of data.
2.) One does not need to have a defined, strict structure of data in NoSQL. Data can be easily restructured when using a NoSQL database.
3.) The trade-off between scalability and functionality in NoSQL is that while NoSQL databases scale more efficiently and abundantly, constraints and joins become unavailable when restructuring data.
4.) If one’s data has important relationships that must be tracked, then it wouldn’t be a good idea to use NoSQL; an original SQL database, rather, that needs an initial defined structure would be better to use for relational data.

[arminoovic]

NO-SQL
Scalability through horizontal scaling / sharding.
No constraints related to data structure.

SQL
Atomic/Acid-functionalities, therefore highly secure / data integrity
Data consistency
BUT: therefore not that scalable.

2. No. Easy way to store much data, which allows query of data.

3. NoSQL allows you to scale horizontally, through sharding. Therefore it allows you to store many data-sets - which are gathered continuously - as it is not dependent on any specific data structure. When data sets must be stored and small inconsistencies related to data integrity are acceptable - then NoSQL could be an option.

4. No.

[cotts31]

1. What are some of the advantages of NoSQL databases compared to SQL databases? Higher scalability and higher availability

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 provides Structured or semi structured data, less functionality and high performance compared to SQL which gives more functionality but less 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 would be better to use SQL in this scenario

[Capig]

1. What are some of the advantages of NoSQL databases compared to SQL databases?
   A. You can insert, update data on the fly, they are really easy to scale and they are much faster in most types of operations that we perform on database,
   when you are dealing with huge amount of data then NoSQL database is your best choice…
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. Structured or semi structured data, less functionality and high performance.
4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
   A. No

[Leedecker425]

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

• To store and retrieve large amounts of data
• When data is growing it is easy to scale

2) Do you have to defined a strict structure for your data in NoSQL?
No. Constraints and Joins support is not required at the database level.

3) What can you say about the trade-off between scalability and functionality in NoSQL?
Although it is not as secure, it is reasonable to use NoSQL for database for high scalability.
High availability, in the case of any failure, data replicates itself to the previous consistent state.

4) If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
No, as the data recipient may not be receiving the most up to date consistent state of the data.

[zlr1984]

1. What are some of the advantages of NoSQL databases compared to SQL databases?
   Ans: NoSQL is easy to scale, much faster in most types of operations, greater flexibility, high availability to replicate itself against failures

2. Do you have to defined a strict structure for your data in NoSQL?
   Ans: There is no need to define a strict structure for data in NoSQL

3. What can you say about the trade-off between scalability and functionality in NoSQL?
   NoSQL has high scalability which makes it a good tool in certain operations, but it will have less functions like no constraints and no joins

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

[Mohammed_Al_Arab]

1. NoSQL databases are highly scalable and have high availability. They also let you update the structure on the fly, without having fixed structural limitations.

2. No

3. When structure and functionality is not essential, and speed is important, a NoSQL database would be ideal trading off functionality for scalability.

4. No