CPS 432/562: Database Management Systems II/Winter 2006

Query processing and optimization, transaction management, concurrency control (serializability, locking mechanisms), and recovery. Data warehousing and data mining. Semistructured data and XML. Cursory coverage of active database elements, object-orientated databases, and multimedia databases.

Syllabus (pdf)

Meeting times: M W 4:30-5:45p, MH 205

Instructor: Dr. Saverio Perugini, AN 145, 229-4079, saverio at udayton dot edu, OHs: M W 7:10-8:10p and by appointment.

Teaching assistant: John Cresencia, AN 130 (connector room between AN 131 and 135), 229-2364, cresenjv at notes dot udayton dot edu, OHs: M W 2:00-3:00p, T Th 4:30-6:00p, and by appointment.

Recommended textbooks:

    [DBCB] Database Systems: The Complete Book by H. Garcia-Molina, J. D. Ullman, and J. Widom. Prentice Hall, 2001. ISBN: 0-13-031995-3.
    [DMCT] Data Mining: Concepts and Techniques by J. Han and M. Kamber. Morgan Kaufmann, 2000. ISBN: 1-55860-489-8.
    [DOW] Data on the Web: From Relations to Semistructured Data and XML by S. Abiteboul, P. Buneman, and D. Suciu. Morgan Kaufmann, 1999. ISBN: 1-55860-622-X.

Lecture notes and reading assignments:
(click on a date to view lecture summary for that class)
  1. Query processing and optimization ([DBCB] Ch15-16): Jan 9 11 18 23 25 Feb 1 6 8
  2. Transaction management, concurrency control, and recovery ([DBCB] Ch18): Feb 13 15 20 22 Mar 1 6 8 20
  3. Data warehousing and data mining ([DBCB] Ch20): Mar 22 27 29 Apr 10 12
  4. Semistructured Data and XML ([DBCB] Ch4): Apr 19 24 26


  5. Exam 1 (Jan 30, closed book, closed notes)
    Exam 2 (Feb 27, closed book, closed notes)
    Exam 3 (Apr 3, closed book, closed notes)
    Final Exam (4:30-6:20p, May 1, MH 205; comprehensive, closed book, closed notes)
Homeworks:   1 2 3 4 5 6 7
Solution Sketches:   1 2 3 4 5 6 7
Projects: 1 (grading data) 2
Grades: WebCT

Accounts: CPS Account Access @ Home  UNIX Account Access  Using Oracle 8  CPS Labs Hours  Keeping your Password Safe  A Beginner's Guide to Effective E-Mail 
If you are unable to log into your CPS (Windows or Unix) account or if you forgot your CPS (Windows or Unix) account password, contact the CPS systems administrator, Mr. Halter, at dean dot halter at notes dot udayton dot edu or 229-3835, and be as specific as possible. Mr. Halter's office is located in the back of AN 131 and his office hours are M-F 8:00-5:00p.

Readings and resources: webpage for [DBCB]

Helpful links: UD Academic Calendar  UD Student Handbook  UDit Policies 

Feedback: Dr. Perugini welcomes any feedback you may have on the style of the lectures, the concepts presented in class, the course webpage, homeworks, projects, deadlines, course and grading policies, or your general experience in the course.
© Saverio Perugini, Winter 2006, University of Dayton. Permission to use ideas about the organization of topics and any notes or material is granted, provided suitable acknowledgments and citations are made.