Advanced Database Topics

Graduate

This course will introduce students to advanced topics in database design and information retrieval. Topics covered may include DBMS three-schema level architectures, data models (e.g., relational, object-oriented model), query languages (e.g. Oracle SQL, PL/SQL), file organization and indexing, transaction management, concurrency control, security and recovery procedures, information retrieval on the internet, and other advanced topics (e.g. online analytical processing - OLAP, data warehouses and data mining). This course is restricted to students in the Master of Applied Computing program).