SQL and Relational Databases - Reading Assignment

[Dragutin]

[quote=“ivan, post:1, topic:6432”]

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, in NoSQL data is not structured and can change overtime
3. What can you say about the trade-off between scalability and functionality in NoSQL?**
   -More functionality=less performance/less scalability
4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
   -No. If relationships are important than an SQL type database is more suitable.

[vezuchiy]

1. Fast, scalable, limited structural setup, lower operational costs,holds lots of data.
2. No.
3. Structured data that provides more functionality gives less performance, so when the requiremment for less structured data, especially large volumes of data, it is better to choose NoSQL.
4. No it is better to use SQL database.

[VICBTC]

1 NoSQL databases are different than relational databases like MQSql. 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.

One of the advantage of NoSQL database is that they are really easy to scale and they are much faster in most types of operations that we perform on database. There are certain situations where you would prefer relational database over NoSQL, however when you are dealing with huge amount of data then NoSQL database is your best choice.
2. no you do not.
3. there is high availability and no constraints
4. no it is not a good idea

[Zachary21]

1. Easier to scale, higher availability, and they are much faster in most types of operations that perform on databases.

2. No

3. In NoSQL databases you can’t have constraints and joins are not supported making NoSQL more Scalable but less functional.

4. No, but I’m not exactly sure of why with my current knowledge base.

[monymike]

1. What are some of the advantages of NoSQL databases compared to SQL databases?
   You do not need to have a hard and fast structure ready before getting started, you cna just start entering data and structure as you need to adapt to your ongoing needs.Start fast
   Good for large data and growing data needs.High Scalability.
   Data secure if a loss of power or other failure the data returns to the previous consistent state. High Availability

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

3. What can you say about the trade-off between scalability and functionality in NoSQL?
   It is faster at getting you the information you need.
   Structure can be modified as needed more easily than SQL where it is not so.

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

[Grace_KN]

• What are some of the advantages of NoSQL databases compared to SQL databases?
  They are highly scalable because they allow horizontal scaling to cope with growing amount of data. They are also highly available because of the ability to replicate data to previous state in case of failure. Also, high performance reduces overheads.

• Do you have to defined a strict structure for your data in NoSQL?
  No, the structure is defined in the process of inserting or updating data.

• What can you say about the trade-off between scalability and functionality in NoSQL?
  Although NoSQL has high scalability and performance, it offers less functions due to its limited structure features.

• *If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
  Not at all because NoSQL does not support joints and constraints at database level.

[Yovan]

@ivan

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

It has speed, can handle large quanties of transactions, Structure can be restructured.

@ivan

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

No

@ivan

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

when the need for relationships between data aren’t necessary for huge data.

@ivan

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

No

[Hirbed]

Reading Assignment: NoSQL Introduction

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

Has a flexible data structure, can change structure any time , can handle huge amount of data, the main advantages are high scalability, speed and HA (high availability as auto replication in Mongo )

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

no, you don’t need to set up tables, schema and data types .

And the structure can be change on the fly at any time

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

It’s not Atomic as some inconsistency of data can happened, (in ms delays ). So it’s not optimal to use in real-time systems as handling banking transaction, where a double spending theoretically can take place.

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

No, as you can’t have constraints, some inconsistency of data can happened, (in ms delays ).

You have to use SQL ( RDBMS) , a s transaction always are complete (Atomic) none “half update” are allow ed , SQ L transaction is ether rollback:e d o r completed ) , and hav e we ll defined structure.

[ArtCenter1]

• What are some of the advantages of NoSQL databases compared to SQL databases?
  Less restriction in data structure preparation and is scalable
• 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?
  When large amount data is at hand it’s better to use NoSQL even less functionality is provided
• If your data has important relationship that you need to keep track of, is it a good idea to use NoSQL?
  No. It is better to use SOL

[jostrings]

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, because you don’t need to use constrains

3. What can you say about the trade-off between scalability and functionality in NoSQL?
   -In no SQL there is less funcionality, but high scalability, while in SQL databases you have low scalability and high functionality. The lack of need of joins and constrains makes noSQL more scaleable

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

[Op1um]

1. High scalability and high availability.

2. No.

3. NoSQL does not have constraints and does not support joins. Supporting this type of functionality hinders the scalability and performance of the database.

4. No.

[Adam1]

1. Some of the advantages of NoSQL databases high scalability and high availability allowing massive amounts of data storage.

2. Strict structure isnt required for NoSQL databases because its mainly for storing large amounts of data that doesnt really change.

3. I would actually say that the functionality of the NoSQL database is the scalability that allows the mass quantity of data to be stored.

4. No, a SQL database is used for relationship based data.

[Danieljd]

1. What are some of the advantages of NoSQL databases compared to SQL databases?
   Scalability and fast. Works well with a lot 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?
   It is more scalable but is less complex in usecase.
   You can’t have constraints in NoSQL
   Joins are not supported in NoSQL
4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
   No, then SQL is better

[carmen1408]

1. Scalability and high availability.

2. No.

3. You can’t have constraints in No SQL and joins are not supported in NoSQL and less functionality but high performance.

4. No, you have to use SQL database.

[stephenK]

• 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 need for strict structure for data in NoSQL

• What can you say about the trade-off between scalability and functionality in NoSQL?
  If you dealing with dealing with huge amount of data then NoSQL database is the best choice. Because it is really easy to scale and NoSQL databases are much faster in most types of operations that we perform on database. But if you relationships of data is what you need then NoSQL is a better option.
• If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
  NO

1. When you want to store and retrieve huge amount of data.
2. The relationship between the data you store is not that important
3. The data is not structured and changing over time
4. Constraints and Joins support is not required at database level
5. The data is growing continuously and you need to scale the database regular to handle the data.

[Daniel_Fuchs]

1. What are some of the advantages of NoSQL databases compared to SQL databases?
	a. performance and scalability
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. more functionality gives less performance. e.g. functionality like joins or constraints hinders the scalability
4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
	a. no, RDBMS are better for relationships Especially when the data is important, RDBMS ensure consistency and integrity through the ACID principle.

[confusius]

The main advantages are high scalability and high availability.

No, you don’t have to.

RDBMS: It is a structured data that provides more functionality but gives less performance.

NoSQL: Structured or semi structured data, less functionality and high performance.

To keep track you better use the RDBMS database.

[BC_Hallick]

@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. High scalability and high availability, its better speed and performance when you have a lot of data.
2. No
3. Well if you have a live-data that is constant changing so its better to have flexibility and scalability.
   but if you have a fixed data then is better to only have a functionality.
4. No, better SQL

[Laszlo_Leonardo]

1 performance, not building the detailed entries first, scalability=nosql | releationship, atomic, security, lot of data will slow down the performance, structure=MySQL
2 no
3.in less strict assurance of the transactions because not atomic
4. no not at all

[Lacho]

• What are some of the advantages of NoSQL databases compared to SQL databases?
  One of the advantage of NoSQL database is that they are really easy to scale and they are much faster in most types of operations that we perform on database.
  The main advantages are high scalability and high availability

• 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?
  Need of flexibility, trading scale and efficiency

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