CSE 444 Spring 2024
Course Calendar

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

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