SQL and Relational Databases - Reading Assignment

Blockchain Business Course
#642
  1. They are really easy to scale and are much faster in most types of operations that are performed on databases.
  2. You do not. NoSQL is non relational.
  3. When you have ever increasing and constant changing data, you would want the trade off between scalability and functionality that comes with NoSQL. It is more scalable.
  4. It is not. It is better to use a relational database.
1 Like
#643

  1. What are some of the advantages of NoSQL databases compared to SQL databases? - Data can be inserted and updated on the fly, no need for lengthy set up. More scalable and quicker. Data is stored in JSON format which is highly compatible with most applications. High availability/accessibility and data recovery/duplication.

  2. Do you have to define a strict structure for your data in NoSQL? - No. The result when compared to a RDBMS is less functionality and higher performance.

  3. What can you say about the trade-off between scalability and functionality in NoSQL? - Because of a less complex structure scalability and faster performance [ data storage and retrieval ] can be achieved. However, data security is compromised due to the lack of support of the ACID Principles.

4.If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL? - No. NoSQL is better suited for accessing/updating large amounts of data.

1 Like
#644
  1. no prior setting of tables and schemas needed before data can be inserted. Faster, better availability, hence better for huge amounts of data.
  2. No you can change the amount and the structure of data later and insert data on the fly.
  3. You have less functionality due to no constraints and structure
  4. No, in that case you use SQL databases
1 Like
#645

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    Advantages are 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?
    NoSQL database can scale faster and easier, but it doesn’t have as much functionality as 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, you should use SQL database if you need to store relationships.

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

-more efficient and scalable, can handle a lot more data

  1. Do you have to defined a strict structure for your data in NoSQL?
    Unlike for SQL, you do not have to define strict structure of data for NoSQL

  2. What can you say about the trade-off between scalability and functionality in NoSQL?
    The opportunity cost of enhanced scalability due to sharding is diminished functionality.

  3. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No, if the relations are complex a GRAPH database may be more efficient or if they are simple a SQL database.

1 Like
#647

  • 1.What are some of the advantages of NoSQL databases compared to SQL databases?
    You can update and insert data on the fly. Also, faster and easier to scale.

  • 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 are dealing with data that is constantly changing and that needs to be updated and added as well as large amounts of data then use NoSQL. If you are dealing with not so important data then the trade off is worth it.

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

1 Like
#648

  1. They are more easily scaled, they can handle much larger amounts of data that won’t change over time.

  2. No

  3. There is less functionality but more scalability.

  4. No

1 Like
#649
  1. Some of the advanages of NoSQL databases compared to SQL databases are high scalability and high availability.
  2. NO, you do not have to define a strict structure for your data in noSQL.
  3. I would say if your looking for a database that is scalable and can handle large amounts of unimporant or changing data then NoSQL is the database to use. on the other hand if if well defined Atomic secure transactions are needed then SQL is probably the way to go.
  4. No
1 Like
#650
  1. High scalability and high availability.
  2. No.
  3. The trade-offs are the support of of Constraints and Joins that would be provided by relational database.
  4. No. NoSQL is a better choice when the relationship between the stored data is not important.
1 Like
#651

What are some of the advantages of NoSQL databases compared to SQL databases?
NoSQL uses less space, or easy to scale. It is for data that have no structure or semi structure. It is good for dealing with huge amount of data that need not have much relations.

What are some of the advantages of NoSQL databases compared to SQL databases?
NoSQL uses less space, or easy to scale. It is for data that have no structure or semi structure. It is good for dealing with huge amount of data that need not have much relations.

SQL is secure with atomic transaction properties. Great for data that are relational.

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?
Availability and flexibility versus functionality and structure.

If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
No. You are recommended to go with RDBMS.

1 Like
#652
  1. NoSQL is fast, scalable and data can be amended/edited on the go.
  2. No.
  3. less secure than SQL, however allows processing of huge volumes of data
  4. No. better with SQL
2 Likes
#653
  • What are some of the advantages of NoSQL databases compared to SQL databases?

Advantages are high scalability and availability. Aswell as low cost and less time setting up.

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

Nope

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

No support for joints and constraints

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

No

1 Like
#654
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
  2. Fast, scalable, limited structural setup, lower operational cost, hold lots of data.
  3. Do you have to defined a strict structure for your data in NoSQL?
    No
  4. What can you say about the trade-off between scalability and functionality in NoSQL?
    The more scalable the less functionality
  5. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    NO
1 Like
#655

  1. Some of the advantages of NoSQL databases compared to SQL databases are its highly scalable and has high availability. With NoSQL you can insert, update data on the fly.

  2. In NoSQL you do not have a defined strict structure for your data.

  3. NoSQL can perform and scale better than SQL but SQL is more functional. With SQL Constaints and Joins are supported where NoSQL you cannot.

  4. If your data has important relationships that you need to keep track of it is not a good idea to use NoSQL. As NoSQL is not a relational database.

1 Like
#656
  1. Some of the Advantages of NoSQL is high scalability and speed of operation.
  2. No structure needs to be defined.
  3. Relational data suffers at a cost of large data processing.
  4. No SQL is much better for relational data.
1 Like
#657
  1. Advantages of NoSQL over SQL include
    High Scalability-NoSQL databases use sharding for Horizontal scaling,by partitioning of data and placing it in multiple machines in the same order, preserving the order of the data. This is easier and faster to scale than vertical scaling that requires addition of more resources to the existing machine. As a resukt NoSQL can handle huge amounts of data. As the data grows NoSQL scales itself. EG MoongDB.
    In SQL databases, scaling is limited since as an relational Databse, one needs to pre-determine structure and schema first( the table)then only can we start processing Data.
    High Availability enables NOSQL to auto-replicate .MySQL reinforces ACID( (Atomicity, Consistency, Isolation and Durability)for security which is suitable for banking but can be very slow for other non-relational Database management.
    SQL applications that store their data in format are limited and don’t provide ways of performing operations such as create, insert, update, delete etc on this data. On the other hand NoSQL store their data in JSON format, which is compatible with most of the today’s world application.
  2. NoSQLdoes not have a defined strict structure of Data.
    3.RDBM is a structured data that provides more functionality but gives less performance. NoSQL is Structured or semi structured data, with less functionality and high performance.
    4, Important relationships need MySQL RDBM
1 Like
#658

What are some of the advantages of NoSQL databases compared to SQL databases?
NoSQL databases Handle large volumes of data at high speed, easier to scale, no structure needed.

Do you have to defined a strict structure for your data in NoSQL?
No, data can be inserted and updated on the go.

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

NoSQL is more focused on scalability and performance while the sql is more focused on functionality.

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

It wouldn’t be a great idea to use NoSQL. It would be better to use SQL if your data has important relationships that you need to keep track off since the databases are built for that.

2 Likes
#659
  1. Faster, high scalability and high availability.
  2. No.
  3. NoSQL sacrifices constraints and joins for a massive increase in scalability and availability.
  4. NoSQL would be a bad choice for keeping track of relationships.
1 Like
#660

What are some of the advantages of NoSQL databases compared to SQL databases?
You don’t need to structure the data before data input and NoSQL will perform faster. NoSQL can handle large volume better too.

Do you have to defined a strict structure for your data in NoSQL?
you can if you want to but not needed as you would need to in SQL

What can you say about the trade-off between scalability and functionality in NoSQL?
Not sure if I understood the question properly but the trade-off would be that you cant add relations to the database in NoSQL.

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 JION.

2 Likes
#661

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

In a SQL database the structure of the database has to be defined before inserting any data, which can be a problem if we realise later on that the structure was not the best for our data. In a NoSQL database we don’t have to worry about that and can insert or update data on the fly. NoSQL databases are very easy to scale and are faster in most types of operations performed on databases.

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

No, the data is not structured and changing over time

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

Relational databases provide more functionality (when relationships between data are important) but less performance and scalability. NoSQL databases provide less functionality (cannot have constraints, joins are not supported) but more performance and scalability (can store and retrieve huge amounts of data and can be scaled regularly to handle more data).

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 it’s better to use a relational database.

2 Likes