CS 566 Web Semantics Health Clinic Model Antonis
CS 566 Web Semantics Health Clinic Model Antonis Misargopoulos misarg@csd. uoc. gr Athina Tziaki tziaki@csd. uoc. gr Professor Antoniou Grigoris 1
Introduction n n Health Clinic model is constructed using RDF and RDF Schema HC model is tested using VRP 2. 5 HC Schema is used to construct a Postgres. QL DB of RSSDB HC models a real-world health Clinic activities 2
HC Model Description n Basic Classes: age name Health Clinic weight Person height integer fname string lname specialty card_ID Doctor : sub. Class. Of Staff Patient string ID Assistant RDF Schema 3
HC Model Description n Other Classes edition. Date Treatment s t r i n g name Illness type Advices last. Modified. Date type description Medication ID name description File description Medicine Course 4
HC RDF Schema 6
HC RDF Data : sub. Class. Of : type : association 7
HC Potential Queries (1/2) n n n Information retrieval about health clinics, i. e. what clinic is visited mostly or what specialties supports Information retrieval about clinic staff personal data, i. e. specialty, etc. Information retrieval about patients personal data, i. e. average age, etc. Information retrieval about patients files, i. e. what period of year visit clinic mostly Information retrieval about illnesses, suggested treatments and medicines for research and commercial reasons 8
HC Potential Queries (2/2) n n n n n Find the clinic with the larger number of cardiologists. Find all doctor specialties, Benizeleio supports. Find all doctors, who work at PEPAGNI. Find all patients, monitored by Misargopoulos. How many assistants cooperate with Misargopoulos. Find average of PEPAGNI patients. Find George Jackson’s illness name and type. Find all medicines suggested to Mary Jackson. Find all medicines suggested by Benizeleio doctors Find all assistant take care of George Jackson. 9
HC RDF Schema Limitation (1/2) n Cardinality q q q Each patient visits at least one clinic (1. . . n) If there is a patient, then there is a file and just one (1. . . 1) Each patient has at least one illness (1…n) Each clinic has at least one staff member (1…n) Each medication consists at least of one medicine (1…n) If there is a medicine, then there is a course as well 10
HC RDF Schema Limitation (2/2) n Reverse association q q q n If a doctor cooperates with an assistant, then assistant cooperates with this doctor at once If a file is updated by an assistant, then assistant update this file at once etc. Union, Intersection q q A doctor or an assistant can also be a patient etc. 11
- Slides: 10