In order to understand NoSQL, it’s necessary to understand SQL. NoSQL Databases refers to a database method that differs entirely from the typical relational database management system(RDBMS).SQL is a query language used by relational databases.

  1. SQL is a Structured Query Language whereas NoSQL is Not SQL or Not Only SQL.
  2. SQL is used by relational databases whereas NoSQL is used by non-relational databases.
  3. SQL follows the structured schema whereas NoSQL follows the unstructured schema.
  4. Unstructured data increases at a much faster rate than structured data and does not fit into RDBMS relational structures, thus NoSQL is particularly useful for storing unstructured data.

Types of NoSQL Databases

  1. Key-Value Store

(i) Most basic form of NoSQL database.

(ii) Schema-free data model is arranged as a dictionary of key-value pairs.

(iii) For each key a value is assigned for all the items.

Examples of Key-Value Store are: Amazon DynamoDB, Redis, and Riak

2. Document

(i) Same as key-value database concept.A step further by grouping documents into collections.

(ii) Supports queries on attributes within documents and nested key-value pairs.

Examples of Document are: MongoDB and Amazon DocumentDB

3. Column-oriented

(i)Focus on columns, and each column is addressed separately.

(ii) More efficiently works at storing data and querying across rows of sparse data.

Examples of column-oriented database are: HBase and Apache Cassandra

4. Graph-based

(i) Multi-relational in nature.

(ii) Tracks both entities and their connections. An entity is a node and connections are edges.

Examples of Graph-based databases are: Neo4J, Infinite Graph, and OrientDB

Thank you for the read🙂. Do clap, if find useful.

“Keep learning and keep sharing knowledge”

Database Engineer having working experience in SQL and NO-SQL databases. 👨‍💻

Love podcasts or audiobooks? Learn on the go with our new app.

DeepMind just released Haiku and RLax for neural networks and reinforcement learning

Serverless take 2: AWS CDK and AWS Cognito

How To Fix Vizio TV Wont Connect To WiFi/Ethernet/Internet? [2022] (Best 4 Fixes)

Big-Bang Initialization of Variable Activity in a SAT Solver

Go: Story of TryLock Function

RESTFUL WEB API USING ASP.NET CORE 2.0 WITH MSSQL(using Dapper)

The complete Truffle suite on Docker (Truffle + Ganache + Drizzle)

Monitoring in a Microsoft Big Data Cluster (BDC)

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Nidhi Gupta

Nidhi Gupta

Database Engineer having working experience in SQL and NO-SQL databases. 👨‍💻

More from Medium

SQL vs NoSQL Database — A Complete Comparison

Soft Delete and Unique Constraint

MERN app with friends or ChocolateyAutoInstallMakefileFun

Database Basics: Database Introduction, SQL vs NoSQL

Databases Overview — Thumbnail