Courses > Database 2009F

Database Systems (資料庫系統) Fall Semester, 2009 Computer Science and Information Engineering Department  資訊工程學系 National Taiwan University 台灣大學 Lecture: Wed 9:10 ~ 12:00 Lecture Rooms: CSIE 104 (朱浩華) and CSIE 101 (徐宏民)

www.flickr.com

Course Description:

This is the first course in database management systems. Students will learn (1) how to use a relational databases and (2) how to build key components of a relational database. Students will also learn some advance topics, such as query optimization and transaction management, etc. Since this is a CSIE course, it will place more emphasis on the systems aspects of the database (2/3 of the course materials) rather than in the applications aspects of database systems (1/3 of the course materials). This course will be taught with a mixture of English/Chinese, and students are encouraged to ask questions either in Chinese or English.

Prerequisite:

• Data structure and algorithms
• Proficiency in C++ programming

Required Textbook:

• "Database Management Systems, Third Edition"by Ramakrishnan and Gehrke.  It is available from 新月 and (and other bookstores).

Teaching Staff and Office Hours:

• Instructors:
  • Winston Hsu (徐宏民), Room 512, email: winston (AT) csie.ntu.edu.tw
  • Hao-hua Chu (朱浩華), Room 518, email: hchu (AT) csie.ntu.edu.tw

• Teaching Assistants
  • Kerry Chang, Room 219, Office Hours: Mon 14:20~16:20, email: b94007 (at) csie ntu edu tw
  • Fang-Erh Lin (林芳而), Room 506, Office Hours: Wed 15:20~17:20, email: espblue (at) gmail com
  • Ming-Kuang Tsai (蔡旻光), Room 506, Office Hours: Thu 13:20~15:20, email: mingkuang.tsai (at) gmail com

Lecture Schedule:

	Lecture Topics	Readings	Assignments
9/16	Introduction (ppt, pdf)	R&G Chapter 1
9/23	ER model (ppt)	R&G Chapter 2 (except 2.7)	Assignment #1 ER (pdf)
9/30 (Prof. Chu away at UbiComp)	Relational model (ppt, pdf)	R&G Chapter 3
10/7	Relational algebra (ppt, pdf); Answers to exercises in the lecture (pdf)	R&G Chapter 4.1~4.2
10/14	SQL (ppt, pdf); Intro to MySQL (pdf)	R&G Chapter 5	Assignment #2 SQL (pdf) Related file: DB
10/21	SQL (finish previous slides)	R&G Chapter 5
10/28	Storage and indexing overview (ppt, pdf)	R&G Chapter 8
11/4	Disks and files (ppt, pdf)	R&G Chapter 9	Assignment #3 Heap File Pages programming (pdf) Related file: hfpage , slide
11/11	Midterm exam (in class, closed book)	Cover Chapters 1, 2<except 2.7>, 3, 4.1, 4.2, 5, 8
11/18	Tree-structured indexing (ppt, pdf)	R&G Chapter 10	Assignment #4 Buffer Manager programming (pdf) Related file: BufMgr , slide
11/25	Hash-based Indexing (ppt, pdf)	R&G Chapter 11
12/2	Query Evaluation Overview(ppt, pdf)	R&G Chapter 12	Assignment #5 B+ Tree programming (pdf, slide) Related file: btree (updated: 12/12 10:57pm)
12/9	External Sorting & Join Evaluation Algorithms (ppt, pdf)	R&G Chapters 13 & 14.4
12/16	Transaction management overview (ppt, pdf)	R&G Chapters 16
12/23
12/30	Concurrency control (ppt, pdf)	R&G Chapter 17.1 ~ 17.4	Assignment #6 Sort-merge join programming (pdf, slide) Related file: smjoin (updated: 12/29 03:00pm)
1/6	Crash recovery (ppt, pdf)	R&G Chapters 18
1/13	Final Exam (in class, closed book)	Cover Chapters 9-13, 14.4, 16, 17.1~17.4, 18

Communications with teaching staff:

• Please check the course homepage regularly for announcements
• BBS ptt.cc / CSIE_DBMS : Please post your questions (assignments, final project, etc.) on BBS.  Please read posted messages before posting new questions.  Do not spam ?? you should post questions related to this course ONLY.  TAs will try to respond to your questions as quickly as possible.
• Send email to TAs or the instructor.
• Come to office hours

Grading for Database Systems:

• Assignments (30% Grade)
• Midterm Exam (35% Grade)
• Final Exam (35% Grade)

Announcements

• 01/18: Grades for final exams posted.
• 01/18: Assignment 3 grade and testing program.
• 01/13: Assignment 6 grade and testing program.
• 12/9: Assignment 4 grade and testing program.
• 11/4: Solution1 and grade posted.
• 9/12: Website created.