CSci 5705 Object-Relational Databases:  Winter 1999 Syllabus

923648 0945-1100 TTh, MechE 108,  4 cr
 
Role: Name Office & Hours Phone Email
Instructor: Prof. S. Shekhar EE/CS 5-203, TuTh 11-12noon 624-8307 shekhar@cs.umn.edu
TA: Changqing Zhou EE/CS 2-209, M Tu 330-430 626-7512 czhou@cs.umn.edu
Schedule: lecture, homework and examination schedule
Homeworks: homework descriptions
Web Pages: Main (http://www.cs.umn.edu/~shekhar/5705), 
  TA-Announcements , Instructor-Announcements ,
Copy Shop: Copies on Campus, Coffman Union Basement.
Textbook:
  1. J. Ullman and J. Widom, A first Course in Database Systems, Prentice Hall, 1997, ISBN 0-13-861337-0 
  2. S. Shekhar and S. Chawla, Spatial Databases: Concepts, Implementations and Trends. (Draft)
Supplements:
  1. Won Kim, Modern Database Systems, The Object Model, Interoperability, and Beyond, Addison-Wesley Publishing Company, 1995, ISBN 0-201-59098-0.
  2. Web-sites: SQL3, Jasmine, PREDATOR, Oracle8 ,

Topics: Introduction, Object data model, Comparison with relational model, New Operations and querying constructs (e.g. bags, recursion), Constraints and Triggers, Querying objects (OQL, Objects in SQL3), Systems Aspects (e.g. security) Query processing and Storage management, Applications and Trends.

Examinations and Assignments:  Submission of all assignments and scoring >= 50% on the final examination are the two necessary conditions for passing this class.  The weighting scheme used for grading is: Midquarter exam - 25%, Final exam - 35%, Assignments - 40%. There would be 4 assignments, some of which may require programming. All assignments must have your name, student ID and course name/ number. UNITE students should have their homeworks postmarked by this date and persuade their site coordinators to fax it to "114 Lind Hall" UNITE office the same day.

Late Submission Policy: Assignments must be handed in at the beginning of the class or in TA office hour on the specified due date (normally Tuesday). Late homeworks is only acceptable by email czhou@cs.umn.edu in plain text file, no word/pdf/ps/latex... formatting. DO NOT submit assignments in EE/CS 5-203. A penalty of 30% will be deducted from your score for the first 24-hour period your assignment is late. A penalty of 70% will be deducted from your score for >= 24-hour period. Weekend days will be counted.

For assignments, you are encouraged to type your answers. For programming assignments you are encouraged to use pretty printers to make your listings more readable. Following is (roughly) the weight distribution for case-study/project problems: Correctness - 60%, Test Results Summary - 10%, Style and Documentation - 15%, Approach and Report - 15%. Report should discuss assumptions and findings.

Exams: Students are responsible for all material covered in lectures, as well as that specifically mentioned as part of the supplementary reading assignments. Examinations will heavily emphasize conceptual understanding of the material.

Cheating/ Collaboration: Getting help from services like general debugging service (GDS), web-sites (e.g. cheaters.com), or copying someone else's assignment, or the common solution of written or programming assignments will be considered cheating. The purpose of assignments is to provide individual evaluation as well as a tool to get you thinking. Interaction for the purpose of understanding a problem is not considered cheating and will be encouraged. However, the actual solution to problems must be one's own.

Helpful Comments: This class is Very Interesting (for your personal understanding of software development process) and useful. Practitioners may be invited as guest lecturer during discussion of topics. To get full benefit out of the class you have to work regularly. Read the textbook regularly and start working on the assignments soon after they are handed out. Plan to spend at least 10 hrs a week on this class doing assignments or reading.
Good Luck, and Welcome to CSci 5705!
Shashi Shekhar