CSC7710: Database Management II

(Winter 2008)

(Class: TuTh 4:30-5:50 PM, State Hall 131)

Webpage: http://www.cs.wayne.edu/~shiyong/csc7710/csc7710.html/

Announcements:

  • The final exam will be held on 4/24 in the same class room during regular lecture time (4:30PM-5:50PM). The last class will be 4/17 and 4/22 will be a study day (I will be available in my office). Only chapter 20, 21, 22 will be covered in the final exam. No review class will be given for the final exam.
  • Assignment 3 (textbook Chapter 22 exercises 2, 4, 8, 12, 15) is out. Due to final busy schedule, assignment 3 will not be graded and there is no need for submission. However, you are strongly encouraged to do these exercises and to verify your answers with the TA or me for your preparation for the final exam.
  • Assignment 2 (textbook Chapter 21 exercises 3, 4, 7, 14, 15, 16, 18, 21, 24, 28) is out. Due 4/15 midnight.
  • Project 2 is out, due 4/21 midnight. No extension will be permitted for this project due to the final exam schedule.
  • Assignment 1 (textbook Chapter 20 exercises 1, 2, 3, 16, 25, 26, 27, 28, 32, and 34) is out, due 3/25 midnight.
  • Project 1 is out, due 3/20 midnight.
  • Each individual student will be assigned by the TA with an Oracle database account and any problem you have for your account should be reported to the TA immediately.
  • Log in at http://pipeline.wayne.edu/  to register for classes, view final grades, send WSU e-mail, work with calendars, download class lists, check pay stubs and vacation balances, and access many other E-Services WSU offers. You need a WSU AccessID to login. Click here to look up for your AccessID. Any other questions about AccessID (including how to activate it) is available here, or you can call Please call the C&IT Help Desk at 313-577-4778 to obtain assistance.  Note that you need to activate before you can use it. 
  • All students who would like to take the course are expected to attend the first class. You cannot take this course if you do not attend the first class. 

Objective

The goal of the course is to introduce students to the following advanced topics in database systems: concurrency control, transaction processing, workflow management, crash recovery, distributed and heterogeneous databases. Students will design and implement advanced database functionalities and their applications to deepen their understanding of these concepts and theories.

Prerequisites

  • CSC6710, and a good knowledge of Java (CSC4992-001 equivalent). 
  • Or with the permission of the instructor. 

Instructor:

  • Shiyong Lu
  • Email: shiyong circle at wayne.edu
  • Office: 430 State Hall 
  • Telephone: 577-1667
  • Office hours: MW 10:00AM-11:00AM

TA's office hours

  • Name:  Seunghan Chang
  • Email: aq9320@wayne.edu
  • Office: 227 State Hall
  • Office hours: TuTh 2:00PM-3:00PM

Textbook:

  • Database Systems - An Application-Oriented Approach, by Michael Kifer, Arthur Bernstein and Philip M. Lewis, second edition,  ISBN: 0-321-26845-8. Addison-Wesley, 2005. A copy of the text  book is reserved in the science library. You can loan it for 2 hrs at a time. 

Recommended materials:

  • Workflow Management: Models, Methods, and Systems (Cooperative Information Systems) by Wil van der Aalst and Kees van Hee (Paperback - Mar 1, 2004).

Course outline:

A tentative series of lectures are given in the following, which is subject to change. The lecture slides are available (Chapters with * are self-study only).

Course load and grading:

The course will require the following work: 

  • (30 %) 3 Assignments, only the first two assignments will be graded with 15% each. Final assignment will not be graded but is helpful for the final exam.
  • (40 %) Two programming projects, 20% each
  • (30 %) Final exam

All the above work is expected to be done individually except the projects which will be completed by a group of at most two students.

Feedback policy:

If you have any feedback, suggestion, concern, or complaint about any aspect of the class, you should either meet the instructor during his office hours or make an appointment with him to discuss them. You will not discuss them with other students in public either in class or outside the class, even you have a good intention for finding whether your concern is a common concern or not. It is the instructor’s job to find out how many students might have the same concern, not your job. You are only allowed to express your own feedback, concern, suggestion, or complaint, not those of others. The instructor has the final authority for all aspects of the class.

Office hours policy:

Office hours are used for clarification of doubts and confusions. Students should not ask a TA or instructor for an evaluation of their assignment or project and use the informal positive feedback as a promise for good grades. It is not the responsibility of the TA and instructor in their office hours to tell you what parts of your assignment solutions are wrong.

Late work penalty:

You can have one late submission for either an assignment or for a project but not for both up to one week without any penalty. Please indicate on the cover page (or readme.txt file) of your submission when you use your late excuse. If late excuse is not used, a penalty of 20 % per day will be assessed. No late excuse can be used for any exam.

Academic Honesty:

Copying an assignment from another student in this class or obtaining a solution from some other source will lead to an automatic failure for this course and to a disciplinary action. Allowing another student to copy one's work will be treated as an act of academic dishonesty, leading to the same penalty as copying. You should learn how to protect your data. Failure to do so is also unprofessional and it may expose you to the danger that someone will copy your homework and will submit it as his or her own (see above). In this case, you may be given a score of 0 for the assignment in question (and the other party will get a failure).

Special need policy:

If you need a special accommodation due to mental or physical disability or other medical reasons, please contact the Educational Accessibility Services (EAS) Office (1600 David Adamany Undergraduate Library) at  phone (313) 577-1851 or at Email eas@wayne.edu  for a registration.

The End