SQL and Relational Databases - Reading Assignment


#1

Welcome to the discussion about this reading assignment.

Leave your answers to the questions below in this thread. If you have any questions or you want to discuss something connected to the assignment feel free to do it in this thread as well, but please everything to the topic.

  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?

#2

NoSQL Introduction – Reading Assignment

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

NoSQL`
Non-relational
Low cost
Various kinds of NoSQL DB available
Easily scalable
No need for detailed DB structuring

SQL
Speed
Well defined global standards
Atomic transactions - Secure
No coding needed

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?

When your data is changing continuously or even over time and you have to continue to update your data would be the need for scalability and the you would have to trade off using joins for relational queries, or in no need of constraints .

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

No


#3
  1. Fast, scalable, limited structural setup, lower operational cost, hold lots of data.
  2. No
  3. If you need to scale, change data types and need flexibility over time and don’t need to relate data with other data or need to structure data, then it could be worth trading scale and efficiency of NoSQL over the functionality of a relational database.
  4. No, better to use a RDMS.

#4

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

  • To store and retrieve large amounts of data
  • When data is growing it is easy to scale

2) Do you have to defined a strict structure for your data in NoSQL?
No. Constraints and Joins support is not required at the database level.

3) What can you say about the trade-off between scalability and functionality in NoSQL?
Although it is not as secure, it is reasonable to use NoSQL for database for high scalability.
High availability, in the case of any failure, data replicates itself to the previous consistent state.

4) If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
No, as the data recipient may not be receiving the most up to date consistent state of the data.


#5
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    Quicker, Easier to scale, Less requirement to structure data, handles huge amounts of data better especially if the data is continuously growing.

  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?
    Structured data that provides more functionality gives less performance. so when the requirement for less structured data, especially large volumes of data, it is better to choose NoSQL .

  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.


#6
What are some of the advantages of NoSQL databases compared to SQL databases?
  1. NoSQL provides scalability and high availability.

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

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

  2. In regard to the trade-off between scalability and functionality, it depends on what you are trying to do. If you do not , consider choose NoSQL over relational database when:

    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.

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

  3. Perhaps not. Consider a relational database.


#7
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
  • Faster.
  • Horizontal scaling
  • Can handle large quantities dynamic of data.
  • Data can be inserted and updated on the fly.
  • Simpler.
  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?
    The trade off is worthwhile where large amounts of unstructured data need to be quickly stored and retrieved and where relationships between data are not important.
  3. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No.

This article needs a sub-editor or technical writer to make it more understandable.


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

It allows restructure of data and it is easy to use

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

No

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

Are very limited or 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 because NoSQL is not a relational database


#9
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    Scalable & fast

  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?
    SQL gives more functionality but less performance.

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


#10

1. What are some of the advantages of NoSQL databases compared to SQL databases?
• We can insert, update data on the fly.
• Easy to scale and faster than SQL.
• When we have to deal with huge amount of data. High availability.
2. Do you have to defined a strict structure for your data in NoSQL?
It is not necessary. Data are stored in JSON format, relational management systems cannot perform CRUD operations on this data.
3. What can you say about the trade-off between scalability and functionality in NoSQL?
NoSQL data bases doesn’t have constraints and doesn’t support joins so they are more scalability and less functionality.
4. 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 is better to use a RDBMS than a NoSQL database.


#11
  1. NoSQL databases have high scalability as the structure is not defined at the beginning. It has high availability, because of auto replication feature. And it is faster in many cases, thus having higher performance.
  2. No.
  3. There are less functionality such as constraints and joins in NoSQL DB. But these said functions actually hinder scalability.
  4. No.

#12

1 Less Structured, more scalable, huge amounts of data that may change, where relationship is less important.

2 No Not in the way you do for SQL (but this doesn’t mean no planning is required)
3. Depending on the data, the trade off to increase functionality and scalability Using No SQL compared to SQL data base management system is useful where the relationships between the data don’t matter too much (Non financial data or private data) - It can scale flexibly and quickly and process the data faster but with reduced functionality compared with SQL

  1. Not advisable - important relationships are best preserved with SQL

#13

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

  • What are some of the advantages of NoSQL databases compared to SQL databases?
    NoSQL Databases are easy to scale, much faster and more efficient when dealing with large amounts of data, High Availability, Highly Scalable

  • 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?
    In NoSQL databases you can’t have constraints and joins are not supported making NoSQL more Scalable but less functional

  • If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No because NoSQL is not a relational database. RDBMS would provide a better structure


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

Higher performance and scalability, low cost as data structure is dynamic.

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

No

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

Functionality is reduced within NoSQL, however, scalability is enhanced through unstructured data which allows for higher throughput. Functionality can be regained 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, NoSQL databases are more advantageous for non relational databases.


#15

What are some of the advantages of NoSQL databases compared to SQL databases?
They are easy to scale and faster. Good when you have huge amount of data.

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?
NoSql are working good with scalabiity and performance. Constraints and Joins are not supported. When you look at functionality RDBMS are better. But you can create functionallities at the appplication level instead when using NoSql.

If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
SQL is good for online stores or banking systems. NoSQL fits for organic data as analytics systems, customer managent or different types of social networks.


#16
  • What are some of the advantages of NoSQL databases compared to SQL databases?
    Scalability / high availability.

  • 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?
    You’re giving up structure and rules/constraints.

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


#17
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    Scalability (can be horizontally scaled), high availability (auto replication across many servers)

  2. Do you have to defined a strict structure for your data in NoSQL?
    No, other than all data is stored in JSON format

  3. What can you say about the trade-off between scalability and functionality in NoSQL?
    SQL databases have constraints to restrict the type of data that can be stored in fields, and also to enforce rules about the data being stored. This means that constructing and maintaining relational databases can be a very slow and manual process. NoSQL on the otherhand has no such rules, which means faster database production, but less rules and possibly less integrity around the data.

  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    Not advisable. SQL is very good at maintaining the integrity of important relationships.


#18
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    It is easy to scale and they are much faster in most types of 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?
    When you have a huge amount of data the scalability is key
  4. If your data has important relationships that you need to keep track of, is it a good idea to use NoSQL?
    No

#19

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

NoSQL: Low cost, Easily scalable and there is no need detailed DB structuring

SQL: Speed, global standards, atomic transactions and No coding needed

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?
When your data is changing continuously over time and you have to continue to update your data, you have that scalability at your finger tips, but the functionality is limited e.g joins for relational queries

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


#20
  1. What are some of the advantages of NoSQL databases compared to SQL databases?
    scalability, high performance, speed
  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?
    having a huge amount of data with no relations
  4. 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