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
29 11:30-12:20 Lecture * * 1. Introduction	30	31 11:30-12:20 Lecture * * 2. Review of relational model and SQL	01 Section SimpleDB Overview	02 11:30-12:20 Lecture * * 3. DBMS architecture

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

May
Monday	Tuesday	Wednesday	Thursday	Friday
03 11:30-12:20 Lecture * * 15. Transactions: Locking	04	05 11:30-12:20 Lecture * * 16-17. Transactions: Optimistic concurrency Control	06 Section Transactions: Concurrency Control and Lab 3 intro 23:00 HW3 - Query Optimization	07 11:30-12:20 Lecture * * 16-17. Transactions: Optimistic concurrency Control (continued) 23:00 Lab3 - SimpleDB Transactions (part 1)
10 11:30-12:20 Lecture * * 18. Transactions: Recovery	11	12 11:30-12:20 Lecture * * 19. Transactions: Recovery (cont.)	13 Section Transactions: Multi-version CC and Lab 3 office hours	14 11:30-12:20 Lecture * * 20. Transactions: Recovery (cont.) 23:00 Lab3 - SimpleDB Transactions (part 2)
17 11:30-12:20 Lecture * * 21. Transactions: Recovery (extra example) 23:00 HW4 - Transactions: Concurrency Control	18	19 11:30-12:20 Lecture * * Parallel DBMSs	20 Section Transaction Recovery with Aries	21 11:30-12:20 Lecture * * Parallel DBMSs (continued)
24 11:30-12:20 Lecture * * MapReduce	25	26 11:30-12:20 Lecture * * Spark	27 Section Parallel processing	28 11:30-12:20 Lecture * * Two Phase Commit 23:00 Lab4 - SimpleDB Rollback and Recovery
31 Memorial Day	01 23:00 HW5 - Transactions: Recovery	02 11:30-12:20 Lecture * * Replication	03 Section Two-phase commit and replication 9:30-23:00 Lab 2 + 3 Quiz	04 11:30-12:20 Lecture * * NewSQL and Advanced Topics

June
Monday	Tuesday	Wednesday	Thursday	Friday
07 23:00 HW6 - Parallelism and Distribution	08	09	10 Final Report - Lab5: SimpleDB Query Optimization Time 23:00	11