SQL and Relational Databases - Reading Assignment

Blockchain Business Course
#762

  1. more scalable and available, no need for previous structuring.

  2. No.

  3. The trade off is worthwhile where large amounts data is needed to be stored and retrieved without a previous structuring of the DB and where relationships between data are not as important.

  4. No.

1 Like
#763
  1. NoSQL database compared to SQL database has high scalability and availability. NoSQL scale itself to handle huge amounts of data. Incase of failure of data it replicates itself to its previous state.
  2. No, you can implement data and update as you go.
  3. Functionality would slow down scalability of database.
  4. No, NoSQL is best to handle large amounts of data where relationships arenā€™t important.
1 Like
#764

  1. when dealing with big amount of data NoSQL Dbs are better than SQL dbs. They are faster and easy to scale.

  2. Thereā€™s no defined strict structure. You can perform operations such as create, insert, update, delete etc on this data. NoSQL store their data in JSON format, which is compatible with most of the todayā€™s world application.

  3. NoSQL: Structured or semi structured data, less functionality and high performance.

  4. no

1 Like
#765
  1. Faster searches; you donā€™t need to set up DB architecture; horizontal scalability. (Moral of the story: donā€™t use an SQL DB just because all the cool kids do it. make sure you need it.)
  2. No.
  3. Its scales much better than SQL due cool features like MongoDBs sharding. The tradeoff is that you cant use relational tables and joins serverside. You still do it locally or in another application. Furthermore, you canā€™t use constraints (you just have to implement your sanity checks some other way.)
  4. Generally, no.
1 Like
#766
  1. It is easier to set up, as there is no need to define schema, set data types of fields, high availability is faster and more scalable.
  2. No
  3. In NoSQL you cant have constrains and joints are not supported.
  4. No, in this case itā€™s better to use RDBMS.
1 Like
#767
  1. What are some of the advantages of NoSQL databases compared to SQL databases? You do not need to define the structure up front, they scale easily, and are much faster for most types of operations. They work better for really large amounts of data
  2. Do you have to defined a strict structure for your data in NoSQL? No. In fact, the dataā€™s schema can change over time.
  3. What can you say about the trade-off between scalability and functionality in NoSQL? The functionality of SQL refers to its ability to have constraints, atomicity, and being able to JOIN tables together. But this is somewhat rigid in that the schema is ā€œset in stoneā€ from the beginning, and the time to perform operations like JOIN grows exponentially with the data size. So for large amounts of data and/or data structures/types which changes over time, SQL is outperformed by NoSQL.
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL? Depends on the size and expected evolution of the data over time, however SQL is generally better at tracking relationships by ensuring atomicity of changes.
1 Like
#768

1). Able to store large amounts of data, Scalable database,

  1. No

3). If the project is working with large amounts of unstructured data that donā€™t require relationships with each other.

4). No

1 Like
#769
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    NoSQL databases are really easy to scale and it is quicker to perform operations on the data base. Also, they are more ideal in storing large amounts of data.
  2. Do you have to defined a strict structure for your data in NoSQL?
    In NoSQL, you can insert and update data on the fly, meaning there isnā€™t a strict structure and hence it being easy to scale.
  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    The trade off is you canā€™t have constraints and joins are not supported.
  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 not a relational database, instead use RDBMS.
1 Like
#770
  1. Easy to scale. Faster. Stores a huge amount of data. The data isnā€™t structured and can be changed.
  2. No
  3. NoSQL has higher scalability and higher availability. Sharing allows for horizontal scales. So when the database requires more scalability and less functionality.
  4. SQL will be better
1 Like
#771
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    Fast, scalable, limited structure setup, lower operational cost, hold lots of data.
  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?
    Sharding allows for horizontal scaling. Things like data comparison happen outside the database on an application layer rather than in the database like SQL.
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No, it is better to use an SQL database.
2 Likes
#772

1, NoSQL,
-Easy to scale,
-Faster operationally,
-Good with large amounts of data,
-Sharding
2, No, you can insert and update data on the fly.
3, More scalability means less functionality although high functionality is found with RDBMS so selecting the correct database for the purpose at the start is important.
4, No because NoSQL is best applied to large consistent data storage that does not require updating or altering. The relationship between the data being stored is not important.

2 Likes
#773

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    High scalability and availability, can easily work with JSON format, data can be processed faster and can handle large amounts of growing data.

  2. Do you have to define a strict structure for your data in NoSQL?
    With NoSQL dbā€™s strict structure is not needed.

  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    For larger amounts of data and the speed to process the data spending more on resources seems worth the trade when dealing with growing data, and using the apps to process the functionality.

  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No, since the important data should be under the ACID properties to keep the data integrity and protected. NoSQL is more of a free form.

2 Likes
#774

  1. Some of the advantages of NoSQL databases compared to SQL databases are high scalability and high availability.

  2. No, you do not need to define a strict structure for your data in NoSQL.

  3. The trade-off between scalability and functionality in NoSQL consists of two main issues: (i) you canā€™t have constraints in NoSQL and (ii) joins are not supported in NoSQL. In other words, you would want to choose NoSQL over a relational database when (a) you want to store and retrieve a huge amount of data and (b) the relationship between the data you store is not that important.

  4. If your data has important relationships that you need to keep track of, it is not a good idea to use No SQL. Indeed, that is primarily because of the second trade-off noted above: joins are not supported in NoSQL.

1 Like
#775
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    NoSQL createsa a non-relational, low cost, easlily scalable database whereas SQL provides secure atomic transactions, defined global standards, and high speeds in these databases.
  2. Do you have to defined a strict structure for your data in NoSQL?
    In NoSQL you do not have to define a strict structure.
  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    The lack of constraints and support for joints in NoSQL makes it more scalable due to the unstructured data thus allowing higher throughput. However this design hinders functionality.
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    Because you need to prioritize relationships, it would be wise to use SQL instead of NoSQL in this case.
1 Like
#776

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    NoSQL databases are easy to scale and they are faster than SQL databases.
    They are faster in most types of operations.
    It is the best choice for handling huge amounts of data.

  2. Do you have to define a strict structure for your data in NoSQL?
    No you can update the structure on the go.

  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    While an NoSQL database is very scalable it is harder to handle relationships.

  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    Itā€™s not a great idea to do so because you could change the data and maybe even change by accident important data.

1 Like
#777
  1. Some of the advantages of NoSQL: easy to scale, can perform faster operations, and good at dealing with very large amounts of data.
  2. No
  3. NoSQL is less structured and functionality reduced, but can store large amounts of data with high scalability.
  4. It is not a good idea to use NoSQL when your data has important relationships that you need to keep track of.
1 Like
#778
  1. NoSQL Databases are more scalable due to sharding. Basically storing the data on different computers, the fact that you do not need a strict structure, high availability
  2. No this is one of the advantages. You need no strict structure as opposed to SQL
  3. No constraints, no joints
  4. No it is not a relational database, but a key value database among others. Meaning it is good to store large quantities and flow of data but not relational
1 Like
#779
  1. High scalability and high availability.
  2. No is not needed compared to MySQL
  3. NoSQL provides higher scalability and performance but less functionality
  4. For relationships as a priority I would choose a different database system.
1 Like
#780
  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?
    You canā€™t ahve constraints 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
#781
  1. What are some of the advantages of NoSQL database compared to SQL databases?
    Easy scalability
    High availability
    Faster
  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 and faster to retrieve large amounts of data, but less functional if your data has to be structured
  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