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 09 (Year 3 Undergraduate) |
Credits |
10 |
Home subject area |
Informatics |
Other subject area |
None |
Course website |
None |
|
|
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
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 |
Course Delivery Information
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. |
Please see Visiting Student Prospectus website for Visiting Student Assessment information |
Special Arrangements
Not entered |
Contacts
Course organiser |
Dr Richard Mayr
Tel: (0131 6)50 5130
Email: rmayr@staffmail.ed.ac.uk |
Course secretary |
Miss Tamise Totterdell
Tel: 0131 650 9970
Email: t.totterdell@ed.ac.uk |
|
copyright 2010 The University of Edinburgh -
1 September 2010 6:10 am
|