News

  • 10.07.2008 Two things: any students interested in Graduate Credit should contact Stan ASAP if you haven't spoken to him about it already. Second: SQL is due tomorrow (Wednesday) at 11:59pm. Thanks!
  • 10.06.2008 Homework 5 is out! Have at it!
  • 10.03.2008 Hey everyone, handin scripts have been fixed. Thanks for your patience! -TA's
  • 10.02.2008 Just a note: handin scripts currently aren't working due to a minor problem involving Unix permissions and what 'groups' all your student accounts are registered with. Note that this does NOT interfere with your ability to work on the project, just whether or not you can hand it in for the time being. The appropriate authorities have been contacted and the issue will be resolved as soon as possible, and we'll send an e-mail to the mailing list as soon as its been cleared. We're sorry for the hiccup and thanks for your patience -TA's
  • 09.29.2008 Homework 4 is out! Also, SQL! On the Assignments page, there is a supplement to the SQL handout taken from another class, CS032. You are not expected to implement this. This supplement is merely to assist and demonstrate how to connect to the database using the Java interface.
  • 09.23.2008 Homework 2 is back in the handback bin. For those who don't know, the handback bin is located in the Fishbowl, CIT 271 (by the stairwell in the front door). Many Homework 1's are there as well. Have a great day!
  • 09.22.2008 Homework 3 is out. Good luck!
  • 09.15.2008 Homework 2 has been posted. Also, please remember (if you haven't already) to sign up to our mailing list! This can be done here. If you signed the sheet at todays lecture, you should be cleared and receive a confirmation message. Thanks!
  • 09.08.2008 Homework 1 has been posted. There was a mistake in the first version (which went up around 4:30) in that the final problem is extra credit. It has since been fixed.
  • Cover of the Textbook 9.1.2008 - Welcome to CSC1270: Database Management Systems! The course textbook is Database Systems Concepts, Fifth Edition by Silberschatz, Korth, and Sudarshan.ISBN: 0-07-295886-3.

    The course is every Monday, 3:00-5:20, Room 367 of the CIT. The first class is this coming Monday, September 8th. Stop on by!

    The website is in a primitive state right now, come back soon to see it blossom! -TA's

Assignments

Homework

All weekly homework assignments should be placed in the handin bin on the second floor and are due BEFORE or AT class the week after they are assigned. They will be graded and returned by the following Wednesday night.

PLEASE PUT THE SOLUTION TO EACH PROBLEM ON A SEPERATE SHEET OF PAPER. Otherwise grading is NP-Complete and will curve our spines. Thanks!

Homework OUT IN
Homework 1 9.8.2008 9.15.2008
Homework 2 9.15.2008 9.22.2008
Homework 3 9.22.2008 9.29.2008
Homework 4 9.29.2008 10.6.2008
Homework 5 10.6.2008 10.20.2008
Homework 6 10.20.2008 11.3.2008
Homework 7 11.3.2008 11.10.2008
Homework 8 11.10.2008 11.17.2008
Homework 9 11.17.2008 11.24.2008

Projects

Project OUT IN Misc
SQL 09-29-2007 10-08-2007 Supplement
BTree 10-20-2008 11-10-2008 Algorithms
Concurrency 11-10-2007 11-25-2007  
Logging 11-25-2007 12-10-2007 Javadocs

Lectures

All slides are only available within the department. If you are off-campus, you can setup VPN access to view these slides.

# Date Lecture Book Chapter(s)
1 09-08 Introduction (.ppt, .pdf), Relations (.ppt, .pdf) 1, 2
2 09-15 DB Design, ER-Model, Integrity Constraints (.ppt, .pdf) 6
3 09-22 Tuple Relational Calculus (.pdf, .ppt), SQL: Structured Query Language 1 (.ppt, .pdf), 2 (.ppt, .pdf) 3, 4, 5.4
4 09-29 Functional Dependencies(.pdf, .ppt) 7
5 10-06 Normalization (.pdf, .ppt) 9, 10, 18.1-18.3
N/A 10-13 Columbus Day - No Class!  
6 10-20 File Structures, Indexing & Hashing 11, 12
7 10-27 Midterm  
8 11-03 Transaction Processing, Concurrency Control 15, 16.1-16.6
9 11-10 Logging & Recovery 17, 13
10 11-17 Query Processing Optimization 14
11 11-24 Distributed Databases 22
12 12-01 Graduate Project Presentations  
N/A 12-08 Final  

Graduate Credit

A graduate credit option is open to both undergraduate and graduate students contingent upon the completion of a project and presenting it: a quick gander at the Lecture calendar shows an opportunity on December 1st to present. Please contact Stan for more information.

Deadlines

  • October 1st: Selecion of topic.
  • November 1st: Preliminary project presentation.
  • December 1st: Final project presentation.

Staff

Remember, we can all be reached at cs127tas@cs.brown.edu.

Professor: Stan Zdonik (sbz) mailto:sbz@cs.brown.edu
HTA: Gal Peleg (gpeleg) cs127headtas@cs.brown.edu
UTA: Paul Meier (pmeier)
UTA:Josh Dawidowicz (jdawidow)
Grad TA: Andy Pavlo (pavlo)

TA Hours

TA hours will be held during evening hours in the Fishbowl, CIT room 271.

Wednesday: 8:00 - 10:00 => Paul
Thursday: 6:00 - 8:00 => Josh
Saturday: 3:00 - 5:00 => Gal
Sunday: 4:00 - 6:00 => Andy