Lecture 9 - Big Data and data science

Question 1

Give examples of SQL databases

Answer 1

mySQL, MongoDB, SQL Server, PostGreSQL, Vertica

Question 1

Give examples of SQL databases

Answer 1

mySQL, SQL Server, PostGreSQL, Vertica

Question 2

Give an example of no-SQL databases

Answer 2

Graph Database (like DBPedia)

Question 3

What does API stand for?

Answer 3

Application Programmer Interface

Question 4

Under which circumstances SQL / no-SQL should be used?

Answer 4

SQL: data is structured and unchanging
no-SQL :
- storing a large volume of data with little structure
- data changes rapidly

Question 5

What is Hadoop?

Answer 5

open-source Java implementation of Map-Reduce

Question 6

What is Map-Reduce?

Answer 6

Framework to distribute/parallelize processing tasks across multiple computers

Question 7

What is Apache Spark?

Answer 7

“successor” of Hadoop

Question 8

Name the advantages of Spark over Hadoop

Answer 8

• provides real-time, in-memory processing
• much faster than Hadoop
  –> suitable for streaming real-time data

Question 9

Why SaaS?

Answer 9

• pay as you go
• scale up/down
• low maintenance
• performance, better infrastructure

(disadvantage: data privacy)