SQL and Relational Databases - Reading Assignment

Blockchain Business Course
#381

Loved your answers. It’s easy to understand. Great work. :clap:

Carlos Z.

1 Like
#382
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
  • Insert data on the fly
  • easy to scale
  • fast
  • huge amounts of data easy to handle

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

  2. What can you say about the trade-off between scalability and functionality in NoSQL?
    NoSQL is less secure, but great for database for high scalability.
    In case of any failure data replicates itself to the previous consistent state.

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

1 Like
#383

1.What are some of the advantages of NoSQL databases compared to SQL databases?
It can deal with large data sets faster than SQL which allows scalability.
NoSQL you do not need to create complex schema.
The developer can change the data format in NoSQL.

2.Do you have to defined a strict structure for your data in NoSQL?
No. It will be contained in a JSON format.

3.What can you say about the trade-off between scalability and functionality in NoSQL?
Since the NoSQL contains data more simple than SQL, the scalability is good.
But at the same time you cannot pull out the datas with complex query.

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.

1 Like
#384
  1. High scalability and high availability. You can use sharding (divide the data between many machines) which is very easy to do an can scale as big as you want basically for scalability. Data can replicate itself to the most recent consistent state, so it’s readily available in case of any failure.
  2. No a strict structure would impede scalability actually
  3. In the case where scalability is more important than functionality then it makes sense to go for NoSQL
  4. No
1 Like
#385

  1. The advantages for NoSQL databases are High Scalability and Availability.

  2. No NoSQL does not need a strictly defined structure.

  3. NoSQL gives improvements in scalability and performance at the expense or a loss in functionality.

  4. No NoSQL is not suited to an application requiring the tracking of important relationships.

1 Like
#386

1: It is low cost, scalable and easy to restructure.
2: No
3: It is useful depending on the type and volume of data that needs storing.
4: No

1 Like
#387
  1. Scalability and performance
  2. No you can change as you go
  3. no possible constraints, joins are not supported,
  4. No better use SQL
1 Like
#388

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    Handle large volumes of data at high speed, easier to scale, no structure 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?
    The trade-off depends on your needs. If the data is relational and require atomicity then SQL DB is recommended but if the data is non relational and large volume choose NOSQL.

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

1 Like
#389

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

Apart from not having to create tables, define schema, set the data types of fields etc before actually inserting the data… 1)high scalability meaning really easy to scale and much faster in most types of operations and 2) high availability meaning that in case of any failure, data replicates itself to the previous consistent state.

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

Nah, data can be inserted and updated on the go.

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

While constraints in NoSQL aren’t possible and joins aren’t supported, these supports actually hinder the scalability of a database. By using a NoSQL database, these functionalities can be implemented at an application level.

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

Probably not, but it depends on the data and whether it needs to be updated or not. For e.g. a bank that needs to keep track of transactions, a relational database system is preferable because it provides consistency and integrity of data by enforcing ACID properties (Atomicity, Consistency, Isolation and Durability ).

1 Like
#390
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    => To overcome the limitations of relational dataabses: With relational databases the structure is predefined, with NoSQL there is no column structure in a table: insert, update, delete data on the fly. Easy scalable, faster.
  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?
    => Easy scalable due structure less, but NoSQL misses constraints, nor joins: must be done at application level.
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    => No.
1 Like
#391

  1. Advantages of NoSQL are high scalability and high availability, and you can insert, update data on the fly.

  2. Strict structure does not need to be defined in NoSQL.

  3. The trade-off between scalability and functionality is that joins and constraints are not supported thus hinders scalability.

  4. No.

1 Like
#392

1 in nosql, just fill in the fields, and in sql you have to choose all the info you want to insert

2 in

3 nosql database is scalable

4 its better on sql

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

One 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. Another advantage is that NoSQL can handle much more data than a Relational database such as SQL.

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

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

NoSQL databases doesn’t have constraints and doesn’t support joins. This being said NoSQL more scalability, and as a result offer less functionality.

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

No, when there is a need for relationships to be drawn upon then it is better to use SQL.

1 Like
#394
  1. No SQL: non relational, low cost, various kinds, easily scaleable
    SQL: Speed, Atomic Transactions (Secure Fail or pass), no coding
  2. No
  3. When large streams of data need to be stored and processed faster it works with no use for relationships value
    4.No, SQL is for relationship data
1 Like
#395

What are some of the advantages of NoSQL databases compared to SQL databases?
• Insert, update data on the fly.
• Easy to scale and faster than SQL.
• Handle large amounts of data. High availability and scales horizontally without losing data.
2. Do you have to defined a strict structure for your data in NoSQL?
No. Hence in the name NoSQL. Data are stored in a JSON format.
3. What can you say about the trade-off between scalability and functionality in NoSQL?
No constraints, larger data sets and doesn’t support joins. This means faster access to the data source.
4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
No. Banking data is a good example where you should use an RDB where as something thats doing IOT or real time timestamping of temp. or heat, NoSQL is more ideal over time.

1 Like
#396

SQL and NoSQL

  1. Some of the advantages of NoSQL databases compared to SQL databases
  • Scalability concerning data volumes
  • Performance for straight forward use cases
  • High availabilty

  1. Do you have to define a strict structure for your data in NoSQL?
    No you don’t.

  2. Trade-off between scalability and functionality in NoSQL
    You don’t have support for joins and constraints as price for scalabilty and performance.

  3. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    Since NoSQL databases don’t guarantee atomicity of transactions and also have way less capability to represent relationships it is not a good idea at all.

1 Like
#397
  1. Scalability and very fast
  2. no
  3. It depends on the use case as NoSQL offers a good scalability but has less functionality in comparison to a SQLDB
  4. No better to use a SQL database
1 Like
#398

  1. Really easy to scale, much faster in most types of operations that we perform on database, no need to define structure and schema of data first before processing data, high availability and high scalability.

  2. No.

  3. The trade-off are the following:
    -Can’t have constraints in NoSQL
    -Joins are not supported in NoSQL

  4. No.

1 Like
#399

Reading Assignment: NoSqL databases (Answers)

  1. High scalability and high availability.
  2. No.
  3. High volume data processing.
  4. Yes.
#400

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

I think you misunderstood the question, are you sure that you will use NoSQL for relationship database?

If you have any more questions, please let us know so we can help you! :slight_smile:

Carlos Z.