Postgraduate Course: Applied Databases (INFR11015)
|School||School of Informatics
||College||College of Science and Engineering
|Credit level (Normal year taken)||SCQF Level 11 (Postgraduate)
||Availability||Available to all students
|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.
* 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)
||Other requirements|| For Informatics PG and final year MInf students only, or by special permission of the School.
Information for Visiting Students
Course Delivery Information
|Not being delivered|
| 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
|Database Management Systems: Ramakrishnan & Gherke, published by McGraw Hill 2003|
|Course organiser||Dr Michael Rovatsos
Tel: (0131 6)51 3263
|Course secretary||Miss Kate Weston
Tel: (0131 6)50 2692