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

COMP33212: Advanced Database Systems (2011-2012)

This is an archived syllabus from 2011-2012

Advanced Database Systems
Level: 3
Credit rating: 10
Pre-requisites: COMP23111
Co-requisites: No Co-requisites
Duration: 11 weeks
Lectures: 16 lectures
Examples classes: 4 tutorials
Lecturers: Sandra Sampaio
Course lecturer: Sandra Sampaio

Additional staff: view all staff
Sem 2 Lecture 1.4 Thu 15:00 - 17:00 -
Assessment Breakdown
Exam: 85%
Coursework: 0%
Lab: 15%

Themes to which this unit belongs
  • Enterprise Information Systems


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

Programme outcomeUnit learning outcomesAssessment
A2 A5Understand the role of SQL in the development of applications over relational databases.
  • Examination
  • Individual coursework
A2 A5Be familiar with programming language extensions to SQL, and the integration of SQL with programming languages.
  • Individual coursework
  • Examination
A2 A5Understand how information is organised in object databases, and how this impacts on the programming of object database systems.
  • Individual coursework
  • Examination
A2 A5 B3Be familiar with the JDO standard for object database programming.
  • Individual coursework
  • Examination
A2 A5 B3Understand semi-structured data management, and be familiar with techniques for storing and querying XML data.
  • Individual coursework
  • Examination
A2 A5Be aware of the principal challenges that have to be addressed in the development of distributed database systems.
  • Examination
  • Individual coursework
A2 A5 B3Be aware of the issues involved in selecting between different development platforms for database applications.
  • Examination
  • Individual coursework


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)

Reading List

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

Supplementary Text
Title: Principles of distributed database systems (3rd edition)
Author: Ozsu, M. Tamer and Patrick Valduriez
ISBN: 9781441988331
Publisher: Springer
Edition: 3rd
Year: 2011

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: Object-relational DBMSs: tracking the next great wave (2nd edition)
Author: Stonebraker, Michael and Paul Brown, with Dorothy Moore
ISBN: 1558604529
Publisher: Morgan-Kaufmann
Edition: 2nd
Year: 1999