CSE 444 Spring 2025
Course Calendar

Subscribe to this calendar (Google, iCal, etc.)

Show color key Show color key
March
MondayTuesdayWednesdayThursdayFriday
31
12:30-13:20 Lecture
MGH 389
Introduction
01 02
12:30-13:20 Lecture
MGH 389
Review of relational model and SQL
03
Section
SimpleDB Overview
04
12:30-13:20 Lecture
MGH 389
DBMS architecture
April
MondayTuesdayWednesdayThursdayFriday
07
12:30-13:20 Lecture
MGH 389
Data storage and buffer management
23:00 Lab1 - SimpleDB BufferPool (part 1)
08 09
12:30-13:20 Lecture
MGH 389
Indexing
10
Section
Lab 1 extra office hours and tips
11
12:30-13:20 Lecture
MGH 389
Indexing continued
23:00 HW1 - RA, HeapFiles, Buffer Manager
14
12:30-13:20 Lecture
MGH 389
Query execution and operator algorithms (part 1)
15 16
12:30-13:20 Lecture
MGH 389
Operator algorithms (part 2)
23:00 Lab1 - SimpleDB BufferPool (part 2)
17
Section
Indexing
18
12:30-13:20 Lecture
MGH 389
Operator Algorithms (cont)
21
12:30-13:20 Lecture
MGH 389
Query plan costs
22 23
12:30-13:20 Lecture
MGH 389
Query Optimization: Search Space
24
Section
Operator Algorithms
25
12:30-13:20 Lecture
MGH 389
Query Optimization: Algorithms
23:00 Lab2 - SimpleDB Operators (part 1)
28
12:30-13:20 Lecture
MGH 389
Query Optimization: Selinger Algorithm vs SimpleDB
23:00 HW2 - Indexes and Operator Algorithm
29 30
12:30-13:20 Lecture
MGH 389
Transactions: Concurrency control
23:00 Lab2 - SimpleDB Operators (part 2)
01
Section
Query optimization
02
12:30-13:20 Lecture
MGH 389
Transactions: Locking
May
MondayTuesdayWednesdayThursdayFriday
05
12:30-13:20 Lecture
MGH 389
Transactions: Optimistic concurrency Control
06 07
12:30-13:20 Lecture
MGH 389
Optimistic concurrency Control (cont.)
23:00 HW3 - Query Optimization
08
Section
Transactions: Concurrency Control
09
12:30-13:20 Lecture
MGH 389
Optimistic concurrency Control (cont.)
23:00 Lab3 - SimpleDB Transactions (part 1)
12
12:30-13:20 Lecture
MGH 389
Transactions: Recovery
13 14
12:30-13:20 Lecture
MGH 389
Transactions: Recovery ( extra example)
23:00 Lab3 - SimpleDB Transactions (part 2)
15
Section
Transactions: Multi-version CC
16
12:30-13:20 Lecture
MGH 389
Transactions: Recovery
23:00 HW4 - Transactions: Concurrency Control
19
12:30-13:20 Lecture
MGH 389
Parallel DBMSs
20 21
12:30-13:20 Lecture
MGH 389
Parallel DBMSs (continued)
22
Section
Transaction Recovery
23
12:30-13:20 Lecture
MGH 389
Parallel DBMSs (continued)
26
Memorial Day
27 28
12:30-13:20 Lecture
MGH 389
MapReduce
23:00 Lab4 - SimpleDB Recovery (full lab)
29
Section
Transaction Recovery - Aries example
30
12:30-13:20 Lecture
MGH 389
Spark
23:00 HW5 - Transactions: Recovery
June
MondayTuesdayWednesdayThursdayFriday
02
12:30-13:20 Lecture
MGH 389
Two Phase Commit
03 04
12:30-13:20 Lecture
MGH 389
Replication
05
Section
Parallel Query Plans , Two-phase commit and replication
06
12:30-13:20 Lecture
MGH 389
Column Stores
09
23:00 HW6 - Parallelism and Distribution
10 11 12
23:00 Final Report - Lab5 - SimpleDB Query Optimization
13