Experiential Learning in module order

Module: Parallel Databases

HW1: DDL Processing for Parallel DBMS

Write a program to process DDLs for a parallel DBMS

Assignment 1

Exercise 1

Partitioning & parallel processing

Exercise 1

Java Threads

Concurrency using Java Threads

Sample Code

Module: Storage

Exercise 2

RAID

Exercise 2

Exercise 3

Record Layout

Exercise 3

Module: Query Processing

HW2: Naive SQL Processing for Parallel DBMS

Write a program to process SQL queries in parallel

Assignment 2

HW3: Parallel JOIN Processing for Parallel DBMS

Implement the parallel JOIN algorithm for SQL queries

Assignment 3

Exercise 4

Parsing SQL

Exercise 4

Exercise 5

Converting subqueries to RA

Exercise 5

Exercise 6

Using Indexes

Exercise 6

Exercise 7

Parallel Query Processing

Exercise 7

Module: Concurrency Control

Exercise 8

Distributed Locking

Exercise 8

Module: DBMS Reliability

Exercise 9

Distributed Reliability

Exercise 9

Module: Data Warehousing

Exercise 10

Data Warehousing

Exercise 10

Exercise 11

Data Migration

Exercise 11

Module: Lambda Architecture

Exercise 12

Fact-based Data Model

Exercise 12

Module: Batch Layer : Map-Reduce

Exercise 13

Aggregation Queries in Map Reduce

Exercise 13

Exercise 14

Aggregation Queries in JCascalog

Exercise 14

Module: Speed Layer

Exercise 15

Design a Movie Recommender System

Exercise 15

Module: Big Data Ethics

Exercise 16

Big Data Ethics Case Study

Exercise 16

Module: Project

Project: Benchmarking Big Data Systems

Develop a Benchmark & evaluate at least 2 systems

Course Project