Database Systems Implementation (U03445)

? Credit Points : 10 ? SCQF Level : 9 ? Acronym : INF-3-DSI

This course is a continuation of the Database Systems course, but is implementation-oriented. In particular, it will go into further detail of query evaluation, query optimisation, transaction processing, concurrency control and recovery in database systems. Moreover, students taking this course will be able to work with and modify the source code of a database system as part of their programming assignments.

Entry Requirements

? Pre-requisites : Database Systems Successful completion of Year 2 of an Informatics Single or Combined Degree, or equivalent by permission of the School.

Subject Areas

Home subject area

Database Systems, (School of Informatics, Schedule O)

Delivery Information

? Normal year taken : 3rd year

? Delivery Period : Semester 2 (Blocks 3-4)

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

First Class Information

Date	Start	End	Room	Area	Additional Information
07/01/2008	12:10	13:00			To Be Confirmed

All of the following classes

Type	Day	Start	End	Area
Lecture	Monday	12:10	13:00	Central
Lecture	Thursday	12:10	13:00	Central

Summary of Intended Learning Outcomes

Upon successful completion of the course the students will be able to:

* Assess performance of database systems and their algorithms by having knowledge of the cost metrics used by I/O intensive applications (such as a database system.)
* Demonstrate knowledge of query evaluation by enumerating different evaluation algorithms for different relational algebra operators.
* Implement query evaluation algorithms in the context of a database system.
* Demonstrate knowledge of query optimisation by describing the optimisation methodology used by contemporary database systems.
* Describe transaction processing and concurrency control by enumerating alternatives of addressing these problems.
* Address the issue of recovery in database systems by describing the algorithms employed during system crashes and transaction aborts.