SQL and Relational Databases - Reading Assignment

Blockchain Business Course
#862

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

The main advantages are high scalability and high availability.

Scalability: They are easy to scale and they are much faster in most types of operations that we perform on database.

Can handle huge amount of data, as the data grows NoSQL scales itself to handle that data in efficient manner.

High Availability: Auto replication feature in MongoDB makes it highly available because in case of any failure data replicates itself to the previous consistent state.

NoSQL store their data in JSON format, which is compatible with most of the today’s world application.

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

In relational database you must create the table, define schema, set the data types of fields etc before you can actually insert the data. with NoSQL you can update data on the fly. Without having to create a table first.

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

RDBMS a structured data that provides more functionality but gives less performance.
NoSQL: Structured or semi structured data, less functionali

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

No

#863
  1. Can change the structure, you can start adding data before you define the structure, easy to scale, faster operations, better for larger amounts of info
  2. No
  3. NoSQL gives you better scalability but you sacrifice functionality
  4. No
#864

  1. NoSQL databases offer high scalability, flexibility in data models, and faster performance compared to SQL databases.

  2. No, you don’t have to define a strict structure for your data in NoSQL, providing flexibility for evolving data models.

  3. NoSQL often prioritizes scalability over strict functionality, allowing for efficient handling of large and dynamic datasets at the cost of some traditional database features.

  4. If your data has important relationships that need to be tracked, using NoSQL may not be the best fit, as relational databases (SQL) are designed to manage and maintain complex relationships effectively.

#865

1.) Advantages of NoSQL over SQL: NoSQL can absorb unstructured data at horizontal scale. Reduces set-up time but costs downstream performance and functionality.

2.) Do you have to define a strict structure for your data in NoSQL? Nope. It will absolve any JSON data.

3.) What can you say about the trade-off between scalability and functionality in NoSQL? It gains scalability by not offering functions derived from a defined structure.

4.) If your data has important relationships that you need to keep track of, is a good idea to use NoSQL? Not really. It doesn’t sound very file size efficient either as it could be prone to rampant data replication.

#866
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    Scalability, speed, some data is not structured with relations
  2. Do you have to defined a strict structure for your data in NoSQL?
    No, that’s the whole point.
  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    The more functionality you require from your database the more complex it is for it to insert data and help you scale. the relational model make it hard to scale exponantially all the data that can come at you. Les functionality means it’s easier to insert
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    no. NoSQL requires you to maintain those and the constraints at app level
#867

1-high scalability and high availability, fast
2-No
3- Structured data that provides more functionality gives less performance. so when the requirement for less structured data, especially large volumes of data, it is better to choose NoSQL
4- no instead you can use Relational SQL

#868

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

    NoSQL databases are more flexible, scalable, and better suited for handling large volumes of unstructured data compared to SQL databases.

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

    No, NoSQL databases do not require a strict predefined structure, allowing flexible data models. SQL databases require a predefined schema with strict structure.

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

    In NoSQL databases, increased scalability often comes at the cost of reduced functionality, such as limited support for complex queries and transactions.

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

    No, SQL databases are better for data with important relationships, as they are designed to handle structured, relational data effectively.