https://www.networkworld.com/article/2226514/tech-debates/what-s-better-for-your
ID: 3755415 • Letter: H
Question
https://www.networkworld.com/article/2226514/tech-debates/what-s-better-for-your-big-data-application--sql-or-nosql-.html
After reading the article
1) Since you have had a taste of what SQL can do, what is your initial opinion of what is better (SQL or NoSQL) and why, based on this article and what you know about databases? Keep in mind that we have barely scratched the surface of the power SQL has in this class.
2) Comparing this article to what your textbook has presented as well as your prerequisite courses; compare how database design, data models, and the user’s role in the development might be handled different between the article and what you have been taught.
Explanation / Answer
1.
SQL is a structured query language for databases. It allows only structured information to be stored in the database. NoSQL is one of the upcoming technologies which is used by Big Data applications. It doesn't force the data to be in a structured form.
I consider SQL is more beneficial than NoSQL for many reasons. Some of the reasons are mentioned below:
-> SQL provides a high amount of interaction with the data.
-> It is a much-standardized query language which supports third-party applications and tools.
-> It is much robust in handling the data.
-> It supports multiple features and a wide variety of inbuilt functions.
-> It supports a different variety of data formats like JSON, XML etc.
2.
When compared to data models, flexibility and handling different type of data, NoSQL has the greatest advantages for some of the reasons mentioned below.
-> It allows easy modifications of an existing data model
-> It doesn't force the data to be only available in structure format. It handles semi and unstructured data as well.
-> It allows multiple types of data to be easily fit in.
-> The design of the database would not be a cumbersome task.
-> It is much suitable for real-time data processing. Most of the real-time data is unstructured.
-> It reduces the pain of the programmer since there is no need for parser or some special kind of program to handle data to be in a specific format and design.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.