EECS 584: Advanced Database Systems, Fall 2006

Overview

Announcements

Reading List

Schedule/Notes

Contact/Feedback

Course Outline


 
Cow book = Database Management Systems by Raghu Ramakrishnan and Johannes Gehrke Third Edition
 
Watch out for small changes -- make sure you have looked at a recent version when preparing for class.
The fourth column in the table below will link to notes for each lecture, approximately the morning of each lecture. Pl. visit this page prior to each lecture, and print out the notes to ease your note-taking burden in class.
The last column in the table below will link to a self-evaluation homework for each lecture. Pl. make sure to work these problems as you go along to test your understanding. I will be happy to give you feedback on any solutions that you turn in. Pl. allow one week for me to get these back to you -- in particular, I will not be able to do a whole bunch of these in a rush the day before an exam.
 
 
DATE DEADLINES READINGS NOTES SAMPLE QUESTIONS
9/6
 Intro
Reading list is online today -- volunteer quickly to get a paper of your choice!!
9/8
 Critique due today for Bourret article. Read one introductory article on XML, and one introductory article on XML Databases.
Secs. 7.4 and 27.6-27.8 of the cow book are a very minimal starting point.		 XML, and XQuery Questions
9/11
 No Class. Instructor out of town. Made up on 9/8.
9/13
 No Class. Instructor out of town. Made up on 9/22.
9/18
 You should have finalized your project selection and team by now. (This is so you can meet the deliverable for one week from now. You do not have a project deliverable today.)
Critique due only for reading 1.		 Readings 1-3 and Secs. 9.1 to 9.4 of the cow book Relational Roots, Buffering Questions and More Questions
9/20
 Critique due only for reading 5
Read Sec. 8.1-8..4 and chapter 28 of the cow book and reading 5. Clustering (notes) and Clustering (figures) Questions
9/22
 Critique due only for reading 8 Read the first 2 sections of reading 7, and all of reading 8. You should also be familiar with the material in Chap 9 of the cow book. Indexing, and Multimedia Questions  More Questions
9/25
 Project proposals due today before class.
No critique due today		 Read Chapters 11.3 and 12 of the cow book Access Methods Questions
9/27
 Critique due only for reading 9 Read Chapters 13 and 14 of the cow book, and Secs. 1, 2, 3.1, 4, and 7 of reading 9. Query Evaluation Questions
10/2
 Reading 10 critique due today Read Secs. 1-5, 7, 8 of Reading 10 Continue discussion of query evaluation
10/4
 No critique due today Query Optimization
10/9
 Critique due for reading 11 Reading 11 Query Optimization contd. Questions
10/11
 Critique due only for reading 29 Reading 29. Stream Data Processing Questions
10/16
 No Class
10/18
 Written critique due only for reading 21 Read chapter 23 of the cow book and reading 21. OO and OR Questions
10/23
 No Critiques due today.
Mid-term project progress reports due. 		Readings 13-17. You are only responsible for understanding each of the benchmarks, and not for the experimental section with actual performance numbers reported. Benchmarks Questions
10/25
 Review 1
10/30
Exam 1 in the usual class room
11/1
 Critique due only for reading 18 Sections 17.1-17.4 and 17.6.1 of the cow book and reading 18. Concurrency Control Questions
11/6
 Critique due for reading 20 Secs 18.1-5, and 22.11-12 of the cow book and reading 20
Recovery Questions
11/8
 Critique due only for one reading of your choice Readings 26 and 28. Keyword Queries and Text Questions
11/13
 Critique due for Reading 23 Read secs. 25.1-25.3 and 25.6-25.8 of the cow book and reading 23. Warehousing
11/15
 Critique due for reading 24 Reading 24 and revisit Sec. 12.4 of reading 12. Also skim this paper. Warehousing (contd.) Questions
11/20
 Critique Due for reading 25 Read chapter 26 of cow book and reading 25. Data Mining Questions
11/22
 No Class (day before thanksgiving)
11/27
 No Critique Needed Reading 30. Future Architectures Questions
11/29
 Review 2
12/4
 Final Projects Due Student Presentations: Lang/Derbinsky, Shaw, Wang/Sweeney.
12/6
 Student Presentations: Agnew/Rhode, Chen/Singh.
12/8 - 12/11
 Exam 2 Take Home
12/11
 Student Presentations: Bartlett/Kim.

 
 
  Back to Course Homepage