SQL and Relational Databases - Reading Assignment

Blockchain Business Course
#622

1: you are able to structure a database even after completion. This makes it a bit easier.

2: no

3: You would need to continuously change your data and work on the issue of scalability with JOINS relational query.

4: no you need to use SQL or a GRAPH if they are very complex relations.

1 Like
#623

1.NoSQL databases can insert data on the fly, easy to scale, and are better when you have a large amount of data.
2. You do not have a defined and strict structure.
3. You can scale but do have a worse functionality where you cannot have constraints or JOINS.
4. It is not good to have NoSQL if the relationship is important because there are no joins.

1 Like
#624
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    More scalability, lower cost, less structured and faster.
  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 the data to be stored is big but simple than you can increase scalability over functionality and vice versa.
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No…better to use a relational DB.
2 Likes
#625
  1. What are some of the advantages of NoSQL databases compared to SQL databases? Flexibility through having the ability to change data structure at any point, scalability through sharding information across multiple machines, speed in operations.
  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 able to be horizontally scaled to handle increasing amounts of data, however the inability to operate with relationships may limit functionality
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL? No, NoSQL doesn’t support data relationships
1 Like
#626

  1. Easy to handle more data, easier to scale at speed

  2. No

  3. NoSQL you can scale faster if the relationships between the data don’t matter

  4. Not the best option

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

Some of the advantages of NoSQL versus SQL databases are NoSQL is highly scalable allowing handling of huge amounts of data and as data grows NoSQL scales itself to handle the data in an efficient manner. Also NoSQL is has a high availably because in case of any failure data replicates itself to the previous consistent state.

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

One does not have to define a strict structure for data in NoSQL

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

The trad-off between scalability and functionality is subjective to the requirements of the information. When data is continuously changing and updating over time the need for efficient vertical scalability and performance is important.

In most cases, calls are made to the NoSQL database and retrieve data based on a key. Data in a NoSQL database is accessed 1 “row”/object at a time.

In this case NoSQL databases would be better suited for building mobile apps to consolidate many data sources into a single view in supporting real-time event-driven architectures.

This is In contrast to a banking application that requires relationship based data enforcing ACID properties, Atomicity, Consistency, Isolation and Durability to achieve it’s requirements.

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

  1. One of the advantages of NoSQL databases compared to SQL databases is that they are really easy to scale and are much faster in most types of operations because there is no complex table like in MySQL databases.

  2. In NoSQL database, you do not have to define structure and schema of data first.

  3. High scalability means that it can handle huge amount of data. High functionality means that it can make connection with different data and make constraints so that data are in the right rule.

  4. Since NoSQL doesn’t support joins, it is not a good idea to use NoSQL if you want to make important relationships between different data.

1 Like
#629
  1. You can insert and update the data on the fly so they are easy to scale and faster.
  2. no, it is semi structures with less functionality but high performance.
  3. less functionality hinders the scalability of the database
  4. no
1 Like
#630
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    The main 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?
  4. When you want to store and retrieve huge amount of data.
  5. The relationship between the data you store is not that important
  6. The data is not structured and changing over time
  7. Constraints and Joins support is not required at database level
  8. The data is growing continuously and you need to scale the database regular to handle the data.
  9. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    NO!
1 Like
#631

  1. NoSQL databases are fast and scalable, so useful when dealing with large amounts of data.

  2. No NoSQL is semi structured.

  3. If you have alot of unstructured data to be stored quickly and retrieved at will, the NoSQL’s inability to use constraint and and join functions on the database may become a non issue especially as you could implement these functions at the application level.

  4. You may need to consider using functional databases such as SQL.

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

A) high scalability , High Availability

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

A) no this is one fo the benefits, you can just plug and play

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

A) its really good for scalability, however functionality it does not support constraints and joins ,

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

A) no, this would no be a good solution

1 Like
#633

Q1. What are some of the advantages of NoSQL database compared to SQL database?
A1. With NoSQL there is no need to setup tables, data and define schema, you just can insert data and update data on the go.

Q2. Do you have to define a strict structure for your data in NoSQL?
A2. No, this is an advantage of NoSQL.

Q3. What can you say about the trade-off between scalability and functionality in NoSQL?
A3. It depends on the database being built. They both are sound and work great when applied correctly.

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

1 Like
#634
  1. easy to scale, faster.
  2. No. You can update data.
  3. You can’t have constraints in NoSQL. Joins are not supported in NoSQL. These supports actually hinders the scalability of a database.
  4. No. It`s better to use SQL.
1 Like
#635
  1. Some of the advantages of NoSQL databases over SQL databases are -
  • More scalability - possibly to use sharding, spreading the database over several computers.
  • High availability - auto replication makes the database failure resistant and therefor offers high availability.
  • Easier to change the structure on the fly
  • Better for a very large amount of data where the relationships of the data isnt that important.

  1. No, the data structure does not need to be strictly defied in a NoSQL database.

  2. Whilst NoSQL databases are much more scalable than SQL they do suffer from less functionality as the lack of a strict structure, or lack of constraints, makes it harder to pull structured data from the database.

  3. SQL is much better when important relationships exist between the datasets and records.

1 Like
#636
  • High scalability
  • High availability
  • High performance

No, you don’t.

NoSQL databases have better scalability and performance, while RDBMS have better functionality.

No. In that case you should use RDBMS.

1 Like
#637
  1. NoSQL database they have a higher scalability and higher availability then SQL databases.
  2. No you don’t have to strict structure your data, you can just insert data on the fly.
  3. The trade off is less functionality on a NoSQL database but you have higher scalability, and have room to feed and grow large amount of data in a efficient matter.
    4.No, its better to use a RDBMS data base management system.
1 Like
#638

  1. High scalability and high availability.

  2. No

  3. If there is a massive amount of data that is increasing rapidly then going with a NoSQL database may be best however the sacrifice is in the functionality of the data.

  4. No, if there are important relationships between data then a SQL database is best.

1 Like
#639

  1. Some NoSQL advantages include: better scaling, faster and availability.

  2. No strict structure required.

  3. There’re less constraints to the DB. Joins are not supported. However, the functionality of these can be implemented at the application level.

  4. No, NoSQL is more applicable when the relationship between the data you store is not that important.

1 Like
#640

  1. Some of the advantages of NoSQL over SQL are, NoSQL can store large volumes of data and less functionality means the database is more responsive.

  2. You do not have to define a strict structure.

  3. There is a trade off between scalability and functionality because an NoSQL database has less functions but is easier to scale. where as SQL has many functions such as joins for relationship queries. but is difficult to scale.

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

1 Like
#641

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

    • Simpler design of the data - usually Key-Value representation
    • High scalability

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

    • Nope, semi-structured is enough

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

    • Usually NoSQL is used for huge volumes of semi-structured data that (fortunately) is not that sensitive with regards to consistency. So the high scalability is a BIG plus and the eventual consistency is acceptable trade-off.

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

    • No. SQL is mandatory.
1 Like