Rapid Organisation of Health Research Data Project

1. Rapid Organisation of Health Research Data • Project Michael Soljak / YutongCai, Department of Primary Care & Public Health, School of Public Health Vasa Curcin / Saiful Islam, Department of Computing

2. 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)

3. Metadata strategy • 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 http://protege.stanford.edu/

4. Database query portal Cost of hospital admission per region What is the total cost of hospital admissions? What is the total number of patient referred to the hospital? What is the cost of hospital admissions per year? Compare practice wise prescribed drugs Region and year wise drugs prescribed? Names of all drugs prescribed? Referral Compare region wise prescribed drugs Practice, region and year wise prescribed drugs Therapy Compare year and practice wise prescribed drugs Drug prescriptions per practice and year Prescribed drug list per practice Practice What are the prescribed drugs with an average number of prescriptions / patient with a particular disease? What are the drugs prescribed for a particular disease? GPRD for the whole population How many patients are there with a particular disease? Clinical What is the average number of prescription/patient used for a particular disease? List of conditions in the cohort? Year wise prescribed drugs with an average number of prescriptions / patient with a particular disease? What are the year wise average number of the prescriptions/patient? What is the average number of prescriptions/patient? What are the region wise average number of visits and prescriptions visits /patients? Patient Year and region wise prescribed drugs with an average number of prescriptions / patient with a particular disease? What is the average number of prescriptions /patient in a region? What is the average number of visits/patient? What are the year wise average number of the prescriptions and visits /patient? Consultation What are the year wise average number of the visits /patient? Year and region wise prescribed drugs with an average number of prescriptions and visits / patient with a particular disease? Consultationtype breakdown Year wise average number of prescriptions, visits and consultation time / patient? What is the average number of the visits /patient in a region? What is the preferred mode of consultation? Year, region and practice wise prescribed drugs with an average number of prescriptions and visits / patient with a particular disease? What is average consultation time (in minutes) / patient?

5. Web interface Running on: http://simmia.doc.ic.ac.uk:8080/rohrd

6. 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