Petrozavodsk State University Department of Computer Science Alexander Borodin, Yulia Zavyalova On an EAV Based Approach to Designing of Medical Data Model for Mobile HealthCare Service This research is financially supported by the Ministry of Education and Science of the Russian Federation within project # 14.574.21.0060 (RFMEFI57414X0060) of Federal Target Program "Research and development on priority directions of scientific-technological complex of Russia for 2014–2020". UBICOMM 2015 conference July 19–24, Nice, France UBICOMM 2015 Alexander Borodin 1 / 19
World population ageing UBICOMM 2015 Alexander Borodin 2 / 19
World population ageing (from UN report, 2013) UBICOMM 2015 Alexander Borodin 3 / 19
Cardiovascular diseases Number 1 cause of death Contribution of CVDs to globally (31% of all global mortality in CIS (percents) deaths in 2012) 1 Georgia 67 Ukraine 64 Can be prevented by Azerbaijan 60 addressing behavioural risk Russia 57 factors (tobacco use, Moldova 56 unhealthy diet, obesity, Belorussia 53 physical inactivity, etc.) Kazakhstan 50 Need early detection and Armenia 50 management Kyrgyzstan 49 Tajikistan 39 1 Source: WHO UBICOMM 2015 Alexander Borodin 4 / 19
Electrocardiogram morphology R R T T P P Q Q S S UBICOMM 2015 Alexander Borodin 5 / 19
Normal sinus rhythm and abnormalities Normal sinus rhythm Sinoatrial block Atrial flutter Sinus tachycardia Wolff-Parkinson-White Sinus bradycardia syndrome Source: Medical Training and Simulation LLC http://www.practicalclinicalskills.com UBICOMM 2015 Alexander Borodin 6 / 19
Rhythm anomalies detection Электрокардиограмма Предобработка Морфологический анализ Рекоммендации Классификация аритмий Неотложный вызов UBICOMM 2015 Alexander Borodin 7 / 19
CardiaCare application UBICOMM 2015 Alexander Borodin 8 / 19
A real example... UBICOMM 2015 Alexander Borodin 9 / 19
Connect to other sensors? UBICOMM 2015 Alexander Borodin 10 / 19
Continuous health monitoring system operation Patient-centered Smartphone Environment sensors wireless sensor network (temperature, smoke, etc.) Environment Prescriptions ECG conditions Alarms SpO2 Personal health data Prescriptions Alarms Sensor data Emergency Data storage and processing help Emergency services Physician workplaces UBICOMM 2015 Alexander Borodin 11 / 19
Smart service on top of monitoring service UBICOMM 2015 Alexander Borodin 12 / 19
Smart service on top of monitoring service (cont.) UBICOMM 2015 Alexander Borodin 13 / 19
EAV model and decomposition Entity Attribute Value John Doe @ 2014-09-01T09:30 Headache Yes Jane Doe @ 2014-09-12T12:30 Heart rate 80 bpm John Doe @ 2014-09-01T09:30 Cough Yes Decomposition PID Name AID Attribute 1 John Doe 1 Headache 2 Jane Doe 2 Heart rate 3 Cough Timestamp EID PID 1 1 2014-09-01T09:30 2 2 2014-09-12T12:30 3 1 2014-09-12T12:30 Mapping EID AID Value 1 1 Yes 2 2 80 bpm 1 3 Yes UBICOMM 2015 Alexander Borodin 14 / 19
Storing the attribute values VID EID AID ID VID Value 1 1 1 1 1 Yes 2 3 Yes 2 2 2 VID EID AID ValueStr ValueInt ValueBool 3 1 3 1 1 1 NULL NULL Yes ID VID Value 2 2 2 NULL 80 NULL 1 2 80 3 1 3 NULL NULL Yes UBICOMM 2015 Alexander Borodin 15 / 19
Utilization of the EAV approach in CardiaCare Service profiles of patients may be extended with arbitrary fields from contact details to billing information; clinical trials may be extended with arbitrary parameters and new types of trials may be incorporated as well; forms to be filled manually by the doctor. UBICOMM 2015 Alexander Borodin 16 / 19
Hierarchical dicationaries in CardiaCare Service dictionary dictionary_item dictionary_id dictionary_item_id dictionary_title dictionary_item_value dictionary_sortorder dictionary_item_sortkey dictionary_id dictionary_relation dictionary_relation_id dictionary_parent_id dictionary_child_id dictionary_id UBICOMM 2015 Alexander Borodin 17 / 19
Attribute metadata in CardiaCare Service attribute attribute_constraint attribute_id attribute_constraint_id attribute_title attribute_constraint_type attribute_description attribute_constraint_value attribute_sortkey attribute_id attribute_parent_id dictionary_id attribute_group entity_id attribute_group_id attribute_group_id attribute_group_name attribute_group_parent_id attribute_presentation attribute_presentation_id attribute_presentation_name attribute_presentation_value attribute_id UBICOMM 2015 Alexander Borodin 18 / 19
Conclusion Data model for CardiaCare service was conducted based on open schema design principles. This approach allows to extend a set of supported medical measurements without the need of making changes to the database schema. The schema was designed taking into account a possibility of automatic user and interface construction based on metadata. UBICOMM 2015 Alexander Borodin 19 / 19
Recommend
More recommend
