computer science



Advanced Database Topics

Semester 1

Examines the theory and practice of database design and administration. Also provides a survey of research in the database field, such as distributed database, data mining, time series database, graph database, embedded database, and temporal/geographic databases.

This course explores the practical and theoretical concerns of modern approaches to database design and management. The fundamentals of this topic are already covered in COSC344 (Database Theory and Applications), in which students learn about Entity-Relationship modelling, query languages, and client-side application programs. This course instead concentrates on concepts of database resource management, database administration, and the state of the art in the field of database research. Students will learn:

- The principles of installing and managing a database server
- The fundamental theories of relational algebra
- Topics of current research within the field
- A range of database-related applications and technologies

Course Outline (may be subject to change):

The course falls into the following three parts:

Part I introduces the data models developed for database design. It covers the hierarchical model, network model, relational model, and the new data models for non-relational databases.

Part II provides two practice sessions on database administration. The first session gives a tutorial on installing, configuring, and managing Oracle DBMS relating to every-day tasks that might be encountered by a database administrator. The second session gives a tutorial on installing, configuring and using Cassandra.

Part III covers advanced database technologies and the current research in the database field. The topics include distributed databases, data mining, time-series databases, key-value stores, graph databases, and embedded databases.

For more information about this paper, contact Dr Haibo Zhang.