CMPSCI 645: Database Design and Implementation

Schedule (subject to change)


week date day topic textbook slides homework
project
Week 1
Jan 20 Mon
Jan 22 Wed Overview & Relational Model
Ch 1
[pdf,pdf]
Week 2
Jan 27 Mon Relational Algebra and Calculus
Ch 4
[pdf]
Jan 29 Wed SQL Overview
Ch 5
[pdf]
Week 3
Feb 3 Mon
Feb 5 Wed Query Language Theory
[pdf]
Week 4
Feb 10 Mon Normalization Theory
Ch 19
[pdf]
Feb 12 Wed Disks and Files
Ch 9
[pdf]
Week 5
Feb 18 Tue Indexes
Ch 8,10
[pdf]
Feb 19 Wed Query Processing 1
Ch 13,14
[pdf]
Week 6
Feb 24 Mon Query Processing 2
Ch 14
[pdf]
Feb 26 Wed Query Processing 3
Ch 14
Week 7
Mar 2 Mon Query Optimization 1
Ch 15
[pdf]
Mar 4 Wed Query Optimization 2
Ch 15
Week 8
Mar 9 Mon Concurrency Control 1
Ch 16
[pdf][pdf]
Mar 11 Wed Concurrency Control 2 & Recovery 1
Ch 17,18
Week 9
Mar 16 Mon Spring Break
Mar 18 Wed
Week 10
Mar 23 Mon Recovery 2
Ch 17,18
[pdf] [video]
Mar 25 Wed Midterm Review
groups formed
Week 11
Mar 30 Mon Midterm Exam: 6:30-9 pm
Apr 1 Wed Project: Advanced Data Analytics
paper review
Week 12
Apr 6 Mon Data Warehousing & OLAP Ch 25
[pdf] [video]
Apr 8 Wed Data Mining & Exploration
[pdf] [video]
Week 13
Apr 13 Mon Parallel Databases
[pdf] [video]
Apr 15 Wed MapReduce Processing
[pdf] [video]
Week 14
Apr 20 Mon Patriot's Day
Apr 22 Wed Spark: Unified analytics
[pdf] [video]
Week 15
April 27 Mon Project Presentations 1
presentation
April 29 Wed Project Presentations 2
presentation
Week 16
May 3 Mon
May 5 Wed
final report