Advanced Database Technologies
Instructor
Jin Pei-Quan(金培权)
Email:
jpq@ustc.edu.cn
Teaching Assistants
汪洪韬, PhD
Email:
wht0613@mail.ustc.edu.cn
Lectures
Time: Wednesday (9:45-12:00)
Classroom: 202
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.
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]
Attendance: 10%
Final
Exam:
50%
Schedule & Course Notes
Week |
Date |
Class |
Contents |
Homework |
1 |
2.26 |
Wednesday |
Introduction to database systems | |
2 |
3.5 |
Wednesday |
Introduction to relational database | |
3 |
3.12 |
Wednesday |
Database design | |
4 |
3.19 |
Wednesday |
Database design | Homework #1 |
5 |
3.26 |
Wednesday |
Database design | |
6 |
4.2 |
Wednesday |
Data storage | |
7 |
4.9 |
Wednesday |
Representation of data element | |
8 | 4.16 |
Wednesday |
Representation of data element | |
9 |
4.23 |
Wednesday |
Buffer management | |
10 | 4.30 |
Wednesday |
Index Structure | |
11 | 5.7 |
Wednesday |
No Class | |
12 | 5.14 | Wednesday | Query optimization | |
13 | 5.21 |
Wednesday |
Query optimization | |
14 | 5.28 |
Wednesday |
Query execution | |
15 | 6.4 |
Wednesday |
Transaction management | |
16 | 6.11 | Wednesday | Transaction management | |
17 | 6.18 |
Wednesday |
Transaction management | |
Review | ||||
Final exam |