Skip to navigation | Skip to main content | Skip to footer

COMP30311: Advanced Databases (2008-2009)

This is an archived syllabus from 2008-2009

Advanced Databases
Level: 3
Credit rating: 10
Pre-requisites: COMP20312 or INFO21001
Co-requisites: No Co-requisites
Duration: 11 weeks.
Lectures: 22
Lecturers: Goran Nenadic, Sandra Sampaio
Course lecturers: Goran Nenadic

Sandra Sampaio

Additional staff: view all staff
Sem 1 w1-5,7-12 Lecture 1.5 Tue 15:00 - 17:00 -
Assessment Breakdown
Exam: 85%
Coursework: 0%
Lab: 15%
Degrees for which this unit is optional
  • Artificial Intelligence BSc (Hons)


The aim of the course is to give students an awareness of programming and modelling issues that are central to advanced database systems.

Learning Outcomes

A student completing this course unit should:

Understand the role of SQL in the development of applications over relational databases. (A)
Be familiar with programming language extensions to SQL, and the integration of SQL with programming languages. (A)
Understand how information is organised in object databases, and how this impacts on the programming of object database systems. (A)
Be familiar with the JDO standard for object database programming. (A, B)
Understand semi-structured data management, and be familiar with techniques for storing and querying XML data. (A, B)
Understand the main issues in multimedia databases, and be familiar with techniques for storage, querying and retrieval of multimedia data (A, B).
Be aware of the issues involved in selecting between different development platforms for database applications. (A, B)

Assessment of Learning outcomes

All learning outcomes are assessed by examination and during lab sessions.

Examination: 85% (3 questions from 5).
Laboratory: 15% (5 sessions, practicing tools and methods discussed during the lectures).

Contribution to Programme Learning Outcomes

A2, A5, B3.


Current Database Systems

A review of current technologies, the issues raised by them, and outstanding problems. (1)

Programming Relational Databases

Interfacing to relational databases; JDBC impedance mismatches; extending the relational model; extending SQL with programming facilities (using PL/SQL); active rules (using Oracle Triggers). (6)

Object Databases

Supporting object modelling in database systems; the JDO standard, including querying persistent objects. (4)

Semistructured Data Management

Semistructured data models, compared with relational and object models; XML repositories; database support for XML data, including querying; programming XML databases. (5)

Multimedia databases

Nature of multimedia data: multimedia data storage and management; content-based querying and retrieval; meta-data generation, ontologies, challenges; retrieval from textual databases. (6)

Reading List

Core Text
Title: Java data objects
Author: Jordan, David and Craig Russell
ISBN: 0596002769
Publisher: O'Reilly
Year: 2003

Supplementary Text
Title: Database systems: the complete book (2nd edition)
Author: Garcia-Molina, Hector and Jeffrey D. Ullman and Jennifer Widom
ISBN: 9780131354289
Publisher: Pearson
Edition: 2nd
Year: 2009

Supplementary Text
Title: Advanced database technology and design
Author: Piattini, Mario and Oscar Diaz (eds.).
ISBN: 0890063958
Publisher: Artech House
Year: 2000

Supplementary Text
Title: Multimedia databases: an object relational approach
Author: Dunckley, Lynne
ISBN: 0201788993
Publisher: Addison-Wesley
Year: 2002