Accessibility Skip to Global Navigation Skip to Local Navigation Skip to Content Skip to Search Skip to Site Map Menu

COSC444 Advanced Database Technologies

Advanced relational database theory, database security, data backup and recovery, distributed databases, NoSQL databases, state-of-the-art research in the database field.

The aim of this paper is to provide students with an understanding of the modern database technologies. It concentrates on concepts of database modelling, database implementation, resource management, database administration, the theory of relational and NoSQL models, and the state of the art in the field of database research.

Paper title Advanced Database Technologies
Paper code COSC444
Subject Computer Science
EFTS 0.1667
Points 20 points
Teaching period(s) Semester 1 (On campus)
Semester 1 (Distance learning)
Domestic Tuition Fees (NZD) $1,409.28
International Tuition Fees Tuition Fees for international students are elsewhere on this website.

^ Top of page

COSC 344, COSC 430

There are no formal prerequisites for the 400-level papers, but prior knowledge is assumed (particularly regarding database systems, programming and basic system administration).


Computer Science Adviser

Teaching staff

Associate Professor Haibo Zhang and Dr Yawen Chen

Paper Structure

The paper covers the following topics,

  • Conceptual database modelling using the Entity-Relationship model.
  • Theory of the relational data model.
  • SQL language and programming.
  • NoSQL theory and databases.
  • Database indexing, transaction, concurrency control, backup and recovery.
  • Distributed databases.

Internal Assessments: 60%

  • Assignment 1: 8%
  • Assignment 2: 15%
  • Assignment 3: 17%
  • Research project: 20%

Final exam: 40%

Teaching Arrangements

Two one-hour lecture per week.

One two-hour lab per week.

Four tutorials on advanced database technologies.


Recommended: Elmasri, R. & Navathe, S., (2006). Fundamentals of Database Systems (7th Edition), Pearson Education Limited.

Graduate Attributes Emphasised

Scholarship, Communication, Information literacy, Lifelong learning, Critical thinking, Research,
View more information about Otago's graduate attributes.

Learning Outcomes

Students who successfully complete the paper will:

  • Conduct advanced Entity-Relationship (ER) modelling.
  • Understand advanced relational theory on functional dependency and normalisation.
  • Appreciate the limitations of the relational database model and features introduced by alternative NoSQL database models.
  • Contextualise advanced database research topics.
  • Perform practical database design, data manipulation and database administration

^ Top of page


Semester 1

Teaching method
This paper is taught On Campus
Learning management system

Computer Lab

Stream Days Times Weeks
Attend one stream from
A1 Wednesday 10:00-11:50 9-14, 16-22
A2 Wednesday 12:00-13:50 9-14, 16-22


Stream Days Times Weeks
A1 Monday 09:00-09:50 9-14, 16-22
Wednesday 09:00-09:50 9-14, 16-22


Stream Days Times Weeks
A1 Friday 11:00-11:50 13, 16-21

Semester 1

Teaching method
This paper is taught through Distance Learning
Learning management system