SQL and Relational Databases - Reading Assignment

Blockchain Business Course
#462
  1. What are some of the advantages of NoSQL databases compared to SQL databases?

On SQL Database you need to define and create the table with all information before starting inserting data. Once you have started, you can’t change it. On NoSQL, you can easily update tables. Also, NoSQL is easy to scale and is much faster in most type of operations performed on database.

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

No, you can actually update the structure for the database after started.

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

Although NoSQL is easy to scale, you can’t have constraints and joins are not supported.

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

No, would be safer use SQL database.

1 Like
#463

  1. SQL: speed, well defined global standards, atomic transactions, no coding vs. NoSQL: non-relational, low cost, various kinds of NoSQL, rigid and detailed structuring not needed.

  2. No

  3. Scalability is necessary in NoSQL because often there is a large stream of “sensory” data continuously entering the DB.

  4. No

1 Like
#464

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    NoSQL databases are more scalable and able to handle huge amount of data.

  2. Do you have to defined a strict structure for your data in NoSQL?
    No, data in NoSQL do not need to follow strict structure like an SQL database.

  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    NoSQL offers superior scalability but it comes at price of the functionality that SQL databases offer.

  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    Then you need to use SQL database since NoSQL does not track relationship between data.

1 Like
#465

[quote=“ivan, post:1, topic:6432”]

  • What are some of the advantages of NoSQL databases compared to SQL databases?
    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.

  • Do you have to defined a strict structure for your data in NoSQL?
    The data is not structured and changing over time

  • What can you say about the trade-off between scalability and functionality in NoSQL?
    NoSQL: Structured or semi structured data, less functionality and high performance.

  • If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No, as NoSQL relationship between the data you store is not that important.

1 Like
#466

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    a. NoSQL provides the performance and flexible database schema and structure that can be scaled on-the-fly.
    b. Since NoSQL stores data in JSON format, the database can be readily shared and used by many applications worldwide.
    c. NoSQL is highly scalable, as in the database can grow dynamically while handling huge amount of data in a relatively short time and the database can be sharded horizontally across multiple machines for added scalability.

  2. Do you have to defined a strict structure for your data in NoSQL?
    No, you cannot apply constraints to NoSQL database.

  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    Since the data structure has to be simple, relationship-linking database structure are limited to simple relationships, unlike RDBMS.

  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No, NoSQL has very limited capability to link complex relationships between different databases.

1 Like
#467

[quote=“ivan, post:1, topic:6432”]

  • **What are some of the advantages of NoSQL databases compared to SQL databases? Easily scaleable and updateable

  • 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? Less functionality but high performance, needs structured data

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

No not great for relational data

1 Like
#468

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    NoSQL databases are highly scalable and have high availability. They are advantageous when you need to store and retrieve huge amounts of data and the relationship between the data is not that important.

  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?
    Greater structure can provide more functionality however is less scalable. You can’t have constraints in No SQL and joins are not supported, but these hinder scalability of a database.

  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 a relational database.

3 Likes
#469
  1. Scalable, cheaper, handle lots of data.
  2. No
  3. If the data is not strictly structured and growing continuously
  4. No
2 Likes
#470
  1. Faster, lower costs, you can update data as needed, and it can handle huge amounts of data.
  2. No.
  3. Although structured date provides more functionality, it does not provide greater performance.
  4. No. You need more structure to function properly.
2 Likes
#471

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    That they are really easy to scale and they operate faster than SQL databases in most operations.

  2. Do you have to defined a strict structure for your data in NoSQL?
    Um so in the article it says that NoSQL requires structured or semi structured data so I am going to say yes . But I feel like it’s no lol.

  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    That with NoSQL you can you gather and operate information faster while functionality allows you to take more control and the organization of your data.

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

1 Like
#472
  1. Structured or semi structured data, less functionality and high performance.
    When you want to store and retrieve huge amount of data.
    The relationship between the data you store is not that important
    The data is not structured and changing over time
    Constraints and Joins support is not required at database level
    The data is growing continuously and you need to scale the database regular to handle the data.
  2. NO.
  3. It is faster and cheaper to implement, when there is no requirement for structured data.
  4. NO.
2 Likes
#473

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    Not only SQL (NoSQL) Advantages:
    Highly scalable - if the data in the organization is growing at the rapid pace then NoSQL databases like MongoDB can manage the data growth need by adding more machine that can store the data also called as partitioning the data by sharding method and maintaining the sequence of the data
    High Availability - in case of failure, data replicates itself and manintain the previous versions of the dataset

  2. Do you have to defined a strict structure for your data in NoSQL?
    One another advantage of NoSQL is your data can by semi-structured and can easily be updated to include new attributes .

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

  • NoSQL is not relational so if the data stored on the database do not require relationship then it can benefit more.
  • Less constraints on the data being stored
  1. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No! for e.g. banking system where data is highly relational such as Customer, Account Details, Transactions, Loan etc which requires multiple joins to make the information more useful in such cases NoSQL database is not a good choice. NoSQL is good fro Key - value pairs or the data do not need relationship at the database level.
3 Likes
#474

  1. The main advantages NoSQL has are high scalability and high availability.

  2. No, data can be inserted and updated on the fly.

  3. You can’t have constraints and joins are not supported.

  4. No use SQL because it is better for that.

1 Like
#475

NoSQL is faster, supports a flexible number of fields, and can support large amounts of data

There isn’t a strict structure for the data

If the database needs to do anything with relationships, it is not supported by NoSQL. NoSQL is more limited in the ways data can be searched and presented

Don’t use NoSQL if you need to handle relationships

1 Like
#476
  1. Provides scalability and high availability
  2. No
  3. If there is large amounts of data that would need to be updated from time to time and also where relationship between data is not that important
  4. No
1 Like
#477
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    High Availability
    High Scalability
    Low overhead (cost)
    Applicable in a dynamic database.
    Compatible with most of today’s (2020 till another paradigm) world applications that store data in JSON format.
  2. Do you have to defined a strict structure for your data in NoSQL?
    No, you don’t.
  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    Having a dynamic database, meaning it is ever-changing, large steams of data will have to be stored in a scalable database such as NoSQL; however, constraints and joins functionalities hinder the performance of a database. Functionality trades off performance for security in RDBMS, while scalability trades off security for performance 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
#478

What are some of the advantages of NoSQL databases compared to SQL databases?
NoSql requires no structure to process the data, while SQL will require the use of rows, columns and tables.

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

What can you say about the trade-off between scalability and functionality in NoSQL?
When storing data with NoSql it is easier to store the massive amount of information or data that not evolving over time, but as functionality of how the data is structure it is not that great

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

1 Like
#479

  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    High scalability: SQL DBs may be more secure than NoSQL DBs, but this comes at significant costs to performance. NoSQL DBs have much higher scalability due to their use of sharding (partitioning of data on multiple devices) and horizontal scaling (adding more devices).
    High availability: NoSQL DBs have automatic replication features in the event of failure.

  2. Do you have to defined a strict structure for your data in NoSQL?
    No, this can be altered according to need at any time

  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    It is essential to keep this in mind when assessing the needs of whatever project one is building and designing a tech stack for. If it requires more functionality than scalability, one would pick a RDBMS (relational database management system) over a NoSQL DB 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, in this case one would choose a SQL DB

1 Like
#480

  1. NoSQL databases do not enforce a rigid database structure instead it can be scaled according to the requirment any time.

  2. No.

  3. If the database structure for an application is more changing than more in to keeping relationships, it is better to migrate to a NoSQL. NoSQL provides better scalability even though it is poor in maintaing traditional relationships.

  4. No.

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

SQL:

  • structured
  • provide consistency and integrity

  1. Do you have to defined a strict structure for your data in NoSQL?
    with NoSQL DB you do not need to define structures

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

  • Joints are not supported and you can not have contraints. when using NoSQL, these functionalities van be implemented at the application level
  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 it would be prefered to use SQL DB
1 Like