SQL and Relational Databases - Reading Assignment

Blockchain Business Course
#802
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    High availability & high 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?
    NoSQL has more scalability, but less functionality compared to Relationnal DBs.
  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
#803
  1. Scalability, high performance, handle huge amount of data.
  2. No.
  3. When handling a massive amount of data, noSQL scale itself.
  4. No.
1 Like
#804

  1. One of the advantage of 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.

  2. No

  3. You can’t have contraints in NoSQL and Joins are not supported.

  4. No

1 Like
#805

1 Its fast. It can process big amounts of data compared to SQL.
2 No.
3 There is not perfect database yet created. Using NoSQL database you sacrifice having less functionality but you get a high performance.
4 No.

1 Like
#806

  1. NonSQL are non relational, less expensive, better scalability and you don’t have to structure the data.
    SQL databases are faster, the transactions are atomic so the security aspect is better.

  2. No strict data structuring in NonSQL databases.

  3. NonSQL are able to scale vertically and horizontally so scaling is easy, if relationships between data is not important and there is a lot of incoming data or the data changes, it is better to use a non SQL.

  4. no

1 Like
#807

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    No need to create tables or relationships for data making it much faster and easier to scale. You also don’t have to worry about that, you can insert, update data on the fly.

  2. Do you have to defined a strict structure for your data in NoSQL?
    No, tables and relationships or joins are not required

  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    When you want to store and retrieve huge amount of data.and the relationship between the data you store is not that important when the data is not structured and changing over time by trading off the requirements of constraints and Joins support

  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No, to maintain strong relationships of data a Relational Database should be used

1 Like
#808
  1. They’re fast and efficient and can handle HUGE volumns of data. They’re also more flexible.
  2. No
  3. NoSQL does not have the functionality that SQL has and so focuses on simpler tasks. But it can do these simple task at a large volume and thus outperforms SQL. Simple and efficient.
  4. No
1 Like
#809
  1. What are some of the advantages of NoSQL databases compared to SQL databases?

High Scalability and High Availability.
Huge amounts of data can be stored, and they allow data restructuring over time.

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

No. Data can be updated and inserted on the fly.

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

NoSQL Data Bases operate with structured or semi-structured data, therefore they offer less functionality, but higher performance, while Relational Database Management Systems operate with structured data that provides more functionality but gives less performance.

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

No. In this case, we should not use NoSQL because it offers less functionality than RDMS, meaning we can’t have constraints and support for joins in NoSQL.

1 Like
#810

  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 and they are much faster in most types of operations that we perform on database.

  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?
    No

1 Like
#811

  1. With NoSQL you don’t have to define the data structure beforehand, it’s easier to scale, you can store and retrieve larger amounts of data.

  2. No

  3. The lack of functionality gives you the increased scalability. It all comes down to what is more necessary. If you don’t value atomic transactions, relational queries then NoSQL is the better option because of the cost and scalability options.

  4. No, you can’t do it with NoSQL

1 Like
#812

-you don’t have to worry about creating the table, define schema, set the data types of fields etc, you can insert, update data on the fly.

  • they are really easy to scale and they are much faster in most types of operations that we perform on database
  • High Availability
  1. No
  2. SQL gives more functionality but less performance
  3. no
#813
  1. Advantages of NoSQL data bases:
  • high scalability
  • high availability
  • fast
  • high performance

  1. No.

  2. NoSQL Data Bases use structured or semi-structured data and they have less functionality, but higher performance.
    RDBMS operate with structured data that provides more functionality but has less performance.

  3. Consider using SQL

1 Like
#814
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    Later it is possible to change the structure of database, we don’t have to define data structure beforehand. It is possible to store and retrieve larger amounts of data.
    NoSQL database 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?
    no
  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    NoSQL Data Bases operate with structured or semi-structured data, therefore they offer less functionality, but higher performance, while Relational Database Management Systems operate with structured data that provides more functionality but gives less 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
#815

1)Advantages of NoSql data base
a)easy to scale
b)faster in most type of operation
c)huge amount of data dealing
d)High availability (auto replication)

2)No structuring of data is not required
3)there are two types of scalability named vertical and horizontal. Horizontal scaling adds on more machine and is easy to implement and is good when huge data is involved. NoSql has less functionality one cannot have contraints and Joins are not supported that someway hinders scalability
4)For data where relationship is involved and regular handling is not required it’s adviced to use SQL

1 Like
#816

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    • NoSQL databases allow you to insert data on the fly and is easy to scale while also being faster than SQL databases.
    • Stores data in JSON Format so it’s compatible with most apps
    • High availability, so if there’s a failure then the database replicates itself to the previous consistent state

  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?
    NoSQL databases are highly scalable due to sharding, and while it is true that the functionality is less as well, that’s only at the database level. At the application level, you can still add functionality; so it may not be too bad of a tradeoff.

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

1 Like
#817
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    on NoSQL you can insert/ add data on the fly.
    One of the advantage of 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. There are certain situations where you would prefer relational database over NoSQL, however when you are dealing with huge amount of data then NoSQL database is your best choice.
  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?
    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
  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
#818

1/ NoSQL: Highly scalable and availability
2/ No
3/ Trade off in NoSQL: Choose NoSQL when processing a very large volume of data which grow continuously and have no structure/constraints .
4/ No

1 Like
#819
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    NoSQL has high scalability and is much faster to configure when compared to SQL databases because we don’t have to pre-define structure and data format / relationships between tables.
  2. Do you have to defined a strict structure for your data in NoSQL?
    Strict data structure is not required in NoSQL, in fact it can even change after the NoSQL has been setup.
  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    Depending on the purpose of the database, I would see the NoSQL as the lite database version where it doesn’t need to put constraints and complex relationships between various data sets. Meanwhile if I have data that I would need to perform many different types of computations between different data sets in different tables, I would not use NoSQL because it doesn’t have the JOIN.
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    If the relationships are so important to keep track off, Relationship Database is much preferred.
1 Like
#820
  1. Easy to scale and much faster in most types of operations.Best for huge amount of data.
  2. No
  3. It can scale itself horizontally when it is needed but this also make it less functional than RDBMS
  4. No, you would rather go with RDBMS
1 Like
#821

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

NoSQL databases can handle big amount of data which ca be translated to high scalability. Also, it has high availability due to auto replication.

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

No, a strict structure for data in NoSQL is unnecessary. The relationship between stored data is not important.

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

In NoSQL Scalability is performed in a very efficient manner once this type of database can manage great amount of information. In terms of functionality NoSQL is low once structured data is not a requirement here.

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

No, because NoSQL do not prioritize relationship between stored data. Instead, is a great option for storage and retrieval of big amount of data, prioritizing scalability over functionality (relationship between data).

1 Like