Schedule

NOTE: The schedule is tentative and is subject to change as the semester progresses.

DateTopicOptional Reading
W1: Aug 18Course Introduction, Relational Model
(slides)
Assignment 0 Released
What Goes Around Comes Around… And Around…
W1: Aug 20SQL I
(slides)
DB Systems Book: §2.2-2.3, §6.1-6.2
Fundamentals Book: §6.1-6.3
W2: Aug 25SQL II
(slides)
Assignment 0 Due
Assignment 1 Released
DB Systems Book: §6.2-6.4
Fundamentals Book: §7.1
W2: Aug 27ER Model
(slides)
DB Systems Book: §4.1-4.6
Fundamentals Book: §3-4
W3: Sep 1No Class (Labor Day) 
W3: Sep 3Relational Algebra
(slides)
Project Proposal Released
DB Systems Book: §2.4
Fundamentals Book: §8
W4: Sep 8Design Theory I
(slides)
DB Systems Book: §3.1-3.3
Fundamentals Book: §14.1-14.2
W4: Sep 10Design Theory II
(slides)
DB Systems Book: §3.3-3.6
Fundamentals Book: §14.3-14.6
W5: Sep 15Hardware, Storage
(slides)
Assignment 1 Due
DB Systems Book: §13
W5: Sep 17Midterm Review
(slides)
 
W6: Sep 22Midterm (in-class) 
W6: Sep 24Index Basics
(slides)
DB Systems Book: §14.1
W7: Sep 29B+ Tree
(slides)
Assignment 2 Released
DB Systems Book: §14.2
W7: Oct 1Hashing
(slides)
Project Proposal Due
DB Systems Book: §14.3-14.4
W8: Oct 6No Class (Fall Break) 
W8: Oct 8Multidimensional and Vector Indexes
(slides)
HNSW, PQ, DiskANN
W9: Oct 13External Merge Sort 
W9: Oct 15Join AlgorithmDB Systems Book: §15.3-15.5
W10: Oct 20No Class (Instructor traveling)
Assignment 2 Due
 
W10: Oct 22Join Algorithm, Query OptimizationDB Systems Book: §16
W11: Oct 27Query OptimizationDB Systems Book: §16
W11: Oct 29Transaction IntroFundamentals Book: §20
W12: Nov 3Transaction Processing (CC)
Project Milestone Due
DB Systems Book: §18
Fundamentals Book: §21
W12: Nov 5Transaction Processing (Recovery)DB Systems Book: §17
Fundamentals Book: §22
W13: Nov 10OLAPFundamentals Book: §29
W13: Nov 12MapReduce, Spark
Assignment 3 Released
GFS, MapReduce, Spark
W14: Nov 17Parallel & Distributed DBMSDB Systems Book: §20
Fundamentals Book: §23
W14: Nov 19NoSQL, NewSQLLSM Tree, Dynamo, Spanner
W15: Nov 24No Class (buffer space)
Assignment 3 Due
 
W15: Nov 26No Class (Thanksgiving) 
W16: Dec 1Final Review
Project Report Due
 
W16: Dec 4Final Exam Released 
W16: Dec 5Final Exam Due 

The following two textbooks can be used interchangably in reading:

  • Database Systems: The Complete Book (2nd edition)
  • Fundamentals of Database Systems