Advanced Database Systems

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

Teaching Assistants
张宇昂, zya1412@mail.ustc.edu.cn      
王骏昊, wjh12345@mail.ustc.edu.cn
辛梦晴, xinmq@mail.ustc.edu.cn    
    
Lectures
Time: Monday (19:30-21:55) 
Classroom: G3-108

Textbook
金培权 等. 高级数据库系统，科学出版社，2026
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
金培权. 数据库系统及应用, 科学出版社, 2023

Assignments
No after-class assignments for this course. Several in-class quizzes will be given. Policy: Late submissions will not be accepted.  

Grading
In-Class Quizzes: 30%
Project: 20%
Final Exam: 50%

Schedule & Course Notes

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