CS 639 Data Management for Data Science Lecture

CS 639: Data Management for Data Science Lecture 12: No. Sql and Key. Value stores Theodoros Rekatsinas Slides borrowed by Kathleen Durant 1

Today’s Lecture 1. Intro to No. SQL 2. No. SQL Assumptions and the CAP Theorem 3. Strengths and weaknesses of No. SQL 4. Example: Mongo. DB 2

1. Intro to No. SQL 3

Taxonomy of No. SQL

Typical No. SQL architecture

2. No. SQL Assumptions and the CAP Theorem 6

CAP theorem for No. SQL • What the CAP theorem really says: If you cannot limit the number of • How it is interpreted: You must always give something up: consistency, faults and requests can be directed to any server and you insist on serving every request you receive then you cannot possibly be consistent availability or tolerance to failure and reconfiguration

CAP theorem for No. SQL

9

Sharding of data

Replica Sets

3. Strengths and weaknesses of No. SQL 12

How does No. SQL vary from RDBMS?

Benefits of No. SQL

Benefits of No. SQL

Drawbacks of No. SQL

Drawbacks of No. SQL

ACID or BASE

4. Mongo. DB 19

What is Mongo. DB?

Functionality of Mongo. DB

Why use Mongo. DB?

Mongo. DB: CAP approach

Mongo. DB Data model: Hierarchical Objects

Schema Free

Mongo. DB Features

Index Functionality

CRUD operations

Query operations

Aggregated functionality

Map reduce functionality

Summary