CSCI 6600 - Database Management Systems

Syllabus

Spring 2008
 

[ CSCI 6600 Home | Syllabus | Assignments | Resources ]


Instructor
Dr. Qin Ding
Office:  Sci. & Tech. C-118
Email:   dingq@ecu.edu
Phone:  (252) 328-9686
Office hours:   Monday 10am - noon, Tuesday & Thursday 11am - noon, and by appointments


Meeting Time and Place

Tuesday & Thursday 12:30pm - 1:45pm
Classroom:  Austin 303


Textbook

Fundamentals of Database Systems (5th Edition), by Ramez Elmasri and Shamkant B. Navathe. Published by Addison-Wesley, 2007. ISBN: 0-321-36957-2


References

Database Management Systems (3rd Edition), by Raghu Ramakrishnan and Johannes Gehrke. Published by McGraw-Hill, 2002. ISBN: 007-246563-8

Database System Concepts (5th Edition), by Abraham Silberschatz, Henry F. Korth, and S. Sudarshan. Published by McGraw-Hill, 2005. ISBN: 007-295886-3

Database Systems: The Complete Book (1st Edition), by Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer D. Widom. Published by Prenhall, 2002. ISBN: 0-13-031995-3


Prerequisites

CSCI 3700 - Database Management Systems (undergraduate)


Goal

This 3-credit course is intended for graduate students who have already completed an introductory undergraduate database course; the goal of this course is to explore in-depth theoretical and practical issues of advanced database management system.


Topics to be covered

Transaction Management and Concurrency Control
Database Recovery
Indexing
Query Processing and Optimization
Web Database and XML
Database Security
Distributed Database Systems
Object and Object-Relational Databases


Tentative Schedule

 
Outline
Reading
 I. Introduction and Relational Database Review
  
 II. Transaction Management and Concurrency Control  Chap 17, 18
 III. Database Recovery  Chap 19
 IV. Indexing  Chap 14
 Midterm   Thursday, March 6
 V. Query Processing and Optimization  Chap 15
 VI. Web Database and XML  Chap 26-27
 VII. Database Security  Chap 23
 VIII. Distributed Database Systems  Chap 25
 IX. Object and Object-Relational Databases
  Chap 20-22
 Final Exam  Tuesday, May 6, 11:00am - 1:30pm

Note that, except for the exam schedules, everything else on this schedule may change as we progress to reflect the pace of the class.


Required Work and Grades

Students are expected to attend all the lectures and to finish all the homeworks/projects. Grades will be based on midterm, final exam, and homeworks/projects. Final exam will be comprehensive. Class work will be counted as follows. The following table gives the percentage of points needed for the associated final grade:


Email

Announcements will be sent through email if needed.  It is the responsibility of the student to regularly check his/her email.


Web Page

The web page for the course is at http://www.cs.ecu.edu/~dingq/CSCI6600


Academic Honesty

All work must be completed in a manner consistent with the ECU Academic Integrity. Please refer to the 2007/2008 Student Handbook for further information on ECU's policy on academic integrity.


Students With Disabilities

East Carolina University seeks to comply fully with the Americans with Disabilities Act (ADA). Students requesting accommodations based on a disability must be registered with the Department for Disability Support Services located in Slay 138 ((252) 737-1016 (Voice/TTY)). Instructors should also be notified during the first week of classes.


Weather Policy

        In the event of a weather emergency, information can be accessed through the following sources: ECU emergency notices www.ecu.edu/alert or the ECU emergency information hotline at (252) 328-0062.
Send questions and suggestions to dingq@ecu.eduu

[ CSCI 6600 Home | Syllabus | Assignments | Resources ]