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

COMP30311: Advanced Databases (2007-2008)

This is an archived syllabus from 2007-2008

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, Norman Paton
Course lecturers: Goran Nenadic

Norman Paton

Additional staff: view all staff
Timetable
SemesterEventLocationDayTimeGroup
Sem 1 w1-5,7-12 Lecture 1.5 Thu 11:00 - 12:00 -
Sem 1 w1-5,7-12 Lecture 1.5 Fri 14:00 - 15:00 -
Assessment Breakdown
Exam: 100%
Coursework: 0%
Lab: 0%
Degrees for which this unit is optional
  • Artificial Intelligence BSc (Hons)

Aims

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.

Contribution to Programme Learning Outcomes

A2, A5, B3.

Syllabus

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
Edition:
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
Edition:
Year: 2000


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