Data types managed database design for dynamic content: A database design for Personal Health Book system

Electronic Health Records (EHR) are digitized and stored for efficient patient management in hospitals or clinics. At the patient side, health records are not digitally stored and thus difficult to manage across different hospitals. We propose a new system, where medical sources (firms & devices) import a person's medical records into Personal Health Book (PHB). This will give the person (the owner of the records) the capability to manage, control and share his/her own Personal Health Records (PHR). However, medical sources have different structure and database design. In this paper, we propose a decomposed database design for PHB that accommodate different structured data. We test the capability of generating a meaningful report and compare it to the original EHR received from source (Hospital). We use a framework that exports the data from PHB into an Extensible Markup Language (XML) file format, then view it using predefined Extensible Stylesheet Language (XSL). We observe that our database design can generate a report with same content of original EHR in a meaningful manner that the owner and authorized parties can understand it.