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. |
- 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 adviser.cosc@otago.ac.nz
- Teaching staff
- 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
