Advanced Database Technologies
Instructor
Jin Pei-Quan(金培权)
Email:
jpq@ustc.edu.cn
Teaching Assistants
汪洪韬, PhD
Email:
wht0613@mail.ustc.edu.cn
Lectures
Time: Thursday (8:40-11:20)
Classroom:
GH-412
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] 萨师煊, 王珊. 数据库系统概论(第5版), 高教出版社
[R5] 金培权. 数据库系统及应用,
科学出版社, 2023
Assignments
Some homework
assignments, which will be announced in each class.
Grading
Homework: 20%
Project: 20% [Lab
Description]
Attendance: 10%
Final
Exam:
50%
Schedule & Course Notes
Week |
Date |
Class |
Contents |
Homework |
2 | 9.18 |
Thursday |
Introduction to database systems | |
3 |
9.25 |
Thursday
|
Introduction to relational database | |
4 |
10.2 |
Thursday |
No Class | |
5 |
10.9 |
Thursday
|
Database design | |
6 |
10.16 |
Thursday
|
Database design | |
7 |
10.23 |
Thursday
|
Database design | |
8 |
10.30 |
Thursday
|
Data storage | |
9 |
11.6 |
Thursday
|
Representation of data element | |
10 | 11.13 |
Thursday |
Representation of data element | |
11 | 11.20 |
Thursday |
Buffer management | |
12 | 11.27 |
Thursday |
Index Structure | |
13 | 12.4 | Thursday | Query optimization | |
14 | 12.11 |
Thursday |
Query optimization | |
15 | 12.18 |
Thursday |
Query execution | |
16 | 12.25 |
Thursday |
Transaction management (I) | |
17 | 1.1 | Thursday | No Class | |
18 | 1.8 |
Thursday |
Transaction management (II) | |
19 | 1.15 | Thursday | Advanced Topics | |
Thursday | Final exam |