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 Prof AFG Taktak
Physics
Afgt@liverpool.ac.uk
Year CATS Level Semester CATS Value
Session 2022-23 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
Description: Classroom based lectures
Attendance Recorded: Not yet decided

Teaching Method 2 - Problem Based Learning
Description: PBL scenarios
Attendance Recorded: Yes

Teaching Method 3 - Group-work
Description: Working in a group on database design
Attendance Recorded: Yes


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    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    70       

Recommended Texts

Reading lists are managed at readinglists.liverpool.ac.uk. Click here to access the reading lists for this module.