CSCI 1270: Database Management Systems

• News
• Asgn
• Lectures
• Docs
• Grad
• Staff

News From the Revolution!

• Final Exam information

  12.01.2008 - Suggested review problems for the final can be found here. As before, the problems are from the book and the solutions can be found here.
  
  Also, be sure to come to the review session this Friday, December 5 at 4:00pm in the Motorola Room. Gal will dance and bring freshly baked cookies!*
  
  *= not really. Unless you want to surprise us, dear Leader?

• Homework 9 GONE!

  11.17.2008 - Homework 9 (the final homework) has been released. Also, due to unprecedented surplus of labor from the revolution, the due date for this homework is December 1, not next class. Enjoy!

• Homework 8 AFUERA!

  11.10.2008 - Homework 8 -the penultimate- has been leaked. Also, joy of joys, Concurrency!

• Homework 7 OUT!

  11.03.2008 - Homework 7 is available for your perusal.
  
  And be sure to vote tomorrow! Rule is wonderful under Stan and Gal, isn't it?

• Many announcements!

  10.20.2008 - A lot of things go out today: you're new project B-Tree (start early!), and Homework 6. We've also posted suggested Midterm Review questions. Finally, remember that the midterm review is tentatively on Thursday the 23rd at 7:00pm, in the Motorola Room.
  
  Solutions to the midterm review problems can be found here.

• Safety from SQL Injection!

  10.16.2008 - After you ducklings have taken flight from CS127 and write queries for real world applications, SQL Injection is something you'll eventually have to worry about. Over at Oracle, an interesting paper was just published on making your database injection-proof. From the abstract:

  Googling for "SQL injection" gets about 4 million hits. The topic excites interest and superstitious fear. This whitepaper dymystifies the topic and explains a straightforward approach to writing database PL/SQL programs that provably guarantees their immunity to SQL injection.
  Only when a PL/SQL subprogram executes SQL that it creates at run time is there a risk of SQL injection; and you'll see that it's easier than you might think to freeze the SQL at PL/SQL compile time. Then you'll understand that you need the rules which prevent the risk only for the rare scenarios that do require run-time-created SQL. It turns out that these rules are simple to state and easy to follow.

  Pretty interesting stuff, take a look if you're interested! -TA's

• Graduate Credit and SQL

  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!

• Homework 5 OUT

  10.06.2008 - Homework 5 is out! Have at it!

• Handin Script fix!

  10.03.2008 - Hey everyone, handin scripts have been fixed. Thanks for your patience! -TA's

• Bourgeois influences on handin scripts!

  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

• Homework 4 OUT!

  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.

• Homework 2 handed back!

  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!

• Homework 3 OUT!

  09.22.2008 - Homework 3 is out. Good luck!

• Homework 2 OUT

  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!

• Homework 1 OUT

  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.

• Welcome to CS127

  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 now glorious! Enjoy the fruits of working man's labor! -TA's