Red X iconGreen tick iconYellow tick icon

    Overview

    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.

    About this paper

    Paper title Advanced Database Technologies
    Subject Computer Science
    EFTS 0.1667
    Points 20 points
    Teaching period(s) Semester 1 (Distance learning)
    Semester 1 (On campus)
    Domestic Tuition Fees ( NZD ) $1,448.79
    International Tuition Fees Tuition Fees for international students are elsewhere on this website.
    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, Java programming and basic system administration).

    Contact

    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.

    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 Enhanced Entity-Relationship (EER) 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

    Timetable

    Semester 1

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

    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-13, 15-22
    A2 Wednesday 12:00-13:50 9-13, 15-22

    Lecture

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

    Tutorial

    Stream Days Times Weeks
    Attend
    A1 Friday 11:00-11:50 12, 16-21
    Back to top