COMP30311: Advanced Databases (2009-2010)
The aim of the course is to give students an awareness of programming and modelling issues that are central to advanced database systems.
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 outcomesAll learning outcomes are assessed by examination and course work.
Examination: 85% (3 questions from 5).
Course work: 15% (includes the practicing of software tools in lab and methods discussed during the lectures).
Contribution to Programme Learning OutcomesA2, 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)
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)
Nature of multimedia data: multimedia data storage and management; content-based querying and retrieval; meta-data generation, ontologies, challenges; retrieval from textual databases. (6)
Core TextTitle: Java data objects
Author: Jordan, David and Craig Russell
Supplementary TextTitle: Advanced database technology and design
Author: Piattini, Mario and Oscar Diaz (eds.).
Publisher: Artech House
Supplementary TextTitle: Multimedia databases: an object relational approach
Author: Dunckley, Lynne
Supplementary TextTitle: Database systems: the complete book (2nd edition)
Author: Garcia-Molina, Hector and Jeffrey D. Ullman and Jennifer Widom
Supplementary TextTitle: Object-relational DBMSs: tracking the next great wave (2nd edition)
Author: Stonebraker, Michael and Paul Brown, with Dorothy Moore