CSC7710: Database Management II

(Winter 2012)

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

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

Announcements:

  • 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, crash recovery, distributed and heterogeneous databases, data warehousing and data mining. Students will design and implement advanced database functionalities and their applications to deepen their understanding of these concepts and theories.

Prerequisites

  • CSC6710. 
  • Or with the permission of the instructor. 

Instructor:

  • Shiyong Lu (shiyong circle at wayne.edu)
  • Office: 14102.1 Macabees bldg 
  • Telephone: 577-1667
  • Office hours: TuTh 3:30-4:30PM

TA's office hours

  • Name:  TBA
  • Office: TBA
  • Office hours: TBA

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:

  • Oracle PL/SQL Programming, 3rd Edition, ISBN 0-596-00381-1, By Steven Feuerstein with Bill Pribyl
    O'Reilly.

Course outline:

A tentative series of lectures are given in the following, which is subject to change. The lecture slides will be sent via blackboard.

  • Ch16: Distributed databases
  • Ch17: OLAP
  • Ch18: ACID Properties of Transactions
  • Ch19: Model of Transactions
  • Ch20: Implementing Isolation
  • Ch21: Isolation in Relational Databases 
  • Ch22 Atomicity and Durability
  • Ch23: Architecture of Transaction Processing Systems
  • Ch24: Implementing Distributed Transactions

Course load and grading:

The course will require the following work: 

  • (45 %) 3 Assignments, 15% each.
  • (30 %) One course project, three parts, graded together in the end.
  • (25 %) 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.

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 of your submission when you use your late excuse. If late excuse is not used, a penalty of 20 % per day will be assessed. The late excuse cannot be used for the last assignment or the last project whichever is due later. No late excuse can be used for any exam.

Academic Honesty:

Unless explicitly specified that you can work together as a group, copying an assignment/exam/project 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.

The End