CS44 - Database Management Systems
Spring 2014

Announcements

  • The Final Exam Study Session will be in Science Center 256 on Friday, May 9 from 1-3pm.

This course is being reintroduced to the CS curriculum after a 7-year hiatus. As this is a new course with a new professor, this semester will have some bumps, so please be patient. If are you uncomfortable with that fact that the syllabus/schedule is likely to alter, you may not want to take this course in the current semester. I will make every effort to ensure that is a smooth semester; please contact me if you would like to discuss this in detail.

This syllabus is a living document; please be aware that many elements on this page will change throughout the semester, including the course schedule. It is the student's responsibility to review this page periodically for updates.

I value any and all student feedback. If you would like to provide anonymous course feedback, use this submission form here. Please be constructive in any comments so that I can adjust the course as best possible.



Schedule

For the reading assignments the section numbers are inclusive, so "1.1-1.1.2" means you should read all the sections from 1.1 up to and including section 1.1.2. This is a tentative schedule, it will change as we go.


WEEK DAY ANNOUNCEMENTS TOPIC & READING LAB            
1 Jan 21   Introduction to Databases;
Data Storage/Organization
  • Chapter 1
  • Chapter 8-8.2
Jan 23  
2 Jan 28   Data Storage and Buffer Management
  • Chapter 9
 Lab 0: Binary I/O Warm-up
Jan 30 Drop/Add ends (Jan 31)
3 Feb 04   Lab 1: Buffer Manager
Feb 06  
4 Feb 11   ER Model
  • Chapter 2
Feb 13  
5 Feb 18   Relational Model
  • Chapter 3
 Lab 2: Homework - Disks, Buffers, ER Models
Feb 20  
6 Feb 25   Relational Algebra
 Lab 3: Heap Page
Feb 27  
7 Mar 04   Lab 4: Homework - Relational Models, Relational Algebra
Mar 06 No class
 

Mar 11

Spring break

Mar 13
8

Mar 18

Midterm (In class) 2:40pm–4:40pm Sci 128
Mar 20   Indexing
  • Chapter 10
  • Chapter 11
 Lab 5 warm-up exercise
9 Mar 25   Lab 5: B+ Tree Index
Mar 27 CR/NC and Withdraw
deadline (Mar 28)
10 Apr 01  
Apr 03   SQL
11 Apr 08  
Apr 10  
12 Apr 15   Sorting; Query Evaluation
  • Chapter 12
  • Chapter 13
 Lab 6: Homework - Indexing, SQL, Sorting
Apr 17  
13 Apr 22   Query Optimization
  • Chapter 14
 Lab 7 warm-up exercise
Apr 24  
14 Apr 29   TBD
  • Transactions and Concurrency
  • Normilization
  • Recovery
  • Security
  • Misc
 Lab 7: SwatMovie Database
May 01  
 

May 13

Final 2:00pm–5:00pm Sci 199