SQL and Relational Databases - Reading Assignment

Blockchain Business Course
#261
  1. What are some of the advantages of NoSQL databases compared to SQL databases? Scalability, better performance
  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? if you want scalability, then reduce functionality to improve performance
  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
#262

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

  • What are some of the advantages of NoSQL databases compared to SQL databases?
    Easier to scale and add more hardware. Do not have to pre define the DB before instalation.
  • Do you have to defined a strict structure for your data in NoSQL?
    No, it can always change
  • What can you say about the trade-off between scalability and functionality in NoSQL?
    Altho SQL functionality is better, with NoSQL you are able to store, add and retrieve large amounts of data
  • 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 as the back bone of SQL is based on relationships.
1 Like
#263

  1. It has high scalability, meaning you can vertically scale it by adding more resources to the machine. Also horizontal scaling where we can add more machines to handle the data.
    ° high availability where mongodb incase of any failure auto replicates it’s self to previous consistent state in case of a shut down or loss of power.

  2. No you can edit on the fly

  3. It makes sense to use No SQL for High scalability and high availability incase of any failure.

4.no better to use a SQL data base

1 Like
#264

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    High 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?
    cant have constrains or joins

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

  1. • Easy to scale and are faster in most types of operations
    • You can insert data on demand without creating a table, etc.
    • Variety to choose from

  2. No

  3. Horizontal scaling is easier to implement and it has durability to keep up with data that is growing continuously

  4. No

1 Like
#266
  1. Easy to scale and much faster in most calculations.
  2. Yes.
  3. NoSQL is great for scalability as you can grow it quickly as it requires less structure, the trade-off is that you get less functionality.
  4. No. This is the trade-off problem above. NoSQL is fast and scalable but has less funcitionality.
1 Like
#267

1.-
High scalability
High availabilty
Better performance than SQL database
2.- No, it’s more flexible
3.- NoSQL stores and can handle a huge amounts of data, however had less functionality
4.- No, you have to use a SQL database

1 Like
#268

  1. scalability, availability, and the ability to work with large amounts of data.

  2. No

  3. Functionality is decreased as scalability increases

  4. No

1 Like
#269

1: High scalability and easy scaling possibility
2:No not necessary for NoSQL
3: NoSQL is more scalable and has higher performance but has less functionality compared to SQL especially where relationships are necessary and secure data are a must
4:No as NoSQL does not support relationships and data is not as secure

1 Like
#270
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
  • it is easier to scale and faster at sorting more data than SQL. Also, NoSQL uses JSON which is already used by much of the worlds apps today.
  1. Do you have to defined a strict structure for your data in NoSQL?
  • no, you can just input and update on the fly
  1. What can you say about the trade-off between scalability and functionality in NoSQL?
  • NoSQL, thanks to Mongo DB and Cassandra, is much easier to scale up using horizontal sharding when compared to SQL. SQL is able to have a higher functionality rate because of it is a structured data.
  1. 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 when relationships are important to keep track of.
1 Like
#271
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    High scalability: NoSQL database such as MongoDB uses sharding for horizontal scaling. Sharding is partitioning of data and placing it on multiple machines in such a way that the order of the data is preserved. Vertical scaling means adding more resources to the existing machine while horizontal scaling means adding more machines to handle the data. Vertical scaling is not that easy to implement, on the other hand horizontal scaling is easy to implement. Horizontal scaling database examples: MongoDB, Cassandra etc. Because of this feature NoSQL can handle huge amount of data, as the data grows NoSQL scale 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.
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: Structured or semi structured data, 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

1 Like
#272

What are some of the advantages of NoSQL databases compared to SQL databases?
A: High scalability and high availability.

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

What can you say about the trade-off between scalability and functionality in NoSQL?
A: The trade off between scalability and functionality by using NoSQL is worth it:

  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.

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

1 Like
#273

  1. You can insert and update data while in motion.
    You can handle huge amount of data.
    Easy to scale and NoSQL is very fast in most type of operations.

  2. No.

  3. In NoSQL constraints and joins are not supported. This gives less functionality but it has higher performance.

  4. No, it would be a better idea to use Relational Database Management Systems (RDBMS).

1 Like
#274
  1. Fast, scalable, limited structural setup, lower operational cost, hold lots of data.
  2. no
  3. although it is not as secure, it is reasonable to use NoSQL for database for high scalability.
    High availability, in the case of any failure, data replicates itself to the previous consistent state.
  4. no, it is better to use an SQL database.
1 Like
#275
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
  • They are easy to scale and much significantly faster at performing most operations. NoSQL databases are best used when dealing with huge amounts of data.
  1. Do you have to defined a strict structure for your data in NoSQL?
  • No you do not.
  1. What can you say about the trade-off between scalability and functionality in NoSQL?
  • Joins and constraints are not possible in NoSQL, this may reduce functionality but it also allows for increased scalability.
  1. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
  • No it is not a good idea to use NoSQL, you would be better off using a relational database. instead.
1 Like
#276
  1. Scalability and Performance
  2. No
  3. NoSQL has high scalability and performance which is great for large streams of data. With this you sacrifice the security and functionality that Relational databases provide.
  4. No
1 Like
#277
  1. What are some of the advantages of NoSQL databases compared to SQL databases?

High horizontal scalability, high performance, auto replication / data safety

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

Different NoSQL collections can have different fields, while all data integrated into an SQL table has to follow the same structure.

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

NoSQL databases are more suited for handling large amounts (for example streams) of data that require less data safety / integrity, because NoSQL databases are not atomic. So it can happen that at a given point in time, a client receives information that is not up to date.

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

This would not be a good idea, as NoSQL databases do not consider the relational aspect of information. Relations could be implemented on application level - but it is generally a good idea to opt for SQL if the relations between the data stored are relevant,

1 Like
#278

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    They are really easy to scale and they are much faster in most types of operations that we perform on database. We dont need to create table, define schema like in SQL database. They are best choice also when we have a lot of data.

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

  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    Structured or semi structured data, 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, use some relational database.

1 Like
#279
  1. NoSQL databases are not rigidly defined so are more scalable, also suitable to huge amounts of data, particularly if the relationships between different data points are not essential, sharding and scalability of resources used makes also infrastructure easily scalable
  2. no, the data strtucture can change over time without the need to redo the whole database
  3. the functionality provided in relational databases is a hindrance to scalability, so the main question is what users need ;- a database that provides fast results querying large amounts of data, but do not need advanced functions regarding links between different types of data and more robust security, are more likely to choose noSQL for those benefits
  4. no, it would be better to use a relational database management system like MySQL or similar
1 Like
#280
  1. What are some of the advantages of NoSQL databases compared to SQL databases?

Changes can be made. More flexible than SQL databases. Easy to scale and faster. NoSQL is the better option when you need a database that will house a huge amount of data.

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

No because you have the flexibility to make changes after creation.

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

If you don’t need changes made, relationships of data between tables, don’t have huge amount of data, then go for SQL option. Other trade offs for choosing NoSQL are consistency, security and integrity of the data.

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

No. use RDB instead.

1 Like