NoSQL

Question 1

Keys vs Values in NoSQL

Answer 1

Keys are like cell names.
Values are what the values are in the specific cells.

Question 2

NoSQL on Cloud

Answer 2

Microsoft Azure:
- Azure Tables
- Hadoop on Azure/Hbase

Amazon:
- SimpleDB
- DynamoDB
- Elastic MapReduce

Question 3

Document Stores in NoSQL (One of the 4 types of NoSQL DBs)

Answer 3

These are JavaScript object notation - JSON files.
Example: MongoDB

Question 4

Key-value Stores (One of the 4 types of NoSQL DBs)

Answer 4

Customer table:
Row ID: __
Address: ___
First name: ___
Last name: ___
Order ID: ___

Order table:
Order ID: ___
No. of items: ___

Can’t simply relate the two tables, need to have some foreign key

Question 5

Wide Column Stores

Answer 5

Within each row there are super columns as well as columns under the super columns.
Each super column is simply a name, while columns under the super columns have the actual data.

Question 6

Advantages and disadvantages of NoSQL

Answer 6

Advantages:
- Faster when the web load is huge
- Good for Big Data
- Good for large, public facing sites

Disadvantages:
- Performance can be low
- Not as consistent as SQL databases
- Not to be used with data on stock trades, credit cards, accounting debits and credits