Question

Scientifically and objectively compare and contrast relational databases and NoSQL so IT professionals can choose which one is more appropriate in a situation particular to them.

Answer 1

Parameter SQL NOSQL Definition SQL databases are primarily called RDBMS or Relational Databases NoSQL databases are primarily called as Non- relational or distributed database Design for Traditional RDBMS uses SQL NoSQL database system consists of various kind of syntax and queries to analyze and database technologies. These databases were get the data for further insights. developed in response to the demands presented They are used for OLAP systems. for the development of the modern application. Query Language Structured query language (SQL) No declarative query language Type SQL databases are table based databases NoSQL databases can be document based, key- value pairs, graph databases Schema SQL databases have a predefined NoSQL databases use dynamic schema for schema unstructured data. Ability to scale NoSQL databases are horizontally scalable SQL databases are vertically scalable Examples Oracle, Postgres, and MS-SQL. MongoDB, Redis, , Neo4j, Cassandra, Hbase. Best suited for It is not good fit complex queries. An ideal choice for the complex query intensive environment. Hierarchical data storage SQL databases are not suitable for hierarchical data storage. More suitable for the hierarchical data store as it supports key-value pair method. Variations One type with minor variations. Many different types which include key-value stores, document databases, and graph databases. Development It was developed in the 1970s to Year deal with issues with flat file storage Developed in the late 2000s to overcome issues and limitations of SQL databases.

Open-source Open-source A mix of open-source like Postgres & MySQL, and commercial like Oracle Database. Consistency It should be configured for strong It depends on DBMS as some offers strong consistency. consistency like MongoDB, whereas others offer only offers eventual consistency, like Cassandra. Best Used for RDBMS database is the right NoSQL is a best used for solving data availability option for solving ACID problems. problems Importance It should be used when data validity is super important Use when it's more important to have fast data than correct data Best option when you need to support dynamic queries Use when you need to scale based on changing requirements Hardware Specialized DB hardware (Oracle Exadata, etc.) Commodity hardware Network Highly available network (Infiniband, Fabric Path, etc.) Commodity network (Ethernet, etc.) Storage Type Highly Available Storage (SAN, RAID, etc.) Commodity drives storage (standard HDDs, JBOD) Best features Cross-platform support, Secure and free Easy to use, High performance, and Flexible tool. Top Companies Hootsuite, CircleCl, Gauges Airbnb, Uber, Kickstarter Using Average salary The average salary for any professional SQL Developer is $84,328 per year in the U.S.A. The average salary for "NoSQL developer" ranges from approximately $72,174 per year ACID vs. BASE Model ACID(Atomicity, Consistency, Isolation, and Durability) is a standard for RDBMS Base (Basically Available, Soft state, Eventually Consistent) is a model of many NoSQL systems