Advanced Databases (Level 11) (P00889)

? Credit Points : 10 ? SCQF Level : 11 ? Acronym : INF-P-ADBS

This module aims at furthering the concepts introduced in the Database Systems module, through adding complexity and a more hands-on approach. In particular, we will focus on the concepts of query optimisation and evaluation from an implementation-oriented point of view. We will focus on the path a database query follows: (i) declaratively specified in SQL, (ii) translated in an algebraic representation, (ii) optimised through a cost-based optimisation framework, (iv) tranaslated into an evaluation plan, and, finally, (v) evaluated by the database engine.

Entry Requirements

? Pre-requisites : Students must have taken an introductory Database course. If you have not taken one, please consult the instructor before enrolling to obtain consent.

Subject Areas

Home subject area

Computer Science, (School of Informatics, Schedule O)

Delivery Information

? Normal year taken : Postgraduate

? Delivery Period : Semester 1 (Blocks 1-2)

? Contact Teaching Time : 2 hour(s) per week for 10 weeks

First Class Information

Date	Start	End	Room	Area	Additional Information
22/09/2005	14:00	15:00	Room G.01, William Robertson Building	Central

All of the following classes

Type	Day	Start	End	Area
Lecture	Monday	14:00	14:50	Central
Lecture	Thursday	14:00	14:50	Central

Summary of Intended Learning Outcomes

It is anticipated that students who successfully complete the course will be able to:

-Discuss the application of database systems in Informatics
-Describe how database systems work
-Analyse data and describe using common description methods such as ER diagrams and XML
-Convert ER schema into relational tables, populate a relational database and run queries on the data
-Design and implment appropriate interfaces (middleware) to database systems
-Disucss the limitations of database and data handling technologies
-Explain the relationship between database limitations and the underlying technology
-Contrast relational systems with semi-structured approaches
-Describe examples of current research in the field