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

 Show color key

 Hide color key

Lecture

Section

Lab

Exam

Homework

Office Hour

Other

Holiday

March
Monday	Tuesday	Wednesday	Thursday	Friday
30 11:30-12:20 Lecture 1. Introduction 12:30-13:20 OH (Dan) 13:30-14:20 OH (Kexuan)	31 15:00-15:50 OH (Ying)	01 11:30-12:20 Lecture 2. Review of relational model and SQL 15:30-16:20 OH (Yuchong)	02 Section (Steven, Yin Yin) SimpleDB Overview 15:30-16:20 OH (Remy)	03 11:30-12:20 Lecture 3. DBMS architecture 12:30-13:20 OH (Steven) 15:00-15:50 OH (Yin Yin)

April
Monday	Tuesday	Wednesday	Thursday	Friday
06 11:30-12:20 Lecture 4. Data storage and buffer management 12:30-13:20 OH (Dan) 13:30-14:20 OH (Kexuan) 23:00 Lab1 - SimpleDB BufferPool (part 1)	07 15:00-15:50 OH (Ying)	08 11:30-12:20 Lecture 5. Indexing 15:30-16:20 OH (Yuchong)	09 Section (Steven, Yin Yin) Extra office hours for Lab 1 15:30-16:20 OH (Remy)	10 11:30-12:20 Lecture Indexing continued 12:30-13:20 OH (Steven) 15:00-15:50 OH (Yin Yin) 23:00 HW1 - RA, HeapFiles, Buffer Manager
13 11:30-12:20 Lecture 7. Query execution and operator algorithms (part 1) 12:30-13:20 OH (Dan) 13:30-14:20 OH (Kexuan)	14 15:00-15:50 OH (Ying)	15 11:30-12:20 Lecture 8. Operator algorithms (part 2) 15:30-16:20 OH (Yuchong) 23:00 Lab1 - SimpleDB BufferPool (part 2)	16 Section (Steven, Yin Yin) Indexing 15:30-16:20 OH (Remy)	17 11:30-12:20 Lecture 9. External Memory Algorithms (part 3) 12:30-13:20 OH (Steven) 15:00-15:50 OH (Yin Yin) 23:00 544M: Paper Review (Data Models)
20 11:30-12:20 Lecture 10. Query Optimization: cost estimation 12:30-13:20 OH (Dan) 13:30-14:20 OH (Kexuan)	21 15:00-15:50 OH (Ying)	22 11:30-12:20 Lecture 11. Query Optimization: cost estimation (continued) 15:30-16:20 OH (Yuchong)	23 Section (Steven, Yin Yin) Operator Algorithms 15:30-16:20 OH (Remy)	24 11:30-12:20 Lecture 12. Query Optimization: Search Space 12:30-13:20 OH (Steven) 15:00-15:50 OH (Yin Yin) 23:00 Lab2 - SimpleDB Operators (part 1)
27 11:30-12:20 Lecture 13. Query optimization: Search Algorithms 12:30-13:20 OH (Dan) 13:30-14:20 OH (Kexuan) 23:00 HW2 - Indexes and Operator Algorithm	28 15:00-15:50 OH (Ying)	29 11:30-12:20 Lecture 14. Transactions: Concurrency control 15:30-16:20 OH (Yuchong)	30 Section (Steven, Yin Yin) Query optimization 15:30-16:20 OH (Remy)	01 11:30-12:20 Lecture 15. Transactions: Concurrency control 12:30-13:20 OH (Steven) 15:00-15:50 OH (Yin Yin) 23:00 Lab2 - SimpleDB Operators (part 2)

May
Monday	Tuesday	Wednesday	Thursday	Friday
04 11:30-12:20 Lecture 16-18. Transactions: Optimistic concurrency Control 12:30-13:20 OH (Dan) 13:30-14:20 OH (Kexuan)	05 15:00-15:50 OH (Ying)	06 11:30-12:20 Lecture 16-17. Transactions: Optimistic concurrency Control (continued) 15:30-16:20 OH (Yuchong)	07 Section (Steven, Yin Yin) Transactions: Concurrency Control 15:30-16:20 OH (Remy) 23:00 HW3 - Query Optimization	08 11:30-12:20 Lecture Transactions: Optimistic concurrency control continued 12:30-13:20 OH (Steven) 15:00-15:50 OH (Yin Yin) 23:00 544M: Paper Review (DMBS Architecture)
11 11:30-12:20 Lecture 19. Transactions: Recovery 12:30-13:20 OH (Dan) 13:30-14:20 OH (Kexuan) 23:00 Lab3 - SimpleDB Transactions (part 1)	12 15:00-15:50 OH (Ying)	13 11:30-12:20 Lecture 20. Transactions: Recovery 15:30-16:20 OH (Yuchong)	14 Section (Steven, Yin Yin) Transactions: Multi-version CC and Lab 3 office hours 15:30-16:20 OH (Remy)	15 11:30-12:20 Lecture 21. Transactions: Recovery 12:30-13:20 OH (Steven) 15:00-15:50 OH (Yin Yin) 23:00 544M: Paper Review (Query Optimization)
18 11:30-12:20 Lecture MapReduce 12:30-13:20 OH (Dan) 13:30-14:20 OH (Kexuan) 23:00 HW4 - Transactions: Concurrency Control	19 15:00-15:50 OH (Ying)	20 11:30-12:20 Lecture Parallel DBMSs 15:30-16:20 OH (Yuchong)	21 Section (Steven, Yin Yin) Transaction Recovery with Aries 15:30-16:20 OH (Remy)	22 11:30-12:20 Lecture Two Phase Commit 12:30-13:20 OH (Steven) 15:00-15:50 OH (Yin Yin) 23:00 Lab3 - SimpleDB Transactions (part 2)
25 Memorial Day	26 15:00-15:50 OH (Ying)	27 11:30-12:20 Lecture Advanced Topics: Replication 15:30-16:20 OH (Yuchong) 23:00 HW5 - Transactions: Recovery	28 Section (Steven, Yin Yin) Parallel processing 15:30-16:20 OH (Remy)	29 11:30-12:20 Lecture Advanced Topics 12:30-13:20 OH (Steven) 15:00-15:50 OH (Yin Yin) 23:00 544M: Paper Review (Parallel data processing)

June
Monday	Tuesday	Wednesday	Thursday	Friday
01 11:30-12:20 Lecture Advanced Topics 12:30-13:20 OH (Dan) 13:30-14:20 OH (Kexuan) 23:00 Lab4 - SimpleDB Rollback and Recovery	02 15:00-15:50 OH (Ying)	03 11:30-12:20 Lecture Query Optimization Review for Lab5 15:30-16:20 OH (Yuchong)	04 Section (Steven, Yin Yin) Two-phase commit and replication 15:30-16:20 OH (Remy)	05 11:30-12:20 Lecture Review 12:30-13:20 OH (Steven) 15:00-15:50 OH (Yin Yin) 23:00 Lab5 - Optimization (Milestone)
08 13:00-14:00 OH (Steven) 15:00-16:00 OH (Yin Yin) 23:00 HW6 - Parallelism and Distribution	09 14:00-15:00 OH (Remy)	10 15:30-16:20 OH (Yuchong) 17:00-18:00 OH (Kexuan)	11 23:00 Lab5 - Optimization (final)	12