Big Data and Database Assignment

Running head: BIG DATA
Big Data
Name of the Student
Name of the University
Author Note

1BIG DATA
Table of Contents
1. Introduction......................................................................................................................2
2. SQL Database and NoSQL Database..............................................................................2
2.1. SQL Database...........................................................................................................2
2.2. NoSQL Database......................................................................................................3
3. Data Sources and Dataset Types Involved in Big data....................................................4
4. Data Characterization......................................................................................................4
5. Organizational readiness and Affordability.....................................................................5
6. Transaction Processing Requirements.............................................................................6
7. Data Privacy and Security Issues in SQL and NoSQL...................................................6
8. SQL or NoSQL?.............................................................................................................7
9. Conclusion.......................................................................................................................9
References..........................................................................................................................10

2BIG DATA
1. Introduction
A critical decision that is generally faced by the manufacturing companies that are
embarking on a big data project is to identify which database is to be chosen between the SQL
and NoSQL database. Therefore, the storage of big data undergoes a critical decision making
process that involves evaluation of both the databases in order to select an appropriate one.
Although SQL has an impressive record of accomplishment in data storage and data access,
NoSQL is making impressive gains as well. SQL is a relational database. It enables a rigid and
structured way of storing data, much similar to a phone book. Therefore, in SQL the data is
stored in an organized way as a well-designed schema minimizes the redundancy in data. This is
a major advantage of SQL. However, SQL is not suitable for storing unstructured data, and here
the NoSQL database comes into action (Sharma and Dave 2012). NoSQL database does not
contain tables and instead, all the data is stored in a single file. The data can be easily found but
not generally categorized as that of relational database. The report discusses the different
characteristics of the SQL and NoSQL database on basic of the data sources, dataset types,
organizational readiness and affordability.
2. SQL Database and NoSQL Database
2.1. SQL Database
SQL or structure query language provides a structured way of storing and retrieving data
from a database. It is a more secure option of storing data as it allows only the authorized people
to view or access data from the database. The big data type can be structures un-structured and
semi structured as well. SQL database generally stores structured Data in form of tables
containing rows and columns.