Michael Soljak / Yutong Cai, Department of Primary Care & Public Health, School of Public Health

Vasa Curcin / Saiful Islam, Department of Computing

Rapid Organisation of Health Research DataProject

ROHRD Project Objectives To develop metadata for current and planned PCPH data

sources To develop a research data management plan for PCPH To integrate the PCPH primary care and national data

repositories within the same framework To create a generic, extensible data access strategy and

database design To produce policies and forms for reuse of aggregate

health research data originally derived from Hospital Episodes Statistics (HES)

Metadata strategy

http://protege.stanford.edu/

Help! (employ a data manager) Metadata: continue exploration of

SNOMED-CT in Protege as a metadata resource

Developed a custom metadata format for medical data sets at Imperial’s Faculty of Medicine

Using EndNote and OWL (authored in Protégé) as representation formats

SNOMED CT terminology for domain annotations public health domain derived from the

UK Public Health Language comprehensive, scientifically-validated

content Can map to other international

standards

Database query portal

GPRD for the whole population

How many patients are there with a particular

disease?

What is the average number of

visits/patient?

What are the drugs prescribed for a particular

disease?

What is the total cost of hospital

admissions?

Consultation type breakdown

What is the average number of

prescription/patient used for a particular disease?

What is the cost of hospital

admissions per year?

What are the region wise average number of visits and prescriptions

visits /patients?

Cost of hospital admission per

region

What is the average number of

prescriptions /patient in a region?

What is the average number of the visits /patient in a region?

What are the year wise average number of the

visits /patient?

What are the year wise average number of the prescriptions and visits /patient?

Region and year wise drugs prescribed?

What are the prescribed drugs with an average number of prescriptions / patient with a particular disease?

Year wise prescribed drugs with an average number of

prescriptions / patient with a particular disease?

List of conditions in the cohort?

Patient

Practice

Therapy

Referral

Clinical

Consultation

What is the total number of patient

referred to the hospital?

Names of all drugs

prescribed?

Prescribed drug list per practice

Drug prescriptions per practice and

year

Practice, region and year wise

prescribed drugs

Compare practice wise prescribed drugs

Compare region wise prescribed drugs

Compare year and practice wise

prescribed drugs

What is the average number of

prescriptions/patient?

What are the year wise average number of the prescriptions/patient? Year and region wise

prescribed drugs with an average number of prescriptions

/ patient with a particular disease?

Year and region wise prescribed drugs with an average number

of prescriptions and visits / patient with a particular

disease?

Year, region and practice wise prescribed drugs with an average

number of prescriptions and visits / patient with a particular disease?

What is the preferred mode of consultation? What is average

consultation time (in minutes) /

patient?

Year wise average

number of prescriptions,

visits and consultation

time / patient?

Web interfaceRunning on: http://simmia.doc.ic.ac.uk:8080/rohrd

Actions from the project: our RoaDMaP

Help! (employ a data manager) Metadata: continue exploration of SNOMED-CT in

Protege as a metadata resource Use requirements study findings Obtain approval for migration of sensitive data to a

super secure server provided by ICT Further refine the database query portal and

encourage takeup Consider whether we can use DataStage and

DataBank Then integrate data in new database design Policies change- see what’s in the new HES protocol Encourage corporate development of MRD projects Offer training to PCPH staff