CSE 444 Spring 2023
Course Calendar

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

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