The aim of this module is to teach students about the fundamental principles involved in database design and management to gather with data mining techniques in a clinical setting. This will be done through a series of lectures and seminars. The aim is to give the students experience in the use of relational databases and large data warehouses through practical sessions and group discussions based on clinical scenarios.

Have a knowledge of databases and be able to develop a database structure to meet a clinical need.

Have the ability to implement SQL and data mining strategies on large data sets.

 Summarise and present data from large clinical data sets

Database management and data mining

·       The relational model of data

·       Implementation of relational databases

·       Advanced SQL programming

·       Query optimisation

·       Concurrency control and transaction management

·       Database performance tuning

·       Distributed relational systems and data replication

·       Columnstore/data warehousing database engines

·       Document-oriented databases (e.g. Lucene)

·       Security considerations

·       Data mining

·       Large data set methodologies

·       Database standards and standards for interoperability and integration

·       Data analysis and presentation

Lectures - Classroom based lectures

Problem Based Learning - PBL scenarios

Group-work - Working in a group on database design