Advanced Database Technologies
Instructor
Jin Pei-Quan(金培权)
Email:
jpq@ustc.edu.cn
Teaching Assistants
王晓亮, Postdoc
Email:
wxl147@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]
Final
Exam:
60%
Schedule & Course Notes
Week |
Date |
Class |
Contents |
Homework |
1 |
2.28 |
Wednesday |
Introduction to database systems | |
2 |
3.6 |
Wednesday |
Introduction to relational database | |
3 |
3.13 |
Wednesday |
Database design--Part 1: Schema design | |
4 |
3.20 |
Wednesday |
No Class |
|
5 |
3.27 |
Wednesday |
Database design--Part 1: Schema design | |
6 |
4.3 |
Wednesday |
Database design--Part 2: Database-design process | Homework #1 |
7 |
4.10 |
Wednesday |
Data storage | Homework #2 |
8 | 4.17 |
Wednesday |
Representation of data element | |
9 |
4.24 |
Wednesday |
Representation of data element | |
10 | 5.1 |
Wednesday |
No Class | |
11 | 5.8 |
Wednesday |
No Class | |
12 | 5.15 | Wednesday | Buffer management | |
13 | 5.22 |
Wednesday |
Index Structure | |
14 | 5.29 |
Wednesday |
Query optimization | |
15 | 6.5 |
Wednesday |
Query execution | |
16 | 6.12 | Wednesday | Transaction management I | |
17 | 6.19 |
Wednesday |
Transaction management II | |
18 | 6.26 | Wednesday | Review | |
19 | Final exam |