SQL and Relational Databases - Reading Assignment

Blockchain Business Course
#61

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    performance / scalability / high availability (replication)

  2. Do you have to defined a strict structure for your data in NoSQL?
    that is not needed, you can change the structure any time

  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    scalability is high but the tradeoff is that it has less functionality, in SQL db’s it’s the other way around

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

#62

1 nosql doesn’t need structure and is more scalable.
2 No
3 nosql is more scalable but rdbms has more funcionality
4 no

#63
  1. The main advantages are high scalability and high availability.
  2. No
  3. You can’t have constraints in NoSQL and joins are not supported in NoSQL
  4. No
#64
  1. easier to scale, handle huge amounts of data, you can change the structure of your data overtime
  2. no, you can change the structure later
  3. NoSQL has structured or semi structured data, less functionality and high performance
  4. no
#65

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    It can store and access high volumens of semi structured or unstructured data, very quickly.

  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 does not allow you to use Joins or Constraints at the database level. It is easily scalable though and has high availability.

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

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

NoSQL you can insert and update data anytime. NoSQL can Deal with large amounts of data. Database response is faster due to flexibility

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

No you don’t it is flexible unlike relational databases where you would need to define the structure before hand.

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

NoSQL databases have high scalability and preserves data. More resources are used to handle more data. Using horizontal scaling makes it easy for data to be handled more efficiently. However functionality will be less.

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

It isn’t a good idea to use NoSQL to store relational data since this is not a relational database structure.

#67
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    Can process efficiently large amounts of data. Horizontaly scalable. No need for relational structure.
  2. Do you have to defined a strict structure for your data in NoSQL?
    No you don’t.
  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    It can not perform complex functions because of lack of relation functions so joins are a no go.
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No.
#68

1)-more rapide- in most cases;
-more flexible- you do not have to know what structure it will have upfront
-works with JSON format that most application use as data format
-easy to scale
-perfect to work with huge number of data
2)no- it has to have eky-value pair and document format but other then that it is quite flexible and open
3)NoSQL gives huge advantage of scalability for the price of less fuctinality
4)no, it is better to use relational db in that case

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

Scalability and performance; Doesn’t require explicit data structures and relationships defined in advance.

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

NoSQL requires functionality (i.e. relationships) to be managed at the application level but the trade-off is that is able to handle large volumes of data that changing and/or semi-structured.

  • 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 an SQL database

#70

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    NoSQl: High scalable and performance. Can work with 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?
    Less 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?
    No, SQL will be better

#71

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

  • What are some of the advantages of NoSQL databases compared to SQL databases? High scalability and 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? No constraint. Can store and retrieve huge amount of data
  • If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL? No
#72
    • No fix structure needed --> easier to use and to
      update
    • Very fast, if you have to use a lot of data
    • high scalability, therefore more efficient
    • high availability

  2. No strict defined structure needed

  3. NOSQL has a high scalability and good
    performance but not so great functionality( eg: no
    constraints, no support for joins…)

  4. If the data has important relationships, that its a bad idea to use NoSQL.

#73

*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.

*Do you have to defined a strict structure for your data in NoSQL?
In NoSQL you don’t have to define a strict data structure. you can insert,
update data on the fly.

*What can you say about the trade-off between scalability and functionality in NoSQL?
Structured or semi structured data, less functionality and high performance.

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

#74
  1. Faster and simple.
  2. No
  3. Less secure
  4. No
#75
  1. high scalability and high availability.
  2. No, the data is can be non/semi structured or structured
  3. You can process a huge volume of data with high performance but there will be less functionality and relationships between data
  4. No
#76

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    Scalability and 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?
    You have high scalability but lower functionality (e.g. no constraints or relationships)

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

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

Cost, Speed, simplicity and scale-ability

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

Nope

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

As database functionality increases, performance appears to decreases. So if functionality is the concern or the data exhibits complex relationships a relational database is a better choice. However if the data requirements are large and at a low resolution then NoSQL is a better choice.

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

No. the more complex the relationships the greater a case can be made for something like mysql.

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

NoSQL databases have high scalability and high availability.

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

No, you can add to it and change it on the fly

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

NoSQL has low functionality as the trade-off for being highly scalable.

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

Absolutely not

#79

1
NoSQL = Easier to scale, no specific structure in date -> more flexible. Good for easy way to store a large amount of date and it does not always need to be 100% up to date.

SQL = always the latest information available, tying complicated things together, capturing relationships

2
no

3
In relation to what? It really depends what is more important for the project and what users need.

4
No, better to use SQL

#80

1-What are some of the advantages of NoSQL databases compared to SQL databases?
High scalability and high availability

2-Do you have to define a strict structure for your data in NoSQL?
No, since the structure is not necessary to start recording data or it can be modified in the future without altering the data.

3-What can you say about the trade-off between scalability and functionality in NoSQL?
An excellent advantage for when you have a large amount of data and should be consulted or to make it easy to scale and increase the capacity of the database.

4-If your data has important relationships to follow, is it a good idea to use NoSQL?
Not since NoSQL does not support unions or relationships. In that case, a relational or SQL database must be used.