CS 36500 - Advanced Database Systems

This course examines advanced concepts and modern architectures in database systems. Topics include advanced data modeling and extended SQL features; physical database organization and access methods; query processing and optimization; and transaction management. Additional topics include database security, data warehousing, and modern database technologies such as NoSQL and distributed database systems.

Preparation for Course
P: CS 36400 or IST 27000.

Cr. 3.
Student Learning Outcomes
1. Understand object-relational databases and to use extended SQL. (1, 2)
2. Understand physical database organization, indexing, query processing, and optimization. (1, 2)
3. Understand the fundamental concept of transaction management. (6)
4. Understand database security mechanisms and their role in system integrity. (6)
5. Understand data warehousing and analytical processing concepts. (1, 2)
6. Understand modern database technologies, including NoSQL and distributed database systems. (1)