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

Restriction
COSC 344, COSC 430
Eligibility

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

Contact

Computer Science Adviser advisor@cs.otago.ac.nz

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.

Textbooks

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

Timetable

Semester 1

Location
Dunedin
Teaching method
This paper is taught On Campus
Learning management system
Blackboard

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

Lecture

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

Tutorial

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

Semester 1

Location
Dunedin
Teaching method
This paper is taught through Distance Learning
Learning management system
Blackboard