Advanced Database Management Topics

Description
This course is a continuation of CSCI-4380 and presents a more theoretical approach to logical and physical database design. It covers such topics as algorithms for logical database design, primary and secondary indexing techniques, query processing and query optimization, and database security. Topics include the following database systems: Parallel, Main Memory, Information Retrieval and Textual Temporal Real-time, Spatial, and Deductive. Problems of interfacing a database system with an operating system, and some of the issues in implementing distributed database systems are also discussed. Much of the material comes from recent research papers. A term paper or project will be required.

Prerequisites
Database Systems (CSCI-4380)

Textbook(s)
Ordering Information

Format
Classes: 14 sessions
Project: 1
Exams: 2

Grading
Project: 33%
Exams: 67%

Computing
Email and World Wide Web access required for course communications and printing of course notes.

Access to WebCT, Rensselaer's course management tool, is required. Please refer to this page for instructions on how to set up your computer for WebCT.

Who Should Enroll
This course may be used in your Plan of Study as follows:

Degree Programs
CSCI - Applications course or elective
CSYS - toward two-course sequence or elective (both with advisor pre-approval)
ELEC - elective with advisor pre-approval
EPOW - elective with advisor pre-approval
ESCI-MM - elective with advisor pre-approval
ESCI-MOT - elective with advisor pre-approval
ESCI-MSE - Information Science Concentration course or as an elective
ITEC - Database Systems Design application area course
MANE - elective with advisor pre-approval
MBA - elective with advisor pre-approval
MGMT-MS - elective with advisor pre-approval
QUAL - elective with advisor pre-approval
SERV - elective with advisor pre-approval
TCOM - elective with advisor pre-approval

This course is open to non-matriculated students who meet the prerequisites. It may also be used toward the Certificate in Computer Science and the Certificate in Database Systems Design.

NOTE: Limited enrollment, please register early. Distance students will not be added into the course once the cap has been met.