Advanced Database Technologies
   
 
  
  
   Instructor
 
  Instructor 
  
  Jin Pei-Quan(金培权)  
   
Email: 
  jpq@ustc.edu.cn
   Teaching Assistants
 
  Teaching Assistants
  
  
  
  
  汪洪韬, PhD
  
  Email:
  wht0613@mail.ustc.edu.cn  
    
    
    
     Lectures
 
  Lectures 
  
  
    
    
    
  
  Time: Thursday (8:40-11:20) 
  
  Classroom: 
  GH-412 
    
    
    
     Textbook
 
  Textbook 
  
    
    
    
    [T1] Hector Garcia-Molina, Jeffrey D. Ullman, 
    
    
    
    Jennifer Widom. Database System Implementation(2nd edition). China 
    Machine Press. 2010
    
    
    
     References
    
    
    
    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
 
  Assignments
  
Some homework 
  assignments, which will be announced in each class. 
  
  
    
    
    
     Grading
 
  Grading 
  
Homework: 20% 
    
    
    
    Project: 20%  [Lab 
  Description]
Attendance: 10%
  Final 
    
    Exam: 
    
    
    
    50%  
    
    
    
     Schedule & Course Notes
    
    
    
    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 |