CSE 444 Spring 2016
Course Calendar

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

 Show color key

March
MondayTuesdayWednesdayThursdayFriday
28
10:30-11:20 OH (YP)
TBD
14:30-15:20 Lecture
JHN 175
Introduction (small , large)
29
10:30-11:30 OH (MH)
CSE 218
30
14:30-15:20 Lecture
JHN 175
Review of relational model and SQL (small , large)
16:30-17:20 OH (MB)
CSE 584
31
Section
SimpleDB Overview
01
13:30-14:20 OH (BH)
CSE 220
14:30-15:20 Lecture
JHN 175
DBMS architecture (small , large)
23:00 Lab1 - SimpleDB BufferPool (part 1)

April
MondayTuesdayWednesdayThursdayFriday
04
10:30-11:20 OH (YP)
TBD
14:30-15:20 Lecture
JHN 175
Data storage and buffer management (small , large)
23:00 544M: Paper Review (Data Models)
05
10:30-11:30 OH (MH)
CSE 218
06
14:30-15:20 Lecture
JHN 175
Indexing (small , large)
16:30-17:20 OH (MB)
CSE 584
23:00 HW1 - RA, HeapFiles, Buffer Manager
07
Section
Indexing
08
13:30-14:20 OH (BH)
CSE 220
14:30-15:20 Lecture
JHN 175
Indexing continued (no new lecture notes)
14:30-15:20 Lecture
JHN 175
Query execution and operator algorithms (part 1) (small , large)
23:00 Lab1 - SimpleDB BufferPool (part 2)
11
10:30-11:20 OH (YP)
TBD
14:30-14:45 Lab1-Quiz
14:30-15:20 Lecture
JHN 175
Operator algorithms (part 2) (small , large, example)
12
10:30-11:30 OH (MH)
CSE 218
13
14:30-15:20 Lecture
JHN 175
Query plan cost estimation (small , large)
16:30-17:20 OH (MB)
CSE 584
23:00 544M: Paper Review (DMBS Architecture)
14
Section
Indexing and Operator Algorithms
15
13:30-14:20 OH (BH)
CSE 220
14:30-15:20 Lecture
JHN 175
Query optimization (small , large)
23:00 Lab2 - SimpleDB Operators (part 1)
18
10:30-11:20 OH (YP)
TBD
14:30-15:20 Lecture
JHN 175
Query optimization (small , large)
23:00 HW2 - Indexes and Operator Algorithm
19
10:30-11:30 OH (MH)
CSE 218
20
14:30-15:20 Lecture
JHN 175
Query optimization (small , large) Guest lecturer: Brandon Haynes
16:30-17:20 OH (MB)
CSE 584
21
Section
Query optimization
22
13:30-14:20 OH (BH)
CSE 220
14:30-15:20 Lecture
JHN 175
Transactions: Concurrency control (small , large)
25
10:30-11:20 OH (YP)
TBD
14:30-15:20 Lecture
JHN 175
Transactions: Concurrency control (small , large)
23:00 Lab2 - SimpleDB Operators (part 2)
26
10:30-11:30 OH (MH)
CSE 218
27
14:30-14:45 Lab2-Quiz
14:30-15:20 Lecture
JHN 175
Transactions: Concurrency control (small , large)
16:30-17:20 OH (MB)
CSE 584
28
Section
Transactions: Concurrency Control
29
13:30-14:20 OH (BH)
CSE 220
14:30-15:20 Lecture
JHN 175
Transactions: Concurrency control continued
23:00 HW5 - Query Optimization
23:00 544M: Paper Review (Query Optimization)

May
MondayTuesdayWednesdayThursdayFriday
02
10:30-11:20 OH (YP)
TBD
14:30-15:20 Lecture
JHN 175
Transactions: Recovery (small , large, example)
23:00 Lab3 - SimpleDB Transactions (part 1)
03
10:30-11:30 OH (MH)
CSE 218
04
14:30-15:20 Lecture
JHN 175
Transactions: Recovery continued
16:30-17:20 OH (MB)
CSE 584
05
Section
Transactions: Recovery
23:00 HW3 - Transactions: Concurrency Control
06
13:30-14:20 OH (BH)
CSE 220
14:30-15:20 Lecture
JHN 175
Transactions: Recovery continued
09
10:30-11:20 OH (YP)
TBD
14:30-15:20 Lecture
JHN 175
Transactions: Recovery ended
23:00 Lab3 - SimpleDB Transactions (part 2)
10
10:30-11:30 OH (MH)
CSE 218
11
14:30-15:20 Lecture
JHN 175
Parallel DBMSs (small , large)
16:30-17:20 OH (MB)
CSE 584
12
Section
Transaction Recovery with Aries
13
13:30-14:20 OH (BH)
CSE 220
14:30-14:45 Lab3-Quiz
14:30-15:20 Lecture
JHN 175
Parallel DBMSs continued
16
10:30-11:20 OH (YP)
TBD
14:30-15:20 Lecture
JHN 175
MapReduce (small , large)
23:00 HW4 - Transactions: Recovery
17
10:30-11:30 OH (MH)
CSE 218
18
14:30-15:20 Lecture
JHN 175
Spark (small , large)
16:30-17:20 OH (MB)
CSE 584
19
Section
Parallel processing
20
13:30-14:20 OH (BH)
CSE 220
14:30-15:20 Lecture
JHN 175
Distributed transactions (small , large)
23:00 Lab4 - SimpleDB Rollback and Recovery
23
10:30-11:20 OH (YP)
TBD
14:30-15:20 Lecture
JHN 175
Replication (small , large)
24
10:30-11:30 OH (MH)
CSE 218
25
14:30-14:45 Lab4-Quiz
16:30-17:20 OH (MB)
CSE 584
26
Section
Distributed processing and Replication
27
13:30-14:20 OH (BH)
CSE 220
14:30-15:20 Lecture
JHN 175
NoSQL: KeyValue Stores (small , large)
30
Memorial Day
23:00 544M: Paper Review (Parallel data processing)
31
10:30-11:30 OH (MH)
CSE 218
01
14:30-15:20 Lecture
JHN 175
NewSQL: In-memory OLTP (small , large)
16:30-17:20 OH (MB)
CSE 584
23:00 HW6 - Parallelism and Distribution
23:00 FINAL PROJECT MILESTONE Lab6 - SimpleDB Query Optimization or Parallel Processing
02
Section
Extra office hours for project
03
13:30-14:20 OH (BH)
CSE 220
14:30-15:20 Lecture
JHN 175
WRAP-UP

June
MondayTuesdayWednesdayThursdayFriday
06 07 08
23:00 FINAL PROJECT Lab6 - SimpleDB Query Optimization or Parallel Processing (code and report)
09 10