NOSQL

why we move into NOSQL

scalability

SQL vs NOSQL

SQL

SQL stands for structured query language

SQL lets you access and manipulate databases

SQL is an ANSI standard

 

NOSQL

stands for Not Only SQL 

class of non-relational data storage systems

usually do not require a fixed table schema nor do they use the concept of joins

all NOSQL offerings relax one or more of the ACID properties

 

NOSQL characteristic

open-source

non-relational

schema-less

cluster friendly

 

CAP vs ACID theorem

ACID

Atomicity

Consistency

Isolation

Durability

CAP

Consistency

Availability

Partition tolerence

 

NOSQL database Types

document

column-family

graph

key-value