CSE 444 Winter 2024
Course Calendar

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

Show color key Show color key
January
MondayTuesdayWednesdayThursdayFriday
01 02 03
10:30-11:20 Lecture
CSE2 G01
Introduction
04
Section
SimpleDB Overview
05
10:30-11:20 Lecture
CSE2 G01
Review of relational model and SQL
08
10:30-11:20 Lecture
CSE2 G01
DBMS architecture
23:00 Lab1 - SimpleDB BufferPool (part 1)
09 10
10:30-11:20 Lecture
CSE2 G01
Data storage and buffer management
11
Section
TBD
12
10:30-11:20 Lecture
CSE2 G01
Indexing
23:00 HW1 - RA, HeapFiles, Buffer Manager
15
MLK Day
16 17
10:30-11:20 Lecture
CSE2 G01
Indexing continued
23:00 Lab1 - SimpleDB BufferPool (part 2)
18
Section
Indexing
19
10:30-11:20 Lecture
CSE2 G01
Query execution and operator algorithms (part 1)
22
10:30-11:20 Lecture
CSE2 G01
Operator algorithms (part 2)
23 24
10:30-11:20 Lecture
CSE2 G01
Operator Algorithms (cont)
25
Section
Operator Algorithms
26
10:30-11:20 Lecture
CSE2 G01
External Memory Algorithms (cont)
23:00 Lab2 - SimpleDB Operators (part 1)
29
10:30-11:20 Lecture
CSE2 G01
Query plan costs
23:00 HW2 - Indexes and Operator Algorithm
30 31
10:30-11:20 Lecture
CSE2 G01
Query Optimization: Search Space
01
Section
Query optimization
02
10:30-11:20 Lecture
CSE2 G01
Query Optimization: Algorithms
23:00 Lab2 - SimpleDB Operators (part 2)
February
MondayTuesdayWednesdayThursdayFriday
05
10:30-11:20 Lecture
CSE2 G01
Query Optimization: Selinger Algorithm vs SimpleDB
06 07
10:30-11:20 Lecture
CSE2 G01
Transactions: Concurrency control
08
Section
Transactions: Concurrency Control
09
10:30-11:20 Lecture
CSE2 G01
Transactions: Locking
23:00 HW3 - Query Optimization
12
10:30-11:20 Lecture
CSE2 G01
Transactions: Optimistic concurrency Control
23:00 Lab3 - SimpleDB Transactions (part 1)
13 14
10:30-11:20 Lecture
CSE2 G01
Transactions: Optimistic concurrency Control (cont.)
15
Section
Transactions: Multi-version CC
16
10:30-11:20 Lecture
CSE2 G01
Transactions: Optimistic concurrency Control (cont.)
19
President's Day
20 21
10:30-11:20 Lecture
CSE2 G01
Transactions: Recovery
23:00 Lab3 - SimpleDB Transactions (part 2)
22
Section
Transaction Recovery
23:00 HW4 - Transactions: Concurrency Control
23
10:30-11:20 Lecture
CSE2 G01
Transactions: Recovery cont.
26
10:30-11:20 Lecture
CSE2 G01
Transactions: Recovery with ARIES
27 28
10:30-11:20 Lecture
CSE2 G01
Transactions: Recovery wrap-up
29
Section
Transaction Recovery - Aries example Additional Example
01
10:30-11:20 Lecture
CSE2 G01
Parallel DBMSs
March
MondayTuesdayWednesdayThursdayFriday
04
10:30-11:20 Lecture
CSE2 G01
MapReduce MapReduce
05
23:00 HW5 - Transactions: Recovery
06
10:30-11:20 Lecture
CSE2 G01
Two Phase Commit
23:00 Lab4 - SimpleDB Recovery (full lab)
07
Section
Parallel Query Plans - Two-phase commit and replication
08
10:30-11:20 Lecture
CSE2 G01
Replication
11 12
23:00 HW6 - Parallelism and Distribution
13 14 15