Lecture 2

Question 1

Scaling methods

Answer 1

• Scaling up - Vertical scaling
• Scaling out - Horizontal scaling

Question 2

Sharding?

Answer 2

is a database architecture pattern related to horizontal partitioning - the practice of separating one table’s rows into
multiple different tables, known as partitions.
Concept of sharding does not sit well with relational databases

Question 3

NoSQL database

Answer 3

“Not Only SQL”
- do not use SQL as their primary query language
- providing access by means of Application Programming Interfaces (APIs).

Question 4

Types of NoSQL database

Answer 4

Four main types each has model:

• Key-value
• Document
• Wide column stores
• Graph

Question 5

Data warehouse

Answer 5

• A system used for reporting and data analysis
• Core component of business intelligence

Question 6

ETL (Extract, Transform, Load)

Answer 6

ETL (Extract, Transform, Load)

Question 7

Data mart

Answer 7

A simple form of a data warehouse that is Focused on a single subject (or functional area)

Question 8

Data Lakes

Answer 8

A storage repository of data holds a vast mount of raw data in its native
format until it is needed. There is no hierarchy or organization among
the individual pieces of data.

Question 9

Data Integration

Answer 9

A set of processes used to retrieve and combine
data from disparate sources into meaningful and valuable
information.

Question 10

Big Data Integration techniques

Answer 10

• Schema Mapping
• Record Linkage
• Data Fusion

Question 11

Steps in Data Science Process

Answer 11

• Exploring Data
• Data Pre-processing

Question 12

CRISP-DM: Cross Industry Standard Process for Data Mining

Answer 12

A well adopted methodology for data mining
Six Phases
- Business understanding
- Data understanding
- Data preparation
- Modeling
- Evaluation
- Deployment