Undergraduate Course: Database Systems Implementation (INFR09026)
Course Outline
| 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 |
| SCQF Credits | 10 |
ECTS Credits | 5 |
| 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. |
| Course description |
Not entered
|
Entry Requirements (not applicable to Visiting Students)
| Pre-requisites |
Students MUST have passed:
Database Systems (INFR09011)
|
Co-requisites | |
| Prohibited Combinations | |
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
| Pre-requisites | None |
Course Delivery Information
| Not being delivered |
Learning Outcomes
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.
|
Additional Information
| Graduate Attributes and Skills |
Not entered |
| Keywords | Not entered |
Contacts
| Course organiser | Dr Nigel Goddard
Tel: (0131 6)51 3091
Email: Nigel.Goddard@ed.ac.uk |
Course secretary | Miss Tamise Totterdell
Tel: 0131 650 9970
Email: t.totterdell@ed.ac.uk |
|
|
University Homepage