CS 505 - Intermediate Topics in Database Systems

Credits: 3

Course Description

The course introduces a variety of modern techniques in database and distributed database systems. The major topics include, but are not limited to: object-oriented database systems; distributed, heterogeneous and web-based databases; knowledge based systems; physical database design; and security. The course covers a variety of methods that allow for a solution of database problems where the traditional relational database techniques are not viable or not sufficient

Prereqs: CS-405G or consent of instructor.

Needed Skills

Understanding of relational databases and relational languages. Programming in an object-oriented programming language.

Additional Comments

It is expected that the students will learn the details of the design and some aspects of implementation of database management systems (as opposed to the first course in databases where they learned only the fundamentals of DBMS such as the languages for databases and the design theory). This extended knowledge includes: security in database management systems, object-oriented data models, web-based databases, transaction management, and parallel and distributed databases.

CAC Categories

Topic	Core	Advanced
Math Fundamentals	0	0
Data Structures	3	10
Algorithms & Software Design	0	9
Computer Organization and Architecture	0	3
Concepts of Programming Languages	4	10
Social and ethical issues	0	1
Total	6	33

Possible Textbooks

Database Systems The Complete Book, 1/e
Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer D. Widom
© 2002 / 0-13-031995-3 / Prentice Hall

Database Management Systems
R. Ramakrishnan and J. Gehrke
McGraw-Hill 2000

Database Systems
T. Connolly, C. Begg, A. Strachan
Addison Wesley 1999

Additional materials in form of articles and reviews published in periodicals may be supplied by the instructor.