nosql vs sql databases differences

Following are major differences between NoSql and Sql databases

NoSQL Database SQL Databases
Open Source databases Mixed(Open source and closed source)
Different types including key-value stores, document databases, wide-column stores, and graph databases One type (SQL database) with minor variations
Examples: MongoDB, HBase, Cassandra, Neo4j Oracle, PostgreSQL, MySQL, Microsoft SQL Server, Sybase
Dynamic, with some enforcing data validation rules. Applications can add new fields on the fly, and unlike SQL table rows, dissimilar data can be stored together as necessary. For some databases (e.g., wide-column stores), it is somewhat more challenging to add new fields dynamically. Structure and data types are fixed in advance. To store information about a new data item, the entire database must be altered, during which time the database must be taken offline.
Depends on product. Some provide strong consistency (e.g., MongoDB, with tunable consistency for reads) whereas others offer eventual consistency Can be configured for strong consistency
Data Manipulation Through object-oriented API(Application Programming Interface) Data Manipulation using Specific language using Select, Insert, and Update statements
Developed in 2000s Developed in 1970s

Related Posts

Responses are currently closed, but you can trackback from your own site.

Comments are closed.

Powered by k2schools
%d bloggers like this: