Question

NoSQL is an alternative to the traditional relational database system. There is a significant growth of using NoSQL databases, particularly in big companies. Answer the following questions in relation to NoSQL. a) Why NoSQL is better than relational database for big data? Compare and contrast the differences between relational databases and NoSQL databases. Your discussion should touch on performance, operational workloads and scale. Compare the circumstances under which you would use one over the other and provide contrasting examples. b) Which guarantee (Consistency, Partition tolerance, availability) and can be relaxed for the following use case? 1. Data can be served on a single server. 2. Data is too big to be served on a single server and is not altered/modified after creation. 3. The data is too big to be served so should be queried within a certain time.

Answer 1

Answer:----------
a). Why NoSQL is better than relational database for big data :--------

• NoSQL is a database technology driven by Cloud Computing, the Web, Big Data and the Big Users.
• NoSQL now leads the way for the popular internet companies such as LinkedIn, Google, Amazon, and Facebook - to overcome the drawbacks of the 40 year old RDBMS.
• NoSQL Database, also known as “Not Only SQL” is an alternative to SQL database which does not require any kind of fixed table schemas unlike the SQL.
• NoSQL generally scales horizontally and avoids major join operations on the data. NoSQL database can be referred to as structured storage which consists of relational database as the subset.
• NoSQL Database covers a swarm of multitude databases, each having a different kind of data storage model. The most popular types are Graph, Key-Value pairs, Columnar and Document

Differences between relational databases and NoSQL databases:--------------
NoSQL databases, or non-relational databases, can be document based, graph databases, key-value pairs, or wide-column stores. NoSQL databases don’t require any predefined schema, allowing you to work more freely with “unstructured ata.” Relational databases are vertically scalable, but usually more expensive, whereas the horizontal scaling nature of NoSQL databases is more cost-efficient.

b)
1. Data can be served on a single server. ==>  Partition tolerance
2. Data is too big to be served on a single server and is not altered/modified after creation. ==> Consistency
3. The data is too big to be served so should be queried within a certain time. ==> Availability