Module Details |
The information contained in this module specification was correct at the time of publication but may be subject to change, either during the session because of unforeseen circumstances, or following review of the module at the end of the session. Queries about the module should be directed to the member of staff with responsibility for the module. |
Title | Databases and Data Mining | ||
Code | PHYS865 | ||
Coordinator |
Professor A Taktak Physics Afgt@liverpool.ac.uk |
||
Year | CATS Level | Semester | CATS Value |
Session 2024-25 | Level 7 FHEQ | Second Semester | 10 |
Aims |
|
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. |
Learning Outcomes |
|
(LO1) Have a knowledge of databases and be able to develop a database structure to meet a clinical need. |
|
(LO2) Have the ability to implement SQL and data mining strategies on large data sets. |
|
(LO3) Summarise and present data from large clinical data sets |
|
(S1) IT skills |
Syllabus |
|
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 |
Teaching and Learning Strategies |
|
Teaching Method 1 - Lectures Teaching Method 2 - Problem Based Learning Teaching Method 3 - Group-work |
Teaching Schedule |
Lectures | Seminars | Tutorials | Lab Practicals | Fieldwork Placement | Other | TOTAL | |
Study Hours |
10 |
6 15 |
31 | ||||
Timetable (if known) | |||||||
Private Study | 69 | ||||||
TOTAL HOURS | 100 |
Assessment |
||||||
EXAM | Duration | Timing (Semester) |
% of final mark |
Resit/resubmission opportunity |
Penalty for late submission |
Notes |
CONTINUOUS | Duration | Timing (Semester) |
% of final mark |
Resit/resubmission opportunity |
Penalty for late submission |
Notes |
Software Development Demonstration There is a resit opportunity. Standard UoL penalty applies for late submission. This is not an anonymous assessment. Assessment Schedule (When) :June of Semes | 0 | 30 | ||||
Database Applications Report There is a resit opportunity. Standard UoL penalty applies for late submission. This is not an anonymous assessment. Assessment Schedule (When) :End of April of sem | 0 | 70 |
Recommended Texts |
|
Reading lists are managed at readinglists.liverpool.ac.uk. Click here to access the reading lists for this module. |