CSE 544: Daily Schedule

Note that this schedule will be altered during the quarter. Please make sure to check it every week.

Part I: The Relational Data Model
Part II: Database Systems
Part III: Database Theory
Part IV: Miscellaneous

Week of
Monday, 10:30-11:50
Wednesday 10:30-11:50
 
Week Actitivities
Paper report due (by 10:30, before the lecture) here. Homework due
(Sunday, 11:59pm)
Project milestone due
(Sunday, 11:59pm)
March 26

I.1. Introduction and SQL
lecture 1

I.2. Relational Query Languages
lecture 2
  Optional: Query Language Primer
Optional Finite Model Theory (Ch. 1 and 2)
 

M1: Form groups

April 2
I.3. Views and Constraints
lecture 3
I.4. Data Models
lecture 4
Lecture canceled
Makeup: Friday 3/30, 11-12:30, Gates Commons

  Answering queries using views Due on Friday, 3/30
What goes around comes around Due on Monday
HW1
April 9
II.5. DBMS Architecture
Storage and Indexes

lecture 5-6
II.6. Query execution
lecture 6
  The Anatomy of a Database System Due on Monday
Join processing in database systems with large main memories Due on Wednesday
 
Schedule brief meeting with Prof Suciu to discuss proposals
April 16
II.7. Query Execution
lecture 7
II.8. Database Statistics
lecture 8
  Consistently Estimating the Selectivity of Conjuncts of Predicates Due on Wednesday
 
M2: Proposals Due
April 23
II.9. Parallel Databases
lecture 9
II.10. MapReduce
lecture 10
  MapReduce Due on Wednesay  
April 30
II.10. Parallel Databases Wrapup
lecture 11
III. 12. Datalog with Negation
lecture 12
  The Declarative ImperativeDue on Monday
Optional: Datalog with negation (Chapter 14 of the AHV book)
HW2
May 7
III. 13. Query Complexity
lecture 13
III. 14. Query Containment, Equivalence
lecture 14
  Optional: book on Finite Model Theory (ps, pdf)  
M3: Project Milestone Due
May 14
III. 15.Semijoin Reductions, Theory Wrap-up
lecture 15
IV. 16. Transactions
lecture 16
     
May 21
IV. 17. Transactions
lecture 17
Lecture moved to
Friday, May 18th (previous week)
CSE403
IV. 18. Provenance
lecture 18
Lecture moved to
Friday, May 25th, CSE403
  Provenance Semirings Due on Friday  
May 28

Memorial Day

IV. 19. Privacy
lecture 19
Earlier time: 9 -10:20, CSE403
  Private Data Analysis Due on Wednesday by 9am HW3
M4: Project presentations in CSE 405 (Database Lab)
Tuesday, May 29, 8:30am-12:30pm