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

COSC430 Advanced Database Topics

The theory and practice of database design and administration. Survey of research in the database field, such as data mining, multidimensional indexing, temporal databases, and distributed database architectures.

Paper title Advanced Database Topics
Paper code COSC430
Subject Computer Science
EFTS 0.1667
Points 20 points
Teaching period First Semester
Domestic Tuition Fees (NZD) $1,307.76
International Tuition Fees (NZD) $5,517.77

^ Top of page

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). Admission to these papers is restricted not only by numbers, but by satisfactory grades in 300-level COSC papers. COSC 430 requires students to have experience installing and using software entirely from a text console.
Contact
Computer Science Adviser
Teaching staff

Lecturers: Dr Haibo Zhang and Cathy Chandra

Paper Structure

This paper explores the practical and theoretical concerns of modern approaches to database design and management. The fundamentals of this topic are already covered in COSC 344 (Database Theory and Applications), in which students learn about Entity-Relationship modelling, query languages and client-side application programs. This paper 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.

Assessment:

  • Three assignments 15%, 10%, and 15%
  • Final exam 60%
Teaching Arrangements
There is one 2-hour lecture per week.
Some of the practical sessions will be carried out in a computer lab during the lecture time slot.
Textbooks
Recommended:

Elmasri and Navathe, Database Systems, 6th Ed, Pearson, 2011

David Maier, The theory of relational databases, Pitman, 1983

C.J. Date, An Introduction to Database Systems, 6th, 7th or 8th Ed, Addison-Wesley, 1995, 2000, 2004
Course outline
View the course outline for COSC 430
Graduate Attributes Emphasised
Lifelong learning, Communication, Critical thinking, Ethics, Information literacy, Research, Self-motivation, Teamwork.
View more information about Otago's graduate attributes.
Learning Outcomes
This paper will enable students to:
  • Understand advanced relational database theory
  • Appreciate the limitations of the relational database model and features introduced by alternative database models
  • Contextualise advanced database research topics
  • Perform practical database administration

^ Top of page

Timetable

First Semester

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

Lecture

Stream Days Times Weeks
Attend
A1 Monday 10:00-11:50 9-16, 18-22