SQL vs NoSQL

0 votes

You are already familiar with SQL database. 

In the last several years, NoSQL database is getting widely adopted to solve various business problems.

What do you think which one is better?

Which one is better to use, better in terms of designing the architecture and good for getting o/p from a table?

Aug 10, 2018 in Database by Priyaj
• 56,900 points
61 views

2 answers to this question.

0 votes

According to what I know and have used I can differentiate SQL and NoSQL in the following ways:-

  • Schema:- SQL databases have predefined schema whereas NoSQL databases have dynamic schema for unstructured data.

  • Scalability:- SQL databases are vertically scalable whereas the NoSQL databases are horizontally scalable. SQL databases are scaled by increasing the horse-power of the hardware. NoSQL databases are scaled by increasing the databases servers in the pool of resources to reduce the load.

  • Data Manipulation:- SQL databases uses SQL ( structured query language ) for defining and manipulating the data, which is very powerful. In NoSQL database, queries are focused on collection of documents. Sometimes it is also called as UnQL (Unstructured Query Language). The syntax of using UnQL varies from database to database.

  • Examples:- SQL database examples: MySql, Oracle, Sqlite, Postgres and MS-SQL. NoSQL database examples: MongoDB, BigTable, Redis, RavenDb, Cassandra, Hbase, Neo4j and CouchDb

answered Aug 10, 2018 by bug_seeker
• 15,350 points
0 votes
Well, it depends on what you are using it for. Both of these have their own pros and cons.
answered Aug 10, 2018 by slayer
• 29,170 points

Related Questions In Database

0 votes
1 answer

IN vs OR in the SQL WHERE Clause

I assume you want to know the ...READ MORE

answered Sep 24, 2018 in Database by DataKing99
• 8,130 points
36 views
0 votes
1 answer

Clustered vs Non-clustered Indexes

Clustered indexes - The indexes according to ...READ MORE

answered Aug 20, 2018 in Database by DataKing99
• 8,130 points
38 views
+1 vote
1 answer

DELETE vs TRUNCATE vs DROP command

After the execution of ‘DELETE’ operation, COMMIT ...READ MORE

answered Aug 23, 2018 in Database by CodingByHeart77
• 3,690 points
248 views
0 votes
1 answer

Different types of SQL Joins

The 4 main kinds of Joins present ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,130 points
158 views
0 votes
1 answer

Difference between single and double quotes in SQL

Single quotes are used to indicate the ...READ MORE

answered Sep 11, 2018 in Database by CodingByHeart77
• 3,690 points
94 views
0 votes
1 answer

Write a SQL query to find the names of employees that begin with ‘S’

To display the name of the employees ...READ MORE

answered Sep 26, 2018 in Database by darklord
• 6,170 points
50 views
0 votes
1 answer

What's the difference between Hadoop and NoSQL ?

Let's start with the definitions Hadoop is an ...READ MORE

answered Apr 2, 2018 in Big Data Hadoop by kurt_cobain
• 9,260 points
338 views
0 votes
1 answer

Which query to use for better performance, join in SQL or using Dataset API?

DataFrames and SparkSQL performed almost about the ...READ MORE

answered Apr 19, 2018 in Apache Spark by kurt_cobain
• 9,260 points
129 views
0 votes
1 answer

How to connect Java program to the MySQL database?

You can connect your Java code with ...READ MORE

answered May 11, 2018 in Java by parth295
• 4,640 points
209 views
0 votes
1 answer