Advanced Database Technologies
Instructor
Peiquan Jin(金培权)
Email:
jpq@ustc.edu.cn
Teaching Assistants
姜子键:
jiangzijian@mail.ustc.edu.cn
孙远林:
syl937859459@mail.ustc.edu.cn
Lectures
Time: Thursday (9:45-12:00) [Week
2~4, 6~18]
Classroom: G3-107
Textbook
[T1] Hector Garcia-Molina, Jeffrey D. Ullman,
Jennifer Widom. Database System Implementation(2nd edition). China
Machine Press. 2010
References
[R1] Raghu
Ramakrishnan et al. Database Management Systems (Third Edition),
McGraw-Hill & Tsinghua University Press, 2003
[R2] Abraham Silberschatz
Henry F. Korth S. Sudarshan, Database System Concepts (Sixth
Edition), China Machine Press, 2012 (中文版,杨冬青 等译)
[R3] C. J. Date. An
Introduction to Database System (Eighth Edition). China Machine Press,
2003 (中文版,孟小峰 等译. )
[R4] 金培权. 数据库系统及应用, 科学出版社,2023
Assignments
Some homework
assignments, which will be announced in each class.
POLICY: all assignments should be completed within one week, i.e., before
the next class. Late submissions will be penalized 20% points.
Grading
Homework: 20%
Project: 20% [Lab
Description]
Final
Exam:
60%
Schedule & Course Notes
Week |
Date |
Class |
Contents |
Homework |
2 |
9/12 |
Thursday |
Introduction to database systems | |
3 |
9/19 |
Thursday |
Review of relational database | |
4 |
9/26 |
Thursday |
Database design--Part 1: Schema design | |
5 | 10/3 |
Thursday |
No Class |
|
6 |
10/10 |
Thursday |
Database design--Part 2: Design process | Homework #1 |
7 |
10/17 |
Thursday |
Data storage | Homework #2 |
8 |
10/24 |
Thursday |
Representation of data element | |
9 |
10/31 |
Thursday |
Representation of data element | |
10 | 11/7 |
Thursday |
Buffer management | Homework #3 |
11 | 11/14 |
Thursday |
Index structure | |
12 | 11/21 |
Thursday |
Query optimization | Homework #4 |
13 | 11/28 |
Thursday |
Query optimization | |
14 | 12/5 |
Thursday |
Query execution | |
15 | 12/12 |
Thursday |
Log & recovery | |
16 | 12/19 |
Thursday |
Concurrency control | |
17 | 12/26 |
Thursday |
Concurrency control | |
18 | 1/2 |
Thursday |
NoSQL databases | |
Review | ||||
Final exam |