Skip to content
Chandima's Blog
What you think you become.

Primary

  • SAUSECODE.COM
  • Blog
  • .LinkedIn
  • .Github
  • .Hackerrank
  • .About me

NoSQL vs SQL Databases in a Nutshell

Chandima June 5, 2020 database database, nosql, sql

In a nutshell, SQL databases are the tradional relational databases while NoSQL databases are non-relational.

SQL Database

  • Relational
  • Have predefined schema. Table based.
  • Uses Structured Query Language (SQL)
  • Vertically scalable.

NoSQL Database

  • Non-relational
  • Have dynamic schema. Document, key-value etc.
  • Unstructured data
  • Horizontally scalable.

Relational vs Non-relational

Traditional relational databases (RDMS) have predefined table structures (schemas). Manipulations to these RDMS are done using SQL commands.

Vertically vs Horizontally Scalability

Verticall scalability is achieved by upgrading resources like CPU, RAM of the existing machines, while horizontal scalability is achieved by adding more machines to the pool of machines. Anyway horizontal scalability is also possible in RDMS by dividing the user data among multiple servers by explicitly writing the application logic to do so. The Difference is, the horizontal scalling is automatically done by the NoSQL databases itself.

SSH to a host through multiple jump hosts. [Linux]PREV
How to let the scripts run in the background [ssh]NEXT

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary

Search the blog!

Recent Posts

  • Familiarize with these tools before going to Industry May 8, 2021
  • How to let the scripts run in the background [ssh] June 6, 2020
  • NoSQL vs SQL Databases in a Nutshell June 5, 2020
  • SSH to a host through multiple jump hosts. [Linux] April 30, 2019
  • GNU – Octave [matlab equivalent for linux] – This is how you can install packages January 22, 2019

Categories

  • android (11)
  • applications (2)
  • apps (4)
  • arduino (2)
  • avr (1)
  • blog-android (2)
  • blog-arduino (1)
  • computer science (1)
  • database (1)
  • embedded (1)
  • emui (1)
  • games (1)
  • home made (2)
  • Honor 3c (6)
  • how to (15)
  • huawei (6)
  • java (4)
  • kali (7)
  • kitkat (1)
  • learn (10)
  • linux (11)
  • networking (6)
  • octave (1)
  • PC Apps (1)
  • pi4j (1)
  • programming (3)
  • pyqt (1)
  • python (2)
  • raspberry pi (1)
  • remote controlled (1)
  • Server (3)
  • tech (4)
  • tutorial (8)
  • Verilog (1)
  • windows (6)

Tags

2018 aero plane android Android 4.4.2 android app player android apps on windows class cross-platform file honor 3c honor 3c custom unicode honor 3c sinhala how how to how to install how to install custom unicode huawei honor 3c install custom font in honor 3c install custom unicode install unicode interfaces java kali language linux network opengl programming pyqt python remote run scripts server sinhala sinhala app sinhala for huawei sinhala installer sinhala unicode sinhala unicode for honor 3c sinhala unicode installer sinhala unicodes Sri Lanka ssh to

Archives

  • May 2021
  • June 2020
  • April 2019
  • January 2019
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • April 2018
  • March 2018
  • October 2017
  • February 2017
  • June 2016
  • July 2015
  • January 2015
  • December 2014
  • November 2014

"I hear and I forget, I see and I remember, I do and I understand." ~ Confucius

© Copyright 2020 SAUSECODE LABS | Chandima Samarasinghe