Undergraduate Course: Database Systems Implementation (INFR09026)
|School||School of Informatics
||College||College of Science and Engineering
|Credit level (Normal year taken)||SCQF Level 9 (Year 3 Undergraduate)
||Availability||Available to all students
|Summary||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 (not applicable to Visiting Students)
|| Students MUST have passed:
Database Systems (INFR09011)
||Other requirements|| Successful completion of Year 2 of an Informatics Single or Combined Degree, or equivalent by permission of the School.
Information for Visiting Students
Course Delivery Information
|Not being delivered|
| 1 - 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.)
2 - Demonstrate knowledge of query evaluation by enumerating different evaluation algorithms for different relational algebra operators.
3 - Implement query evaluation algorithms in the context of a database system.
4 - Demonstrate knowledge of query optimisation by describing the optimisation methodology used by contemporary database systems.
5 - Describe transaction processing and concurrency control by enumerating alternatives of addressing these problems.
6 - Address the issue of recovery in database systems by describing the algorithms employed during system crashes and transaction aborts.
|Graduate Attributes and Skills
|Course organiser||Dr Nigel Goddard
Tel: (0131 6)51 3091
|Course secretary||Miss Tamise Totterdell
Tel: 0131 650 9970