Postgraduate Course: Applied Databases (INFR11015)
Course Outline
| School | School of Informatics |
College | College of Science and Engineering |
| Credit level (Normal year taken) | SCQF Level 11 (Postgraduate) |
Availability | Available to all students |
| SCQF Credits | 10 |
ECTS Credits | 5 |
| Summary | Applied Databases covers the practical application of current database technology and strategies for dealing with complex data. The course will focus on the practical application Relational Database Systems with reference to the underlying design limitations of such systems. |
| Course description |
* Introduction to Databases: Data models and Schema design; SQL and relational database systems; Indexes and query optimisation; Interfaces and middleware design choices and assessment; XML and semi-structured data.
* Strategies for dealing with complex data: We will examine existing database systems in various scientific fields and review strategies used by these resources to tackle the key issues. Although focussing on astonomy, biological and neuroscience examples, the content will be of general appicability.
* Practical Implementation: Key Database software packages will be reviewed; The course will cover basic middleware design and implementation with examples.
Relevant QAA Computing Curriculum Sections: Databases, Middleware
|
Entry Requirements (not applicable to Visiting Students)
| Pre-requisites |
|
Co-requisites | |
| Prohibited Combinations | |
Other requirements | For Informatics PG and final year MInf students only, or by special permission of the School. |
Information for Visiting Students
| Pre-requisites | None |
Course Delivery Information
| Not being delivered |
Learning Outcomes
1 - Discuss the application of database systems in Informatics
2 - Describe how database systems work
3 - Analyse data and describe using common description methods such as ER diagrams and XML
4 - Convert ER schema into relational tables, populate a relational database and run queries on the data
5 - Design and implment appropriate interfaces (middleware) to database systems
6 - Disucss the limitations of database and data handling technologies
7 - Explain the relationship between database limitations and the underlying technology
8 - Contrast relational systems with semi-structured approaches
9 - Describe examples of current research in the field
|
Reading List
| Database Management Systems: Ramakrishnan & Gherke, published by McGraw Hill 2003 |
Contacts
| Course organiser | Dr Michael Rovatsos
Tel: (0131 6)51 3263
Email: mrovatso@inf.ed.ac.uk |
Course secretary | Miss Kate Weston
Tel: (0131 6)50 2692
Email: Kate.Weston@ed.ac.uk |
|
|
University Homepage