CSE 532 -- Advanced Database Systems

Fall 2001





Information for Students

Meeting Time and Place

MW 5:30 - 6:50, Room: Javits 109

Prerequisites

The prerequisite for CSE 532 is CSE 305. No one will be admitted without this prerequisite.

Instructor

Scott A. Smolka: sas AT cs DOT sunysb DOT edu, http://www.cs.sunysb.edu/~sas/

Office

Computer Science Building, Room #1423, ext. 2-8453

Office Hours

MW 4:00-5:30, or by appointment

Teaching Assistant

Yan Rong, yanrong AT cs DOT sunysb DOT edu; Office Hours: Tue 9:30-10:30, Fri 9:30-11:30 in Room # 2110 of the Computer Science Building.

Textbooks

Raghu Ramakrishnan and Johannes Gehrke, Database Management Systems, Second Edition, McGraw-Hill, 2000. ISBN 0-07-232206-3

C. Musciano and B. Kennedy, HTML & XHTML, The Definitive Guide, Fourth Edition, O'Reilly & Associates, Inc. ISBN 0-596-00026-X.

D. Flanagan, Java in a Nutshell, Third Edition, O'Reilly & Associates, Inc. ISBN 1-56592-487-8.

G. Reese, Database Programming with JDBC and Java, O'Reilly & Associates, Inc. ISBN 1-56592-270-0.

Course Syllabus

A schedule of the class lectures can be found here.

Course Work

The following, which is subject to change, is a summary of the work required for this course.

Reading Assignments: The topics discussed in the lectures correspond to the various chapters of the Ramakrishnan text. This is an advanced course in database systems. As such we will spend most of our time on the latter chapters of the text, starting with Chapter 16. The course outline gives the approximate dates for each major topic to be discussed. You are responsible for reading the appropriate chapter from the text and the appropriate set of transparencies from the lecture notes before each class.

Homework Assignments: There will be two or three homework assignments. They will count for 10% of your final grade.

Programming Assignments: You will design and implement a working database system using HTML for the user interface, DB-2 for the remote database server, and Java, Javascript and JDBC for connectivity between the user interface and database server. The project will be carried out in the Graduate Transaction Processing Lab, Room  1239 of the Computer Science Building, but a substantial part of it can be done on your home PC, if you own one. The programming project will count an additional 25% of your final grade.

Exams: The remainder of your final grade will be based on the final exam (35%) and a mid-term (30%).

If you have a physical, psychological, medical or learning disability that may impact on your ability to carry out assigned course work, I would urge that you contact the staff in the Disabled Student Services office (DSS), Room 133, Humanities, 632-6748v/TDD. DSS will review your concerns and determine with you what accommodations are necessary and appropriate. All information and documentation of disability are confidential.

Grading


NO INCOMPLETES will be given for this course.
Late homeworks and programming assignments will be penalized, on the order of 5% off for each business day late.
Collaboration on assignments and exams is not permitted. Students found in violation of this rule of conduct will automatically receive an F on the assignment or exam in question. Two such incidents, over the course of your stay at Stony Brook, will lead to automatic expulsion from the Graduate Program.


Useful links

Scott Smolka
Tue Nov 8 14:25:46 EDT 2001