SQL and NO-SQL databases differences top list to understand quickly

SQL vs No-SQL difference given each in bullet points. SQL is format oriented, where as No-SQL works on any unformulated data. In No-SQL data in particular format is optional.

differences

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 and Terradata

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 

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.