CSE 532 - Spring 2012 - Section 2 - Syllabus

Theory of Database Systems


Course Objectives and Description

The 3 credits course will cover advanced topics in modern database systems, including object-oriented databases, rule-based databases, temporal and active databases, parallel and distributed databases, distributed object model, data mining, on-line analytical processing, data warehousing, multimedia databases.

You must have completed a substantial undergraduate database course, such as CSE 305. You will need knowledge of Java, JDBC, servlets, and JSP. You should have working knowledge of mathematical induction, logic, and related material.


Instructor: Dr. Paul Fodor
1437 Computer Science Building
Office hours: Tuesdays 10:00AM-12:00PM and By Appointment
Phone: (631) 632-9820
Email: pfodor (at) cs (dot) stonybrook (dot) edu

Graduate TA: TBD
Office hours: Tu Th 10:00AM-12:00PM
2110 Computer Science Building
Email: tbd

Class Time/Place


Database Systems: An Application Oriented Approach, 2nd Edition (Compete Version).  Authors: Michael Kifer, Arthur Bernstein and Philip M. Lewis. Addison Wesley; 2 edition (March 26, 2005). ISBN-10: 0321268458. ISBN-13: 978-0321268457.

Recommended textbook for Java programming: Introduction To Java Programming, Comprehensive Version, Author: Liang, Publisher: Pearson , Edition: 8th, 2010.

Final Examinations

Tuesday 5/8, 11:15AM - 1:45PM in classroom (see rules in http://www.stonybrook.edu/registrar/finals.shtml).

Grading Schema

Grades will be based on homework submissions, projects and exams according to the following formula:

Do not miss the exams. Make-up exams will be given only in extenuating circumstances (e.g., doctor's note stating that you were ill and unfit to take the exam). Students who miss an exam for a valid reason may need to take a make-up exam; specific arrangements will be made on a case-by-case basis. The P/NC grading option is not available for this course. The grades are posted on Blackboard: http://blackboard.stonybrook.edu.

Details about the projects wil be posted on Blackboard.

There will be regular quizes during lectures.


There will be homework assignments given regularly. Submission of the homework will be paper based.

Homeworks will be done individually. You *must* do your own work and you must show how you solved the problems, not just the final solution.


For re-grading of an assignment or exam, please meet with the person (instructor or teaching assistant) responsible for the grading. Please try to arrange a re-evaluation within one week of receiving the graded work. All such requests that are later than one week from the date the graded work is returned to the class will not be entertained. To promote consistency of grading, questions and concerns about grading should be addressed first to the TA and then, if that does not resolve the issue, to the instructor. You are welcome to contact the TA by email or come to his office hour. If you would like to speak with the TA in person, and have a schedule conflict with his office hour, you are welcome to make an appointment to meet the TA at another time.

Academic Dishonesty

You are encouraged to discuss the intellectual aspects of assignments with other class participants. However, each student is responsible for formulating solutions in his or her own words. A student must pursue his or her academic goals honestly and be personally accountable for all submitted work. Representing another person's work as your own is always wrong. Any suspected instance of academic dishonesty will be reported to the Academic Judiciary. For more comprehensive information on academic integrity, including categories of academic dishonesty, please refer to the academic judiciary website at http://www.stonybrook.edu/uaa/academicjudiciary Academic Dishonesty Penalty: Students who submit the same or suspiciously similar assignments will receive a grade of zero on the particular assignment and have their final course grade reduced by one letter grade. In addition, the College of Engineering & Applied Sciences has formal procedures to handle cases of academic dishonesty.

Disability Information

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 i n the Disabled Student Services office (DSS), Room 128 ECC, 632-6748/TDD. DSS will review your concerns and determine, with you, what accommodations are necessary and appropriate. All information and documentation of disability is confidential. Important: If you are planning to take exams at the DSS office, you need to tell me ahead of time for every exam.

Critical Incident Management

Stony Brook University expects students to respect the rights, privileges, and property of other people. Faculty are required to report to the Office of Judicial Affairs any disruptive behavior that interrupts their ability to teach, compromises the safety of the learning environment, or inhibits students' ability to learn.