Undergraduate Course: Database Systems Implementation (INFR09026)
Course Outline
| School | School of Informatics |
College | College of Science and Engineering |
| Course type | Standard |
Availability | Available to all students |
| Credit level (Normal year taken) | SCQF Level 9 (Year 3 Undergraduate) |
Credits | 10 |
| Home subject area | Informatics |
Other subject area | None |
| Course website |
None |
Taught in Gaelic? | No |
| Course description | 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)
| 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. |
| Additional Costs | None |
Information for Visiting Students
| Pre-requisites | None |
| Displayed in Visiting Students Prospectus? | Yes |
Course Delivery Information
| Not being delivered |
Summary of Intended 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. |
Assessment Information
Written Examination 70
Assessed Assignments 30
Oral Presentations 0
Assessment
Two programming assignments. Both assignments will be implementations of query processing algorithms in the context of an existing database system. |
Special Arrangements
| None |
Additional Information
| Academic description |
Not entered |
| Syllabus |
Not entered |
| Transferable skills |
Not entered |
| Reading list |
Not entered |
| Study Abroad |
Not entered |
| Study Pattern |
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