Advanced Database Systems

Instructor
Peiquan Jin（金培权）
Email: jpq@ustc.edu.cn

Teaching Assistants
张宇昂, zya1412@mail.ustc.edu.cn      
李奕辰, 1806219293@qq.com   
    
Lectures
Time: Friday (14:00-16:40)
Classroom: G3-113

Textbook
杜小勇，陈红，卢卫 编. 数据库管理系统原理与实现，清华大学出版社，2024
Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom. Database System Implementation(2nd edition). China Machine Press. 2010
Literatures from recent top conferences and journals.

References
Raghu Ramakrishnan et al. Database Management Systems (Third Edition), McGraw-Hill & Tsinghua University Press, 2003
Joseph M. Hellerstein, Michael Stonebraker and James Hamilton, Architecture of a Database System, Now Publishers Inc , 2007
Peter Bailis, Joseph M. Hellerstein, Michael Stonebraker, Readings in Database Systems, 5th Edition , 2015
Christof Strauch, NoSQL Databases, www.christof-strauch.de/nosqldbs.pdf 
Shashank Tiwari, Professional NoSQL, John Wiley& Sons, Inc., 2011

Assignments
Some written assignments, which will be announced in each class. POLICY: all assignments should be completed and submitted before the next class. Late submissions will be penalized 20% points. No Submission is allowed after the Review & QA.

Grading
Homework: 20%
Project: 20% [Lab Description]
Final Exam: 60%

Schedule & Course Notes

Week	Date	Day of the Week	Contents	Homework
3	9/26	Friday	Introduction	Reading: Relational Databases: A Review
4	10/3	Friday	No Class
4	10/10	Friday	Data Storage
5	10/17	Friday	Data Representation
6	10/24	Friday	Data Representation
7	10/31	Friday	Buffer Management
8	11/7	Friday	Index Structures
9	11/14	Friday	Index Structures
10	11/21	Friday	Query Optimization
11	11/28	Friday	Join Algorithms
12	12/5	Friday	Join Algorithms
13	12/12	Friday	Transaction Management (I)
14	12/19	Friday	Transaction Management (II)
15	12/26	Friday	Transaction Management (III)
16	12/31	Friday	NoSQL Databases (I)
17	1/2	Friday	No Class
18	1/4	Friday	NoSQL Databases (II)
19	1/9	Friday	NoSQL Databases (III)
20	1/16	Friday	Review & QA
		Wednesday	Final Exam