Csci5330: Database II, Spring 2005

TR, 10:00am-11:20am, NTRP B 140







Prof. Yan Huang


huangyan `at'


He Liu



Office Hours: TR, 8:55am – 9:55am, NTRP F251 (Instructor), Tuesday 4:30 - 5:30, Friday 9:00 - 10:00, NTRP F205 (TA)


Text Book: Database System Concepts, 4th edition, McGraw-Hill Higher Education, ISBN 0-07-228363-7


Important links: class page (, schedule, homework, announcements, grade statistics, database links


Course Description: This is a sequel course of Database I (csci 5350). This course will mainly focus on implementation of database management system together with some emerging database technologies. Topics of this course include: Storage and File Structure, Indexing and Hashing, Query Processing, Query Optimization, Transaction Processing, Concurrency Control, Recovery System, Distributed Databases, Parallel Databases, Information Integration, Information Retrieval, Advanced Data Types, Data Warehousing and Decision Support.



1.      Elmasri, Navathe, Fundamentals of Database Systems W/cd, 3rd, Addison Wesley, ISBN 0-8053-1755-4.

2.      Hector Garcia-Molina, J. Ullman, J. Widom, Database Systems - The Complete Book, Prentice Hall, ISBN 0-13-031995-3.


Examinations and Assignments: There will be several homework and a few (3-4) course projects emphasizing the key concepts. The evaluation scheme will be class participation and in-class quiz– 10%, homework – 20%, projects – 10%, midterm – 30%, and final – 30%.


Late Submission Policy: Assignments must be handed in at the beginning of the class on the specified due date. Late homework should be submitted to the TA in email (pdf, text or MS Word doc files) as well as on paper in TA's personal office. A penalty of 20% will be deducted from score for the each 24-hour period your assignment is late. Weekend days will be counted.

Honor Codes: Discussions to facilitate understanding of concepts are encouraged even for homework and projects. However, copying homework assignments or exams are strictly prohibited and will result in a failing grade. The individual who allows the copying behavior will also receive a failing grade