Database Systems Concepts (AI3613/ICE3404P, Spring 2023)

• Instructor: Qiang Yin
• TAs:
  • 王政栋： lnwzd2009(AT)sjtu.edu.cn
  • 冯书瀚： count_von(AT)sjtu.edu.cn
• Office hour
  • 7:00pm – 9:00pm, every Monday
  • 电院3号楼325

• [17/02] Introduction
• [24/02] Relational model and algebra [PDF]
• [03/03] SQL: Part (I) [PDF]
• [10/03] SQL: Part (II) [PDF]
• [17/03] SQL: Part (III) [PDF]
• [24/03] Design Theory (I) [PDF]
• [31/03] Design Theory (II) [PDF]
• [14/04] Storage Manager [PDF]
• [21/04] Indexing [PDF]
• [28/04] Query Processing (I) [PDF]
• [05/05] Query Processing (II) [PDF]
• [12/05] Query Optimization [PDF]
• [19/05] Transaction Processing [PDF]
• [26/05] Crash Recovery [PDF]
• [02/06] Final review [PDF]

• Assignment (I) [PDF]. Due: Mar. 5
• Assignment (II) [PDF]. Due: Mar. 26
• Assignment (III) [PDF]. Due: April 9
• Assignment (IV) [PDF]. Due: May 4
• Assignment (V) [PDF]. Due: May 28

• Database System Concepts, A. Silberschatz, H. Korth and S. Sudarshan, McGraw-Hill, 7th Edition, 2019

Last updated: May 26, 2023