SQL and Relational Databases - Reading Assignment

Blockchain Business Course
#502

  1. 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 (high Scalability) and they are much faster in most types of operations that we perform on database. When you are dealing with huge amount of data then NoSQL database is your best choice (= high availability)

  2. Do you have to define a strict structure for your data in NoSQL?
    No, in NoSQL you can insert, update data on the fly, without before you create the table, define schema, set the data types of fields etc before you can actually insert the data.

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

  4. **If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?**no, it’s better tu use a RDBMS as it has more relational performance

2 Likes
#503

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

It can handle a much larger set of data and can also scale as needed. It is much faster than relational databases. It also has high availability as data replicates so if there is a failure, it can always return to a stable state.

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

No - this cold also be an advantage of NoSQL.

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

NoSQL can scale much more easily and quickly handle a very large amount of data but the trade off is that some functionality is lost including Join and Contraint support at the database level.

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

No - an SQL database would be more suitable here.

1 Like
#504

  1. NoSQL allows for high scalability, high availability. As a horizontal scaling database, you are adding more machines (more processing power) to handle scalability. Likewise, they are highly available because the data will replicate itself to it’s most recent consistent state preventing massive data loss in the case of failure.

  2. the purpose of a NoSQL database is to not have to worry about strict structures in the data. this allows for storing large amounts of data where relational comparisons aren’t as important. it allows for greater scalability.

  3. scalability in NoSQL reduces functionality. reason being you cannot implement data constraints, joints are not supported, as these features would actually hinder it’s core value prop.

  4. No, in the event your data has many important relationships - you would not be well advised to pursue a NoSQL database config.

1 Like
#505
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    easier to scale, much faster in most operations, best for large amounts of non-relational data
  2. Do you have to defined a strict structure for your data in NoSQL?
    No, you can insert and update on the fly.
  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    NoSQL has less functionality, but better performance than a SQL database
  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
#506

Answers

  1. Advantages with NoSQL DB are:
  • high scalability --> sharding for horizontal scaling;
  • high availability --> auto replication data.

  1. There isn’t a strict structure of data in NoSQL. You should only define a key-value pair for a huge amount of data, without a strong relationship.

  2. NoSQL DBs have less functionality and high performance. Because of their nature of semi-structured data, with these you can’t have either constraints or joins.

  3. If I want to keep track of relationships I shouldn’t use NoSQL DB. Instead, I may prefer the good old SQL! :smiley:

1 Like
#507
  1. Scalable, less rigid.
  2. No.
  3. NoSQL allows for storage of big data and fast retrieval of it, yet relationships for instance between tables nor rigid definitions of it are not possible, it is less ‘functional’.
  4. No.
1 Like
#508
  1. **What are some of the advantages of NoSQL databases compared to SQL databases?
    With NoSQL, there is no need to create tables. You can add data on the fly.
    High scalability: The data is saved on multiple machines which enables NoSQL to handle a great amount of data.

High availability: Auto replication makes the database highly available in case of failure

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

  2. What can you say about the trade-off between scalability and functionality in NoSQL?
    The trade off is more scalability and performance for less functionality

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

No it is best to use SQL in that instance.

1 Like
#509

  1. In NoSQL there is high scalability, and no need for creating tables. It can handle much more data then SQL.

  2. No, there is no need structure

  3. Having huge amount of data which is growing would be a good trade off because in this case you need high scalability to handle that data in efficient way

  4. No

3 Likes
#510

1.)
The main advantages are high scalability and high availability.

2.)
In a NoSQL database we dont need to define structure and schema of data.

3.)
The higher the functionality (structure) the lower the scalability (performance) and vice versa.

4.)
If the scaling of the SQL DB is sufficient, an SQL database should here always be preferred.

3 Likes
#511
  1. **What are some of the advantages of NoSQL databases compared to SQL databases?
  • NoSQL is better when you have to store a huge amount of data and retrieve the data
  • SQL is commonly used DB, and the devs understand the SQL
  • SQL is a more secured DB, atomic
  1. **Do you have to define a strict structure for your data in NoSQL?
  • no, you don’t
  1. **What can you say about the trade-off between scalability and functionality in NoSQL?
  • NoSQL has better scalability than functionality
  1. **If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
  • No, for that SQL/RDBMS is better
3 Likes
#512
  1. They are in general very easy to scale and are operating in a fast pace.
  2. no
  3. It is not as secure as a SQL it provides more scaleability and can handle large amounts of data.
  4. No
2 Likes
#513

1- High scalability and high availability.
2- No
3- The trade-off is worthwhile when large amounts of unstructured data need to be quickly stored and retrieved and where relationships between data are not important.
4- No

2 Likes
#514
  1. What are some of the advantages of NoSQL databases compared to SQL databases?

  • Store & retrieve huge amounts of data

  • Relationship between data stored not important

  • Data not structured & changing over time

  • Constraints & joins support not required at data base level

  • Data growing continuously and need to scale the database regularly to handle data

  1. Do you have to defined 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 is the way to go for vertical/horizontal scalability and high performance

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

2 Likes
#515
  1. What are some of the advantages of NoSQL databases compared to SQL databases?

Scalability of the databases, as they can process big amount of data, and also it’s easier to change entries, as it can be changed as you go, while SQL tables don’t have a chance to change entries. Also good that noSQL it can be replicated.

  1. Do you have to define a strict structure for your data in NoSQL? No, and that’s why this a great advantage over SQL, the order can be changed on the go.
  2. What can you say about the trade-off between scalability and functionality in NoSQL? As it mentioned in the article, NoSQL are scalable, but also due to no relations it’s not that functional.
  3. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL? No, in that case definitely better to use SQL
3 Likes
#516
  1. Scalabilty as the data base grows and availability of data when needed.
  2. NoSQL does not need a strictly defined structure
  3. Joins and constraints used in retrieving data are not supported in order to allow higher performance of the database.
  4. NoSQL is not a database used for relationship based data.
2 Likes
#517
  1. Advantages of NoSQL databases (compared to SQL databases) are:
  • NoSQL can handle huge amounts of data;
  • NoSQL has an auto replication feature in case of any failure;
  • NoSQL offers high scalability, so that as data grows over time, you can do horizontal scaling over many machines;
  • NoSQL allows easy updates;
  • NoSQL is fast;
  • NoSQL data is stored in JSON format which is compatible with most applications.

  1. The data structure in NoSQL does not need to be strictly defined.

  2. Depending on what type of data you have, and whether or not relationships are important, you may be willing to trade some functionality for scalability and performance.

  3. No, if you need to keep track of important data relationships, it is not a good idea to use NoSQL.

2 Likes
#518
  1. Highly scalable, Highly available.
  2. No
  3. NoSQL is useful for data that requires less constraints and more scale.
  4. No, Strict relationships would be better in a more structured database like SQL
2 Likes
#519

  • What are some of the advantages of NoSQL databases compared to SQL databases?
    Flexibility, scalability.

  • 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?
    A NoSQL database is more scalable and more flexible. But that comes with a price : the data cannot be “assembled” and queried the same way (less functionnality).

  • If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No. A relational database such a SQL would be prefered.

2 Likes
#520
  • What are some of the advantages of NoSQL databases compared to SQL databases?
    Scalability, speed, and fewer resources used
  • 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?
    SQL has more functionality than nosql where nosql has more scalability
  • If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL? NO
2 Likes
#521
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    easy to scale (High scalability) and high availability (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?
    it is important to consider what kind of data needs to be store (structured/non-structured) and how it needs to be accessed, now and in the future (relational/non-relational), this determines the type of Database you choose. high scalability (NoSQL) versus high functionality (SQL)
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No, then SQL is preferred
2 Likes