Calendar
Click the title of a lecture to view the page with lecture notes.
For reference materials, "DMS" refers to the textbook (Database Management Systems),
denoted in purple.
Weekly problem sets are due each Wednesday night, available on Gradescope.
Lab assignment writeups are on the assigments page; submissions on Thursdays on Gradescope.
Jump to: January | February | March | April | May
January 2023
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|---|---|---|---|---|---|---|
| 15 | 16 | 17 | 18
Lecture 1: Introduction, Relational model Reading: DMS Ch. 1, 3.1-3.2 |
19
Lab 1 starts |
20 | 21 |
| 22 | 23
Lecture 2: Memory hierarchy, Disks, Buffer manager
Reading: DMS Ch. 9.1, 9.3, 9.4 |
24 | 25
Lecture 3: Files and records
Reading: DMS Ch. 9.5-9.7 Problem set 1 out |
26
Lab 1: Part 0 due (no submission) |
27 | 28 |
| 29 | 30
Lecture 4: Intro to indexes
Reading: DMS Ch. 8 |
31 |
February 2023
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|---|---|---|---|---|---|---|
| 1
Lecture 5: Tree-based indexes
Reading: DMS Ch. 10 Problem set 1 due |
2
Lab 1: Part 1 due |
3 | 4 | |||
| 5 | 6
Lecture 6: Hash-based indexes
Reading: DMS Ch. 11 |
7 | 8
Lecture 7: Relational algebra
Reading: DMS Ch. 4.1-4.2 Problem set 2 due |
9
Lab 1: Final due |
10 | 11 |
| 12 | 13
Lecture 8: SQL
Reading: DMS Ch. 5 |
14 | 15
Lecture 9: SQL II
Reading: DMS Ch. 5 Problem set 3 due |
16
Lab 2: Part 1 due |
17 | 18 |
| 19 | 20
Lecture 10: Query Evaluation I
Reading: DMS Ch. 12.2, 13.1-13.4 |
21 | 22
Lecture 11: Query Evaluation II
Reading: DMS Ch. 14.0-14.6 Problem set 4 due |
23
Lab 2: Part 2 due |
24 | 25 |
| 26 | 27
Lecture 12: Query Optimization I
Reading: DMS Ch. 12.1, 12.4-12.5,15.1,15.3 |
28 |
March 2023
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|---|---|---|---|---|---|---|
| 1
Lecture 13: Query Optimization II
Reading: DMS Ch. 15.2,15.4 Problem set 5 due |
2
Lab 2: Final due |
3 | 4 | |||
| 5 | 6
Lecture 14: Midterm (in class) |
7 | 8
Lecture 15: Query Optimization III
Reading: DMS Ch. 15.4-15.6 Problem set 6 out |
9
Lab 3: Part 1 due |
10 | 11 |
| 12 | 13 Spring Break |
14 | 15 | 16 | 17 | 18 | 19 | 20
Lecture 16: Transactions I
Reading: DMS Ch. 16.1-16.6, 17.1 |
21 | 22
Lecture 17: Transactions II
Reading: DMS Ch. 17.2-17.5 Problem set 6 due |
23
Lab 3: Part 2 due |
24 | 25 |
| 26 | 27
Lecture 18: Transactions III
Reading: DMS Ch. 17.6, 16.7 |
28 | 29
Lecture 19: Recovery
Reading: DMS Ch. 18.1-18.6 Problem set 7 due |
30
Lab 3: Final due |
31 |
April 2023
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | 3
Lecture 20: Database Design I
Reading: DMS Ch. 2.1-2.5,3.5 |
4 | 5
Lecture 21: Database Design II
Reading: DMS Ch. 19.1-19.3 Problem set 8 due |
6
Lab 4: Part 1 due |
7 | 8 |
| 9 | 10
Lecture 22: Database Design III
Reading: DMS Ch. 19.4-19.7 |
11 | 12
Lecture 23: OO and XML
Reading: DMS Ch. 23, 27.6-27.8, Object-Relational DBMS - The Next Wave Problem set 9 due |
13
Lab 4: Final due |
14 | 15 |
| 16 | 17
Lecture 24: Distributed and Parallel DBs
Reading: DMS Ch. 22.1-22.3, 22.8, 22.10-22.12, 22.14.1 |
18 | 19
Lecture 25: NoSQL
Reading: References (skim only): Problem set 10 due |
20 | 21 | 22 |
| 23 | 24
Lecture 26: OLAP and Data Analytics
Reading: DMS Ch. 25.1-25.5,25.7,25.9 |
25 | 26
Lecture 27: Last class!
Problem set 11 due |
27
Lab 5 due |
28
Take-home Final Exam available |
29 |
May 2023
| Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4
Graduating seniors at CMC, Pitzer, Pomona, and Scripps: |
5
Graduating seniors at HMC: |
6 | |
| 7 | 8 | 9 | 10
Remaining students: |
11 | 12 | 13 |