Introduction

This paper explores the practical and theoretical concerns of modern approaches to database technologies. It falls into the following three parts:

Part I introduces the data models developed for databases.
It covers the hierarchical model, network model, relational model, and the new data models for non-relational database.
Part II provides two practice sessions on database administration.
The first session gives a tutorial on installing and configuring Oracle in order to provide the basis of ongoing practical work on resource, data integrity and security management and design decisions relating to every-day tasks which might be encountered by a working DBA. This ongoing practical work will be assessed for Assignment 2. The second session covers administration of a NoSQL database (Cassandra) and explores data replication.
Part III covers advanced database technologies and the current research and a few practical exercises.
The topics include distributed databases, data mining, time-series databases, key-value stores, graph databases, and embedded databases.

Lectures

The contents of the lectures will be examined in the final examination. They are held in the following locations:

  • Monday at 10am in G.34 Owheo Building (for 2 hours)

Lecture slides will be made available via the schedule page in due course.

Use of the user account you have been given by the department implies acceptance of, and agreement to abide by, departmental regulations, as well as official Otago University computer user policies. You may read more by accessing the information (and following the links) on our information pages on our departmental web site

Assignments

There are three assignments this year for a total of 40%. Make sure you're familiar with the requirements and their due dates. See the assignments page for more details.

Labs

Labs are held in Lab B in the Owheo Building. In some weeks there will be lab-based practical exercises. Check the schedule for more information.

Class representatives

We need at least one class representative, preferably two. Please give some thought to serving your class in this capacity. We really do want to receive useful feedback on how the paper progresses.

Academic Integrity and Academic Misconduct

Academic integrity means being honest in your studying and assessments. It is the basis for ethical decision-making and behaviour in an academic context. Academic integrity is informed by the values of honesty, trust, responsibility, fairness, respect and courage. Students are expected to be aware of, and act in accordance with, the University’s Academic Integrity Policy.

Academic Misconduct, such as plagiarism or cheating, is a breach of Academic Integrity and is taken very seriously by the University. Types of misconduct include plagiarism, copying, unauthorised collaboration, taking unauthorised material into a test or exam, impersonation, and assisting someone else’s misconduct. A more extensive list of the types of academic misconduct and associated processes and penalties is available in the University’s Student Academic Misconduct Procedures.

It is your responsibility to be aware of and use acceptable academic practices when completing your assessments. To access the information in the Academic Integrity Policy and learn more, please visit the University’s Academic Integrity website or ask at the Student Learning Centre or Library. If you have any questions, ask your lecturer.

Contact

Dr. Haibo Zhang
Senior Lecturer
Room 247
Owheo Building
Computer Science Department
P:(03) 479-8534
E:haibo@cs.otago.ac.nz
Dr. Paul Crane
Lecturer
Room 251
Owheo Building
Computer Science Department
E:pcrane@cs.otago.ac.nz
Cathy Chandra
Senior Systems Administrator
Room 121
Owheo Building
Computer Science Department
P:(03) 479-8580
E:cathy@cs.otago.ac.nz