Same … but Different
Different from relational databases, they are not generally built on tables and don’t require SQL.
Non-relational databases
This command will pull specific data from the table being accessed on a relational database. Business analytics professionals can use this command to see customer names, emails, ages, etc.
Select
What are the three Vs of Big Data?
Volume, Velocity, and Variety
Helps you see, understand, and improve your company’s metrics through multiple tables with unique names.
A relational database
A software framework that stores and processes large amounts of data benefiting businesses through increased computing.
Hadoop
Attribute(s) used in RDBMS to connect/join tables
Foreign key
This command specifies a certain condition desired in the outcome.
Where
Name one danger that relying on big data can carry.
Social profiling, social manipulation, the trolley problem.
The standard language across all relational database systems.
SQL
HDFS refers to
Hadoop distributed file system
Process for reducing data redundancies in tables and improving data integrity by reducing data models to different normal forms
This tells SQL how to sort the data that is selected.
Group By
What kind of NoSQL is MongoDB built on?
Document
Asking a question to a relational database; otherwise known as a
Query
A common Hadoop distributor
Cloudera, Hortonworks, MapR
The languages of relational and non-relational databases respectively.
SQL
NoSQL
This command temporarily combines two tables.
Join
What are the four major types of NoSQL technologies?
Document, key-value, column-oriented, and wide-column
Referential integrity is maintained through these types of keys:
Primary Key
Foreign Key
The four main components of Hadoop
Hadoop Distributed File system, Common, Yarn, MapReduce
A customer can have many invoices. However, invoices can have only one customer. What kind of relationship is this?
SQL Command to filter aggregated data from a GROUP BY command
HAVING
Why are NoSQL databases faster to implement compared to RDBMS?
NoSQL removes or minimizes the database design phase of the implementation.
Designed by oracle, this relational database is used for smaller operations, offering less operating system compatibility but identical support for programming languages.
MySQL
: This component processes various jobs at once by separating data into various blocks; the data outputs are sorted on the same node and then merged to write an output file.
Mapreduce