Differences of SQL and NO-SQL Databases

Relational Databases:

  • DDL-data definition language
  • DML-data manipulation language
  • DCL-data control language
  • Strict Schema
  • Relational databases
  • Query optimization
  • Physical Layer
  • Began in 1980

Big companies in the world are using RDBMS -DB2, Oracle,My SQL, Sybase andTerradata

No-SQL data bases:

  • Non relational
  • Distributed
  • Schema free
  • horizontal scalable
  • Began in 2009

New generation databases-Column DB,Document DB,Key value DB

ex: MangoDB|Couch DB|Hbase-Hadoop|Cassandra

Read more details @ SQL_NOSQL_Comparision

Advertisements

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.