SQL and Relational Databases - Reading Assignment

Blockchain Business Course
#702

1)What are some of the advantages of NoSQL databases compared to SQL databases?
The main advantages are high scalability and high availability.
2)Do you have to defined a strict structure for your data in NoSQL?
No you can insert, update data on the fly.
3)What can you say about the trade-off between scalability and functionality in NoSQL?
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?
No, better choice is SQL.

1 Like
#703
  • What are some of the advantages of NoSQL databases compared to SQL databases?
    NoSQL advantages are
  1. No need to define data structure at the onset (Data structure can change overtime)
  2. High Scalability
  3. High Performance (faster)
  4. Great with Huge amount of data

  • Do you have to defined a strict structure for your data in NoSQL?
    No, data structure can change over time

  • What can you say about the trade-off between scalability and functionality in NoSQL?
    SQL focuses on Functionality (relationships) while NoSQL has higher Scalability and Performance

  • If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    NO! If data relationships are important you’re better off with SQL databases

1 Like
#704

it can store and receive large amounts of data and its fast and scaleable.

No

you get more scalability, speed and functionality with noSQL, however you lose a lot of structure and security without it.

No

1 Like
#705

  1. NoSQL can scale both vertically and horizontally meaning that it doesn’t suffer the scalling issue of SQL databases. No relationships therefore own standing data

  2. Key-value Stores and Schemaless meaning data can be different.

  3. Data can only be found via a primary key so can only be searched via 1 path and is eventually consistent.

  4. No because it gets rid of relationships.

2 Likes
#706

  1. One big advantage of NoSQL databases is you don’t have to define the tables and data fields that the data will be stored in before collecting the data. This means NoSQL databases can scale much more quickly and easily.

  2. You do not have to define a strict structure for data in a NoSQL database.

  3. NoSQL databases store less structured data where the relationship between different data is not as clearly defined. This means it is easier to scale and store huge amounts of data, however the functionality of the data will not be as great.

  4. If you need to store data with important relationships, it is a bad idea to use a NoSQL database, you should use an SQL database.

1 Like
#707

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    Advantages of NoSQL databases include speed, availability and scalability. These type of databases generally perform queries much faster than Relational Databases and allow for data to be stored on the fly without having to create and define schemas and data types beforehand.

  2. Do you have to define a strict structure for your data in NoSQL?
    Unlike Relational Databases, NoSQL databases do not require a structure or schema be defined upfront.

  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    Compared to Relational Databases, NoSQL databases have less functionality but better perdomance.

  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No, if the data has important relationships that need to be maintained, a Relational database is the best choice.

1 Like
#708
  1. What are some of the advantages of NoSQL databases compared to SQL databases? high availability & 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? faster but less functionality for constraints and joints
  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
#709
  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?
    Because of high scalability No SQL can handle a hige amount of data, as the data grows NoSQL scales itself to handle that 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?
    Nope
1 Like
#710

  1. It’s much better for projects that deal with large amounts of less-sensitive data. Lowers overhead cost and integrates much better with applications. Overall much easier to use than a MySQL database.

  2. No.

  3. Scalability is much easier to do on NoSQL and there’s a lot more potential in this aspect, but it does cost functionality aspects as you cannot set constraints or use JOIN functions

  4. No, in that scenario it would make more sense to go with a SQL database.

1 Like
#711

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    Scalability and availablity. Less requirement on data structure. Better for huge amounts of data (ex. sensor output)

  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?
    NoSQL is highly scalable (horizontal scaling), because of the data being less structered. This causes you to lose a lot of functionality (primarily relational).

  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
#712

  1. NoSQL is easy to scale, you can insert and update data on the fly, and can handle huge data sets.

  2. No

  3. NoSQL is highly scalable and at a cost of functionality has a very high performance.

  4. No

1 Like
#713
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    Easier set up, easier to scale, and faster processing of operations.
  2. Do you have to defined a strict structure for your data in NoSQL?
    No, you can quickly insert data
  3. What can you say about the trade-off between scalability and functionality in NoSQL? If you have large data sets or are an ever changing company then the you want to have the scalability even if you lose some functionality.
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL? Probably not, relational databases are about relationships between tables and making sense of it all.
1 Like
#714
  1. Scalability is on big difference
  2. No you can insert data on the flu
  3. The higher the scalability the lower the function rate is.
    4.No in NoSQL relationship between data is not important
1 Like
#715

  1. What are some advantages of NoSQL databses compared to SQL databases?
    NoSQL: non-relational, low cost, variuos kinds of NoSQL DB available, easily scalable, more data, no need for detailed DB structuring
    SQL: speed, well defined global standards, atomic transactions - secure, no coding needed

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

  3. What can you say about the trade-off between scalability and functionality in NoSQL
    If your data is continuously changing over time and you have to update your data, you would have to trade off using joins for relational queries, or in no need of constraints

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

No

2 Likes
#716
  1. NoSQL databases are faster and easier to scale
  2. NoSQl do not need to be defined in a strict structure like a table
  3. NoSQL databases are better for scalability but lack the high functionality for complex data entries
  4. NoSQL is not efficient at tracking relationships due to its limited options for functionalities
1 Like
#717

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    a)Real easy to scale.
    b)Insert and update data on the fly.
    c)Scalable & fast.

  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?
    When you need scalabality but functionality isn’t important NoSQL is the choice you should make.

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

2 Likes
#718
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
  • good for scaling
  • uses JavaScript therefore no need to adapt
  1. Do you have to defined a strict structure for your data in NoSQL?
    No need for structure in NoSQL, that is the reason it is easier to scale
  2. What can you say about the trade-off between scalability and functionality in NoSQL?
    There is less functionality in NoSQL, but this could be caught up on the applicational level. The constraints and joins that are missing hinder the functionality.
  3. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No
2 Likes
#719
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
  • Best for a large amount of data
  • Support structural data changes
  • Provides better performance than SQL database.

  1. Do you have to define 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 offers more scalability and better performance when dealing with huge data, but also less functionality (i.e., doesn’t support Constraints or Joins), and those functionalities need to be available on the application level and not the DB level.

  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
#720
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
  • High scalability, faster processing, high availability
  1. Do you have to defined a strict structure for your data in NoSQL?
  • No
  1. What can you say about the trade-off between scalability and functionality in NoSQL?
  • Structured or semi structured data, less functionality and high performance.
  1. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
  • No
1 Like
#721

  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?
    No constraints allowed and joins are not supported.

  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