NoSQL introduction and different NO SQL database


NoSQL Overview

One day data uploads in Facebook approximately 100 TB. Transaction processed 24 million and 175 million twits on twitter approximately.How can this possible to store retrieve and data process efficiently? using SQL.they are many problems in a tradition database.In recent context difficult to handle both the size of data and concurrent actions on data.NoSQL (not only SQL) databases have been evolving the Shortcomings of traditional databases.


It will good to cover my other articles.It helps to learn more about MongoDB.In which I explained.Click here MongoDB Indexing working and MongoDB Limit Document working and MongoDB find method working.

Problems in relation database

  1. <Select>Joined to the main table to create huge size table.
  2. <update>Each update affect many another table.
  3. <Delete>Must guarantee to consistent.
  4. SQL support the mix of the structure of data.
  5. SQL Not well scaling with very large size.

What is NoSQL

No SQL means not only SQL.Store retrieve, update and delete data without tabular form.Tabular form means data are not in the row or column format.


In NoSQL family, they are four type of database

  1. Document store
  2. Graph
  3. Key value
  4. Wide-column

Document store

The following are document store database
  1. Mongo DB
  2. MarkLogic
  3. couch base

Document Stores encapsulate key value pairs.Within documents, keys must unique. Every document contains a special key “ID”, which is also unique within a collection of documents and therefore identifies a document explicitly. Storing new documents containing any kind of attributes can as easily be done as adding new attributes to existing documents at runtime.


The following are graph database
  1. Neo4j
  2. InfiniteGraph

Graph databases efficient management of heavily linked data. Therefore, applications base on data with many relationships is more suited for graph databases, like recursive joins can be replaced by efficient traversals.

Key value

The following are key value store database
  1. Accumulo
  2. Hypertable
  3. HBase
  4. Cassandra

Key value stores are like maps or dictionaries where data is address by a unique key. key value stores are completely schema free. New values of any kind can add at runtime without conflicting any other stored data and without influencing system availability.


The following are wide-column database
  1. Rides
  2. Riak
  3. Dynamo DB

Column Family Stores are also known as column-oriented stores, extensible record stores, and wide columnar stores.Columns can be grouped into column families, which is especially important for data organization and partitioning. Columns and rows can be added very flexible at runtime but column families are predefined oftentimes, which leads to less flexibility than key-value stores and document stores.


I wish I could tell you that a great site of just understands key element above post-NoSQL introduction and different NO SQL database.For more details please click here Working of No-SQL.You also read my previous lecture.I hope you will understand this lecture.Thank you for reading this lecture. Hope you got the idea. please share it.