NoSQL vs SQL

RDBMS VS NOSQL DATABASES SQL Databases NOSQL Databases SQL One type (SQL database) with minor variations. Different types including key-value stores, document databases, wide-column stores, and graph databases. Types Developed in 1970s to deal with first wave of data storage applications Developed in 2000s to deal with limitations of SQL databases, concerning scale, replication and unstructured data storage History PostgreSQL mongoDB MYSQL ORACLE A P A C HE cassandra HB ASE MYSQL, Postgres, Oracle Database Examples MongoDB, Cassandra, HBase, Neo4j To store information about a new data item, the entire database must be altered, during which time the database must be taken offline. Records can add new information on the fly, and unlike SQL table rows, dissimilar data can be stored Schemas together as necessary. PostgreSQL MYSQL Mix of open-source (e.g., Postgres, MYSQL) and closed source (e.g., Oracle Database) Development Model Open-source Yes, updates can be configured to complete entirely or not at all Supports Transactions In certain circumstances and at certain levels (e.g., document level vs. database level) Specific language using Select, Insert, and Update statements, e.g. SELECT fields FROM table Data Manipulation Through object-oriented APIS WHERE... ŽntelliPaat Intellipaat is fast growing low cost e-learning and online training company with +100 courses for learners. Intellipaat provides 24*7 support and life time access to courses that helps learners to take big leap in their career. Intellipaat trainers are + 18 yrs SME's