6.830: Database Systems (Fall 2007)
| Units: | 3-0-9 (H) |
| When: | TR 1-2:30 |
| Where: | 32-155 |
| Instructors: | Samuel Madden (madden AT csail.mit.edu) |
| Michael Stonebraker (stonebraker AT nms.csail.mit.edu) | |
| Instructor office hours: | by appointment |
| TAs: | Yuan Mei (meiyuan AT csail.mit.edu) |
| Arvind Thiagarajan (arvindt AT mit.edu) | |
| TA office hours when: | Mon 4-5 pm (Yuan), Wed 10-11 am (Arvind) |
| TA office hours where | 32-G9 lounge |
Announcements
12/10/07: Final project presentations will be tomorrow (Tuesday) in class. We will have Pizza. Plan on a 5 minute presentation, with 2 minutes for questions. You should try to cover: the problem you addressed, a high level picture of how you addressed it, and your results or a demonstration. Final project reports are officially due Wednesday (the last day of classes), in Professor Madden's office (32-G938) by 5 PM.
12/06/07: Quiz 2 Solutions are now available. The class mean was 66.5, the median was 66.5 and the standard deviation was 14. Quizzes will be handed out today in class.
11/30/07: TA office hours will be next Monday(12/3/07) 10:00-11:00 am & 4:00-5:00 pm.
11/28/07: Quiz 2 from last year is available. Note the similarity to PS4.
11/28/07: Professor Madden will have office hours tomorrow from 4-5 PM in 32-G938.
11/19/07: With drop date approaching, some of you have asked about interim grades. We have posted a web form that will allow you to compute your current performace, and compare your grade to the rest of the class. If you need to know the numbers for one of your assignments, feel free to email us.
11/19/07: Problem set 4 is posted. It is due 11/29.
11/01/07: Quiz 1 Solutions are now available. The class mean was 62, the median was 60.5 and the standard deviation was 12. Quizzes will be handed out today in class.
10/29/07: Solutions for Problem Set 3 are now available.
10/25/07: Solutions for Problem Set 2 are now available.
10/25/07: Some notes on snapshot isolation are posted.
10/25/07: Professor Madden will have office hours tomorrow from 5-6:30 in his office (32-G938). Also, Yuan and Arvind will have office hours on Monday before the quiz at 4 pm (G9 lounge).
10/16/07: PS3 is posted. It is due on Thu, Oct 25.
10/12/07: Bug updates for Lab 3 are now on the bugs page.
10/11/07: Contrary to what was announced in class today, we have decided to cancel Lab 4. Everyone must complete PS3.
10/11/07: For Lab 3, you may request a copy of our complete implementation of Lab 1 and Lab 2 rather than starting from your code.
10/09/07: Solutions for Problem Set 1 are now available.
10/04/07: Lab 3 is out, due on 10/18.
10/3/07: Bug updates for Lab 2 are now on the bugs page.
10/1/07: Some of you may have noticed that books 24x7 link to the Red Book stopped working. There is a new URL, which should work as long as you have MIT certificates.
9/27/07: Lab 2 is out, due on 10/5.
9/24/07 Final project list: A list of final projects is now available.
9/23/07 (Important Bug Update): There was a bug in our grader script for Lab 1 which meant that it did not test correctly for page eviction. Please download the fix from the bugs page. Sorry for the blooper on our part (a fairly major one!), and thanks to all of you who mailed in about the problem!
9/23/07: SimpleDB PowerPoint Overview is posted. If you downloaded a previous version on a PC and couldn't see the module diagram, this version should have corrected this issue. A JPEG Version of the module diagram is also available.
9/20/07: PS2 is posted. It is not due until 10/11/07, but includes some questions relevant to ideas we have been discussing in current lectures, so you may want to see what parts of it you can complete now.
9/20/07 (Lab 1 Tarball Update1): We have posted a updated version of lab1 tarball 6.830-lab1.tar.gz which fixes all bugs found until now. Also check the bugs page to get the latest patches for the early version.
9/19/07 (Lab 1 Revision): We have posted a minor revision of lab 1 to clarify the relationship between the sequential scan operator and buffer pool methods. A note about the confusing statements is also on the bugs page.
9/19/07 (Lab 1 Bug Update): We now have a bugs page to keep track of SimpleDB bugs that you or we find. Fixes for bugs/annoyances will also be posted there. Some bugs have already been found in Lab 1 (that was quick!), so take a look at the page to get the latest version/patches for the lab code.
9/18/07: Lab 1 is out, due on 9/27.
9/13/07: Problem set 1 is due at 11:59 PM next Tuesday, 9/18. Please email your assignment as a text file or PDF to 6830-submit@nms.csail.mit.edu.
9/11/07: Problem Set 1 is out. Due on Sep 18.
9/11/07: The FAQ has been updated with information about past year's quizzes. Also, please note the late assignment policy -- late assignments are docked one grade for each day they are late, except that you are allowed three "late assignment days" (which may be applied to problem sets or labs.)
9/6/07: Have a look at the schedule page for upcoming assignments. See the syllabus for information on the courses for the text.
8/29/07: Course will meet in 32-155, not 34-303 as previously posted.
8/7/07: Website created. First class meeting is Thursday, September 6th.
Description
This course relies on primary readings from the database community to introduce graduate students to the foundations of database systems, focusing on basics such as the relational algebra and data model, schema normalization, query optimization, and transactions. It is designed for students who have taken 6.033 (or equivalent); no prior database experience is assumed though students who have taken an undergraduate course in databases are encouraged to attend.
Classes consist of lectures and discussions based on readings from the database literature. Grades are assigned based on a semester long project, as well as two exams and 6 assignments -- 3 labs and 3 problem sets -- of varying length. For more information about the readings and assignments, use the links at the top of the page.