SQL and Relational Databases - Reading Assignment

Blockchain Business Course
#842

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    High scalability, perofrmance and high availablitiy.

  2. Do you have to defined a strict structure for your data in NoSQL?
    No, you don’t. You can structure the data at application level.

  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    When using NoSQL you sacrifice functionality over scalability/performance.

  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No, as NoSQL does not support realtionships between data. You need to use RLDMS.

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

easy to scale , easy available (peformance)

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

not at all

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

with noSQL you can’t have constrains and manage huge amount of data, but data is not structure and cannot create relationships.

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

it is not; in this is cases is better to use a RDMBS type like SQL or mySQL

1 Like
#844
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    No tables need to be defined in advance. Therefore they are easy to edit on the fly.
  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 is good for huge amounts of data and high performance but the functionality is not that great.
  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
#845

1.)
+) Higher scalability (sharding)
+) Higher availability (data replicates itself -> can be rolled back)

2.) No, the simplicity of the data makes the structure a given, more or less.

3.) If your data is relatively simple and the relationship between data is not so important, then those are reasons to choose a NoSQL database. The simplicity makes a NoSQL solution highly scalable, but if an SQL database is the better choice, it comes with the tradeoff of lower scalability.

4.) No, then an SQL solution is the better choice.

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

They are updatable on the fly, really easy to scale and they are much faster in most types of operations that we perform on database plus due to Auto replication feature in MongoDB they are highly available

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

NoSQL is either unstructured or semi structured data where you can insert, update data on the fly

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

To make it more scalable Constraints and Joins are not supported in NoSQL but you can implement these functionalities at the application level

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

No, you will use NoSQL over relational database when the relationship between the data you store is not that important

1 Like
#847

  • What are some of the advantages of NoSQL databases compared to SQL databases?
    You don’t need to create tables with relationships or define a schema.
    You can insert and update the data on the fly.
    Most NoSQL databases uses JSON.
    High scalability and availability.

  • Do you have to defined a strict structure for your data in NoSQL?
    no, it’s more like semi structured

  • What can you say about the trade-off between scalability and functionality in NoSQL?
    NoSQL has better scalability and performance but less functionality than RDBMS

  • If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    no, you should use NoSQL when the relationship between data is not important and the data is not strictly structured and is changing over time.

1 Like
#848
  1. High scalability and high availability.
  2. No
  3. Constraints and joins are not supported in NoSQL.
  4. No
1 Like
#849

  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?

  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    In this case it’s not a good idea to use NoSql and we should choose sql database

1 Like
#850

What are some of the advantages of NoSQL databases compared to SQL databases?
A: High scalability, high availability & update on the fly.
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 is worthwhile where large amounts of unstructured data need to be quickly stored and retrieved and where relationships between data are not important.
If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
A: No, rather use SQL DB’s instead.

1 Like
#851
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    good for huge anounts 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?
    when the data has a simple structure, and there is a lot of data and you want scalability, There is functionality trade off for some types of structures
  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 not. if these relations are not simple, use another type of database, like SQL.
1 Like
#852

A1. Simple to build, cost efficient, scalable
A2. No
A3. If there is possibility of data structure changes then relational functionality is traded-off
A4. No

1 Like
#853
  1. They are more scalable and mantainable.
  2. No
  3. In NoSQL databases, you can`t modify or relate data, just add new data ecery time, so it has less funcitonality than SQL but is more scalable because it uses sharding. At the same time, it uses autoreplication in case of an error so it returns to the previous state.
  4. No
1 Like
#854
  1. NoSQL database reads data much quicker than SQL database and can therefore store information quickly and query information quickly.

NoSQL:

  • Non-relational
  • Low cost
  • Easily scalable
  • Fast

  1. No you don’t, data are stored in JSON format and CRUD is not possible to be used in that format.
    It can be in any order because you can qurey it quite easily anyway. for example you can store wallet-addresses in a NoSQL database for people that signs something like a manifesto.

  2. Trade off using NoSQL is that is dont offer functions such as Joins or constraints like SQL does. But thats why it also is more scalable. It also might be more vonurable for SQL injection attacks

  3. No, it’s better to use SQL in this case as it is relationship-based.

1 Like
#855
  1. Scalable, fast, lower operational cost, limited structural setup, holds a bunch of data.
    2.no.
    3.SQL gives more functionality but less performance.
  2. No because NoSQL is not a relational database. RDBMS would provide a better structure
1 Like
#856
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    NoSQL databases have high scalability and high availability, is faster in most types of operations, and stores data in JSON format
  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 is much easier to have scalability and there’s a lot more potential in this aspect, 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, that need to be maintained, a Relational db is the best choice.
2 Likes
#857

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    One advantage of a 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 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?
    Less functionality with higher performance:

  4. You can’t have constraints in NoSQL

  5. Joins are not supported in NoSQL

These supports actually hinders the scalability of a database, so while using NoSQL database like MongoDB, you can implement these functionalities at the application level.

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

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    Easy to scale
    Faster
    Huge amount of data
    High availability

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

  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    High scalability
    Less functionality better performance.
    You can’t have constraints in NoSQL
    Joins are not supported 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

1 Like
#859
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    Faster and scalable
  2. Do you have to defined a strict structure for your data in NoSQL?
    Nope
  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    You can’t have constraints in NoSQL
    Joins are not supported 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, is not.
1 Like
#860

  1. Advantages of using NoSQL databases are that:
    you can store and retrieve huge amount of data, and its able to handle growing data information in an efficient manner, high scalability;
    you don’t need to structure data and can be changing over time, you can insert and update data easily;
    high availability;
    constraints and joins support not required at database level, its non relational

  2. No you don’t need to define a strict structure of your data in NoSQL

  3. The trade-off is valuable when you need high scalability, to store large unstructured data information but less functionality where the relationship between data entry is not that important

  4. No its not good idea to use NoSQL because it is non relational database

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

The main advantages of NoSQL over SQL databases are high scalability and high availability.

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

No. NoSQL does not require a strict structure.

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

in NoSQL?

NoSQL gives good scalability and high performance but at the expense of 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. NoSQL should not be used if data has important relationships that need to be tracked.