Captain's Log: Database Management Systems, Spring 2011

1: January 19 (Wednesday)
Go through syllabus.
Introduction and motivation, giving a high-level perspective on database design. (Chapter 1 and Section 2.1).
2: January 21 (Friday)
Embark on the relational model: First Gradiance homework out.
3: January 24 (Monday)
We look more into the basic relational algebra: Gradiance 1 due Tuesday night.
4: January 26 (Wednesday)
We do Exercise 2.4.4(h,i), as well as some more exercises that illustrate the surprising power of basic relational algebra:
5: January 28 (Friday)
Start on Chapter 3 on how to design relational databases:
January 31 (Monday)
University closed due to inclement weather.
February 2 (Wednesday)
Class canceled due to road/sidewalk conditions.
6: February 4 (Friday)
Gradiance 2 due tomorrow night.
7: February 7 (Monday)
Cover Sections 3.4&3.5.1, with focus on goals for normalization: We do Exercise 3.4.1(a,b) and Exercise 3.4.2(b,c,d).
Graded paper Assignment 1 back.
8: February 9 (Wednesday)
Gradiance 3 due tomorrow night.
9: February 11 (Friday)
10: February 14 (Monday)
Wrap up Chapter 3: Gradiance 4 (on MVDs) due tomorrow night.
11: February 16 (Wednesday)
Embark on E/R design (Sections 4.1-6), covering the basic concepts, and doing Exercises 4.1.1, 4.1.2(-d), 4.1.3, 4.1.5.
12: February 18 (Friday)
Gradiance 5 (on simple E/R design) due tonight.
13: February 21 (Monday)
14: February 23 (Wednesday)
Paper assignment 2 due at 4pm.
Gradiance 6 (on advanced E/R design) due tonight.
15: February 25 (Friday)
16: February 28 (Monday)
Gradiance 7 (on bags and extended relational algebra) due tonight.
Paper assignment 3 due tomorrow at 4pm.
17: March 2 (Wednesday)
Exam I.
18: March 4 (Friday)
Continue Datalog (Sections 5.3-5.4):
19: March 7 (Monday)
Wrap up Datalog: Graded Assignment 3 Start on SQL (Chapter 6): Gradiance 8 (on Datalog) due tomorrow night.
20: March 9 (Wednesday)
We present numerous features of SQL, including subqueries, covering much of Sections 6.1-6.4.
21: March 11 (Friday)
22: March 14 (Monday)
23: March 16 (Wednesday)
Cover some extra/advanced features of SQL: Gradiance 10 (more SQL) due tonight.
24: March 18 (Friday)
Gradiance Lab project (on Bookstore) due tonight.
March 21-25
Spring break.
25: March 28 (Monday)
Cover more extra/advanced features of SQL: Graded Exam I back.
26: March 30 (Wednesday)
Cover basic notions of Gradiance 11 (misc SQL) due tomorrow night.
27: April 1 (Friday)
Project out.
28: April 4 (Monday)
Advanced Lock-based protocols: Gradiance 12 (serializability) due tonight.
29: April 6 (Wednesday)
Gradiance 13 (properties of schedules) due tomorrow night.
30: April 8 (Friday)
31: April 11 (Monday)
Phase 1 of project due at noon. Gradiance 14 (concurrency protocols) due tomorrow night.
32: April 13 (Wednesday)
Exam II
April 15 (Friday)
Class canceled (All-University Open House)
33: April 18 (Monday)
34: April 20 (Wednesday)
Finish Multi-dimensional Indexes (Sections 14.4-14.7): Embark on Query Execution (Chapter 15): Gradiance 15 (logging and disks) due tomorrow night.
April 22 (Friday)
Class canceled (Good Friday)
35: April 25 (Monday)
Continue Query Execution: Graded Exam 2 back.
Gradiance 16 (B-trees and hash indices) due tonight.
36: April 27 (Wednesday)
Finish Query Execution: Embark on the Query Compiler (Chapter 16), with focus on Gradiance 17 (on multidimensional indexes) due tonight.
37: April 29 (Friday)
Continue the Query Compiler, with focus on Phase 2 of project due at 4pm. Each team should schedule a presentation with the GTA.
38: May 2 (Monday)
Finish the Query Compiler: Gradiance 18 (on query execution) due tomorrow night.
39: May 4 (Wednesday)
Embark on Data Mining:
40: May 6 (Friday)
Gradiance 19 (on query optimization) due tonight.
May 10 (Tuesday)
Gradiance 20 (on data mining) due tonight.
May 12 (Thursday)
Final exam, 11:50am-1:40pm


Torben Amtoft