DEPARTMENT OF COMPUTING

CS 4307: Database Systems

Spring 2022 Reading Project
Jan 10–14 2: relational model SQL: simple queries on single tables
Jan 17–21 (MLK Day) 3: introduction to SQL SQL: aggregation on single tables
Jan 24–28 4: intermediate SQL SQL: joins
Jan 31–Feb 4 5: advanced SQL SQL: advanced topics
Feb 7–11 7: relational database design
Feb 14–18 13: data storage structures social network
Feb 21–25 (Presidents’ Day) 14: indexing
Feb 28–Mar 4 btree iterator
Mar 7–11 15: query processing query execution: single tables
Mar 14–18 (Spring break)
Mar 21–25 16: query optimization query execution: aggregation
Mar 28–Apr 1 query execution: joins 1
Apr 4–8 17: transactions query execution: joins 2
Apr 11–15 18: concurrency control query execution: advanced
Apr 18–22 19: recovery system final project
Apr 25–29 (Wednesday last day) in-memory databases

All readings are from the textbook.


Resources

Last Updated 02/28/2022