Advanced Database Systems
Instructor
Peiquan Jin（金培权）
Email:
jpq@ustc.edu.cn
Teaching Assistants
汪洪韬, wht0613@mail.ustc.edu.cn
陆铭琛,
lmc123@mail.ustc.edu.cn
王俊力,
junliwang@mail.ustc.edu.cn
Lectures
Time: Tuesday (9:45-12:00)
Classroom: G3-109
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 |
| 2 | 9/10 | Tuesday | Introduction | Reading: Relational Databases: A Review |
| 3 | 9/17 | Tuesday | No Class | |
| 4 | 9/24 | Tuesday | Data Storage | |
| 4 | 9/29 | Sunday | Data Representation | |
| 5 | 10/1 | Tuesday | No Class | |
| 6 | 10/8 | Tuesday | Data Representation | Homework #1 |
| 7 | 10/15 | Tuesday | Buffer Management | Homework #2 |
| 8 | 10/22 | Tuesday | Index Structures | |
| 9 | 10/29 | Tuesday | No Class | |
| 10 | 11/5 | Tuesday | Index Structures | Homework #3 |
| 11 | 11/12 | Tuesday | Query Optimization | |
| 12 | 11/19 | Tuesday | Join Algorithms | |
| 13 | 11/26 | Tuesday | Join Algorithms | Homework #4 |
| 14 | 12/3 | Tuesday | Transaction Management (I) | |
| 15 | 12/10 | Tuesday | Transaction Management (II) | Homework #5 |
| 16 | 12/17 | Tuesday | NoSQL Databases (I) | |
| 17 | 12/24 | Tuesday | NoSQL Databases (II) | |
| 18 | 12/31 | Tuesday | NoSQL Databases (III) | |
| 19 | Review & QA | |||
| 20 | Final Exam |