SQL and Relational Databases - Reading Assignment

Blockchain Business Course
#562
  • High scalability. The can use partitioning of data and placing it on multiple machines.
  • High Availability. Data is replicated on many machines, so there is no one point of failure.
  • Higher performance in writing and reading data.
  • Stores data in Json format which is compatible with most of today’s world applications.

  1. No

  2. You can’t have constraints in NoSQL. Joins are not supported in NoSQL.

  3. No

1 Like
#563

SQL AND RDB- Homework

1- No SQL are more scalable and provide better perofmrance in handling data in terms of speed and volume.
2- No, data in NO SQL DB doesn´t need to be highly structured
3- No SQL is better when you need bettter scalability, in the case of data that can grow a lot over time in terms of volume, you give away functionality but NoSQL are suitable for different data that do not need relationship between them
4- No, you need in that case an SQL DB, which provides better functionality when it comes to data relationship.

1 Like
#564
  1. Scalability and availability.
  2. No.
  3. NoSQL has less functionality (ex: no constraints) but this allows for better scalability.
  4. Most likely not. Relational databases are ACID compliant and better suited for storing relationships in a secure way.
1 Like
#565
  1. Some advantages of NoSQL databases are easier scalability, much faster, and you can insert and update data on the fly.
  2. You do not have to define a strict structure for your data on NoSQL.
  3. The lack of functionality in a NoSQL is a trade off for performance as it is a much more efficient system due to that lack of functionality that you get with a structured database. The scalability is also a benefit as it is easy to shard, and scale both vertically and horizontally.
  4. It is not a good idea to keep your data on a NoSQL system if there are a lot of relationships between your data that you must keep track of and query for.
1 Like
#566
  1. What are some of the advantages of NoSQL databases compared to SQL databases?

NoSQL is better when there is a large amount of data as it is easier to scale and the database will have high availability (faster)

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

No, there is no need to set up tables and need for creating data fields-just insert the data and you are good to go. Changes and additions are easily added as well

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

If no data relationship is of high importance the scalability and speed of the NoSQL database will deliver a better trade off

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

No. NoSQL will not be a good if data relationship is highly important

1 Like
#567
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
  2. Do you have to defined a strict structure for your data in NoSQL?
  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?

ANSWERS----

1.No need to create the table, columns, Rows just insert and update data + really easy to scale and they are much faster in most types of operations that we perform on database if handling huge amount of data.
2.No just insert and update data.
3.1. You can’t have constraints in NoSQL
2. Joins are not supported in NoSQL
These supports actually hinders the scalability of a database,.So NO SQL is functioning fine
4.No You’d be better off with SQL database

1 Like
#568
  1. It is low cost and easily scalable. It has a huge capacity to handle large amounts of data.
  2. No we don’t have to define a strict structure for our data in NoSQL.
  3. When your data is constantly changing and needs to be updated, you would require scalability and that is traded iff with joins for relational queries.
    4.No, one should use RDMS
1 Like
#569
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    NoSQL : easy to scale, much faster; good if work with huge 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?
    If your data is growing it is better to use 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
#570

  1. The main advantages of NoSQL over SQL databases are high scalability and high availability, plus they are much faster in most types of operations.

  2. The trade-off between NoSQL and SQL is that with SQL you get more structured data with relationships and integrity checking; with NoSQL you can get higher performance, better scalability and work with a lot more data.

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

1 Like
#571
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
  • Some advantages of the NoSQL databases compared to the SQL databases are that NoSQL databases are easier to scale and perform faster operations making them a more efficient choice in certain cases. (refer to question 3 for more )
  1. Do you have to defined a strict structure for your data in NoSQL?
  • There is no defined strict structure for data in NoSQL databases which allows for data to be updated more freely. It does not require tables or set data types.
  1. What can you say about the trade-off between scalability and functionality in NoSQL?
  • The trade-off between scalability and functionality in the NoSQL is data relationships. This means that if you are looking for functionality over scalability which requires consistent updates, an SQL database is more functional for keeping track of data relationships, while NoSQL will allow for updates to be sent out more freely.
  1. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
  • It is important to understand the differences between an SQL and NoSQL database when keeping track of data. To keep track of data that has important relationships it is more efficient to use an SQL database.
2 Likes
#572

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    Better performance when dealing with large amounts of data, do not need to invest up front time to set up.

  2. Do you have to defined a strict structure for your data in NoSQL?
    No upfront decisions need to be made regarding structure.

  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    A NoSQL database is highly scalable however with this you will forgo functionality such as constraints and joins.

  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    NoSQL would not be the best choice for data structures that have important relationships, where by efficiencies and value can be generated by utilising these relationships.

2 Likes
#573

  1. You can insert and update data on the fly. NoSQL databases are easy to scale, faster in many operations and better with large amount of data than SQL databases. NoSQL databases also have high availability because of the auto replication feature.

  2. No.

  3. NoSQL compared to SQL has higher scalability but less functionality.

  4. No. NoSQL databases are not tracking relations.

1 Like
#574
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
  • High scalability
  • High availability
  • High speed

  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?
    Structured or semi structured data; less functionality and higher performance.

  3. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No, altough you can implement relations in application layer.

2 Likes
#575

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

With SQL, you need to create a table and define the data types on the rows and columns before you can add data. That is not required with NoSQL and data can be added and updated on the fly. NoSQL is easy to scale

2. Do you have to define 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 highly scalable because it uses horizontal scaling, meaning more machines are added to handle the data instead of vertical scaling where more resources are added to the same machine. It has less functionality because you cant have constraints and 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. RDBMS is better

2 Likes
#576
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
  • The main advantages of NoSQL databases are their ease and flexibility; they offer high availability and scalability compared to SQL databases…
  1. Do you have to define a strict structure for your data in NoSQL?
  • No, the data can be created as you go.
  1. What can you say about the trade-off between scalability and functionality in NoSQL?
  • One of the main benefits is the scalability, the possibility of adapting and expanding the database particularly if you will be working with a lot of data and this will be growing continuously. The reduction of functionality is the flip side or trade-off. If this is more important than the scalability, then RDBMS or another type of database should be considered.
  1. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
  • No, if the data is relational, it is better to use a RDBMS type of database like SQL which is more structured and better suited than NoSQL for these types of functions.
1 Like
#577
  1. scalability, fast, no need for DB structuring
  2. no
  3. you can’t achieve ACID properties which are needed for certain types of fuctions.
  4. No
1 Like
#578
  1. high scalability and high availability
  2. No
  3. Is is easily scalable but it doesnt have a lot of functionalities
  4. no
1 Like
#579

  1. NoSQL is highly scalable and high availability

  2. No

  3. You loose functionality by using NoSQL but in some case with large databases is better due to scalability

  4. No, is better to use a relational database

1 Like
#580
  1. NoSQL is highly scalable and available
  2. No
  3. Large amounts of data can be stored and updated on the fly with NoSQL, but because there are no strict structures, it’s less functionable.
  4. No
1 Like
#581
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
  • Scalability
  • Handling huge amount of Data
  • Performance
  • High Availability
  1. Do you have to defined a strict structure for your data in NoSQL?
  • No, it can be updated on the fly
  1. What can you say about the trade-off between scalability and functionality in NoSQL?
  • Functionality can be used on an application level, if needed
  • There are no constraints in NoSQL
  • Fast, easy to scale, variable structure but not functional and not for relational data
  1. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
  • No it’s not, for that SQL is needed
2 Likes