CSE 444 Winter 2025 Course Calendar

CSE 444 Winter 2025
Course Calendar

January
Monday	Tuesday	Wednesday	Thursday	Friday
06 10:30-11:20 Lecture CSE2 G01 Introduction	07	08 10:30-11:20 Lecture CSE2 G01 Review of relational model and SQL	09 Section SimpleDB Overview	10 10:30-11:20 Lecture CSE2 G01 DBMS architecture
13 10:30-11:20 Lecture CSE2 G01 Data storage and buffer management 23:00 Lab1 - SimpleDB BufferPool (part 1)	14	15 10:30-11:20 Lecture CSE2 G01 Indexing	16 Section Lab 1 Part 2 details and extra office hours	17 10:30-11:20 Lecture CSE2 G01 Indexing continued 23:00 HW1 - RA, HeapFiles, Buffer Manager
20 MLK Day	21	22 10:30-11:20 Lecture CSE2 G01 Query execution and operator algorithms (part 1) 23:00 Lab1 - SimpleDB BufferPool (part 2)	23 Section Indexing	24 10:30-11:20 Lecture CSE2 G01 Operator algorithms (part 2)
27 10:30-11:20 Lecture CSE2 G01 Operator Algorithms (cont)	28	29 10:30-11:20 Lecture CSE2 G01 Query plan costs 23:00 Lab2 - SimpleDB Operators (part 1)	30 Section Operator Algorithms	31 10:30-11:20 Lecture CSE2 G01 Query Optimization: Search Space

February
Monday	Tuesday	Wednesday	Thursday	Friday
03 10:30-11:20 Lecture CSE2 G01 Query Optimization: Algorithms 23:00 HW2 - Indexes and Operator Algorithm	04	05 10:30-11:20 Lecture CSE2 G01 Query Optimization: Selinger Algorithm vs SimpleDB	06 Section Query optimization	07 10:30-11:20 Lecture CSE2 G01 Transactions: Concurrency control 23:00 Lab2 - SimpleDB Operators (part 2)
10 10:30-11:20 Lecture CSE2 G01 Transactions: Concurrency control (cont.)	11	12 10:30-11:20 Lecture CSE2 G01 Transactions: Locking	13 Section Transactions: Concurrency Control	14 10:30-11:20 Lecture CSE2 G01 Transactions: Optimistic concurrency Control 23:00 Lab3 - SimpleDB Transactions (part 1) 23:00 HW3 - Query Optimization
17 President's Day	18	19 10:30-11:20 Lecture CSE2 G01 Optimistic concurrency Control (cont.)	20 Section Transactions: Multi-version CC	21 10:30-11:20 Lecture CSE2 G01 Transactions: Recovery 23:00 Lab3 - SimpleDB Transactions (part 2)
24 10:30-11:20 Lecture CSE2 G01 Transactions: Recovery (cont.) 23:00 HW4 - Transactions: Concurrency Control	25	26 10:30-11:20 Lecture CSE2 G01 Transactions: Recovery cont. (extra example)	27 Section Transaction Recovery and Additional Example	28 10:30-11:20 Lecture CSE2 G01 Transactions: Recovery (Aries)

March
Monday	Tuesday	Wednesday	Thursday	Friday
03 10:30-11:20 Lecture CSE2 G01 Parallel DBMSs	04	05 10:30-11:20 Lecture CSE2 G01 Parallel DBMSs (continued)	06 Section Transaction Recovery - Aries example 23:00 HW5 - Transactions: Recovery	07 10:30-11:20 Lecture CSE2 G01 MapReduce 23:00 Lab4 - SimpleDB Recovery (full lab)
10 10:30-11:20 Lecture CSE2 G01 Spark	11	12 10:30-11:20 Lecture CSE2 G01 Two Phase Commit	13 Section Parallel Query Plans , Two-phase commit and replication	14 10:30-11:20 Lecture CSE2 G01 Replication
17 23:00 HW6 - Parallelism and Distribution	18	19	20 23:00 Final Report - Lab5 - SimpleDB Query Optimization	21