Department of Computer Sciences
Course Information
Instructor:
Betty O'Neil
email: eoneil@cs.umb.edu
Office: S-3-169
Meeting Times: Fall 2009, CS430/630 meets in M-1-420, 4:00 to
5:15 PM, TuTh
Office Hours: TuTh 2:00-3:30
Grader is Farshad Rum.
Description
See the course syllabus. Prerequisite: Knowledge of C and basic UNIX commands. Undergraduates must have completed CS310 or be taking it concurrently. If you Withdraw or take an Incomplete in CS310, you will not get credit in CS430/630!!.
NOTE: You are required to "apply" for CS430/630, EVEN IF YOU ALREADY HAVE A UNIX ID
Text
Patrick O'Neil and Elizabeth O'Neil, "Database: Principles, Programming, and Performance, 2nd Edition", Morgan Kaufmann, and Notes handed out in class or downloaded from this site.
Corrections to errors in text to enter in your copy
Useful Web Links
Java setup:
Java/ant
setup
instructions for UNIX/Linux and your home PC. For this class,
ignore the ant setup, unless you want to learn how to use ant on your
own.
Java API docs at Sun: http://java.sun.com/javase/6/docs/api/
SQL: Philip Greenspun's SQL for Web Nerds, Also see product SQL manual below under Oracle.
JDBC: jdbc directory for JDBC examples, Oracle JDBC driverSQL PSM (Persistent Stored Modules, like Oracle PL/SQL but standard) nice intro in Postgres docs
HW1,
due Thurs., Sept. 24 in class, on paper:
For CS630: all undotted exercises for Chap. 2., except 2.8
For CS430: all undotted exercises for Chap. 2 except 2.8, 2.14 and 2.15.
To view hw1 solutions, log in using your UNIX account, cd to your cs430 or cs630 homework directory, and then look at the text file ../GROUP/hw1soln.txt. As usual on UNIX, the case matters in this filepath, so for example, ../group/hw1soln.txt or ../GROUP/HW1soln.txt will not work.
HW2 due
Sunday, Oct. 18 in files in your cs430/hw2 or cs630/hw2
directory
Solve all Exercises at the end of Chapter 3 from 3.1 to 3.7 that are
undotted
(not solved at the back of the book). Delivery
instructions.
loadcap: script and load files to load the CAP database.
To view hw2 solutions, log in to UNIX, cd to your cs430 or cs630 homework directory, and then cd ../GROUP/hw2soln, where you will see the three files hw2.sql, hw2.out, and hw2answers.txt.
HW3
due Sunday, Nov. 1 (hard deadline) in files in your cs430/hw3
or cs630/hw3
directory
Solve all undotted Exercises at the end of Chapter 3 from 3.8 to the
end of the chapter, skipping 3.9. CS430 students may also skip
3.19. As in hw2, SQL statements should be placed in hw3.sql, with their
spool output (with echo on) in hw3.out. Put other answers
in hw3answers.txt.
HW3 solutions will be available on Monday, Nov. 2: See ../GROUP/hw3soln.txt from your cs430 or cs630 directory.
Midterm is on Tuesday, Nov. 3
HW4: see hw4.txt (note added 11/14) Support for C programming: esql, for Java programming: jdbc
For Java and JDBC docs, see Web Links above.Course Notes
9/8 Class 1 notes: Intro