Slide 1.1: Syllabus
Slide 1.2: Schedule
Home
SYLLABUS
COMP7120 Database Systems II
Computer Science and Software Engineering Department
Auburn University, Spring 2002
INSTRUCTOR: Wen-Chen Hu
E-MAIL: wenchen@eng.auburn.edu
CLASS PAGES: http://www.eng.auburn.edu/~wenchen/course/7120
CLASS PERIODS: MWF 11:00am - 11:50am
CLASSROOM: Ramsay 304B
PREREQUISITES: COMP6120 Database Systems I
OFFICE: Dunstan Hall 113
OFFICE HOURS: MWF 03:00pm - 04:00pm
DESCRIPTION:
This course gives a hands-on study of database system architecture and implementation, with emphasis on the object-oriented model. Design and implement comprehensive Web-based database systems as individual projects. It is mainly divided into three major themes:
- object-oriented database management system concepts and architecture,
- Oracle8 object features, and
- advanced relational database management system features.
The following topics are covered: object-oriented data models, Oracle8 system and architecture, database host languages, object-oriented database management system fundamentals, and indexing and query processing of relational database management systems, as well as some other special topics.

TEXTBOOK: Most course material will come from the following six sources:
- George Koch and Kevin Loney. Oracle 8: The complete reference. McGraw-Hill, 1997.
- Georg Lausen and Gottfried Vossen. Models and languages of object-oriented databases. Addison-Wesley, 1998.
- Patrick O'Neil and Elizabeth O'Neil. Database - Principles, programming, performance, 2nd edition. Morgan Kaufmann, 2000.
- Michael Stonebraker and Paul Brown. Object-relational DBMSs: Tracking the next great wave, 2nd edition. Morgan Kaufmann, 1999.
- Oracle 8 on-line manuals.
- Other collections of papers.
EVALUATION (tentative):
Exam: 30% -- Project I: 15% -- Project II: 25% -- Final exam: 30%
SCHEDULE:
Weeks 1 - 3 -- OODBMS Fundamentals
Week 4 -- Project I
Weeks 5 - 7 -- Oracle8 Object Features
Week 8 -- JDBC
Week 9 -- Project II
Week 10 -- SQLJ and Pro*C/C++
Weeks 11 - 14 -- OODBMS System and Architecture
Week 12 -- Spring Break
Weeks 15 - 16 -- Advanced RDBMS Features
Week 17 -- Open
DISHONESTY:
Under no circumstances will acts of academic dishonesty be tolerated. Any suspected incidents of dishonesty will be promptly referred to the Academic Honesty Committee. Refer to the SGA Code of Laws, Chapter 1011.