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 data mining, multidimensional indexing, temporal databases, and distributed database architectures.

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, the theory of functional dependencies, 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 two parts. The first covers the "advanced" material naturally following on from COSC344 - Relational theory, extensions to ER-modelling, and practical database server management. The second part provides a survey of current topics of database research, drawn from major database publications of the past two decades.

Part 1: Introduces the essential properties and axioms of relational theory, as they relate to the design and refinement of relational schemas. Describes the algorithms used to manipulate functional dependencies, and examines some of the generic schemas used to solve typical application problems. Explains the resource-management and design decisions faced by database administrators, and provides practical examples of database server setup,security management and data integrity management.

Part 2: Covers current research within the database field, starting with the interests of staff within the Department. The bulk of this part will be different every year, as it will be driven by the specific interests of the students and staff members. Topics which are likely to be covered (and have been taught in the past) include: data mining, multidimensional indexing, temporal databases, distributed databases, Web databases, distributed key-value stores, data warehousing, and non-relational data models.

For more information about this paper, contact Dr David Eyers.