Research Article | Open Access
An Electronic Healthcare Record Server Implemented in PostgreSQL
This paper describes the implementation of an Electronic Healthcare Record server inside a PostgreSQL relational database without dependency on any further middleware infrastructure. The five-part international standard for communicating healthcare records (ISO EN 13606) is used as the information basis for the design of the server. We describe some of the features that this standard demands that are provided by the server, and other areas where assumptions about the durability of communications or the presence of middleware lead to a poor fit. Finally, we discuss the use of the server in two real-world scenarios including a commercial application.
- “The GEHR final architecture description,” in The good European health record project: deliverable, D. Lloyd, D. Kalra, T. Beale et al., Eds., vol. 19, p. 250, European Commission, Brussels, 1995, Accessed January 2015, https://www.ucl.ac.uk/chime/research/gehr/deliverable-19.pdf.
- J. Grimson, W. Grimson, D. Berry et al., “A CORBA-based integration of distributed electronic healthcare records using the synapses approach,” IEEE Trans. Inf. Technol. Biomed, vol. 2, no. 3, pp. 124–138, 1998.
- T. Austin, “The Development and Comparative Evaluation of Middleware and Database Architectures for the Implementation of an Electronic Healthcare Record,” in CHIME, D. Ingram, Ed., UCL, London, 2004.
- J. Grimson, W. Grimson, D. Berry et al., “A CORBA-based integration of distributed electronic healthcare records using the synapses approach,” IEEE Trans Inf Technol Biomed, vol. 2, no. 3, pp. 124–138, 1998.
- “Introducing computer based patient records: prerequisites and requirements,” Swedish Institute for Health Services Development (SPRI), Sweden, 1998, Report number 477, ISSN 0586-1691.
- D. Kalra, Clinical Foundations and Information Architecture for the Implementation of a Federated Health Record Service. PhD Thesis. University of London, 2002, Accessed January 2015.http://discovery.ucl.ac.uk/1584/.
- ISO, 18308: 2011 Health informatics Requirements for an electronic health record architecture.
- P. Hurlen, Ed., ENV, 12265: 1995. Electronic Healthcare Record Architecture, 1995. Brussels CEN Technical Committee/251.
- S. Kay and T. Marley, EHCR Communications: Part 1 Electronic Healthcare Record Architecture. ENV, 13606. CEN, Brussels, 1999.
- T. Austin, Y. S. Lim, D. Nguyen, and D. Kalra, “Design of an Electronic Healthcare Record Server Based on Part 1 of ISO EN, 13606,” Journal of Healthcare Engineering, vol. 2, pp. 143–160, 2011, Accessed January 2015, http://multiscience.metapress.com/content/121507.
- ISO, BS ISO EN, 13606 part 1 (No. EN, 13606) (Kalra D & Lloyd D Eds.), vol. 1, 1-103, 2007.
- ISO, BS ISO/IEC, 19770 part 2 (No. 19770), vol. 2, 1-112, 2009.
- ISO, BS ISO EN, 13606 part 3 (No. EN, 13606) (Kalra D & Lloyd D Eds.), vol. 3, 1-47, 2008.
- ISO, ISO EN, 13606 part 4 (No. EN, 13606) (Kalra D & Lloyd D Eds.), vol. 4, 1-52, 2009.
- ISO, BS ISO EN, 13606 part 5 (No. EN, 13606) (Kalra D & Lloyd D Eds.), vol. 5, 1-21, 2010.
- “PostgreSQL Consortium. History,” Accessed January 2015, http://www.postgresql.org/about/history.
- Y. Havinga, W. Dijkstra, and A. de Keijzer, “Adding HL7 version 3 data types to PostgreSQL,” 2010, Accessed February 2015, http://arxiv.org/abs/1003.3370v117.
- S. Sun, T. Austin, and D. Kalra, “A Data Types Profile Suitable for Use with ISO EN, 13606,” Journal of Medical Systems, vol. 36, no. 6, pp. 3621–3635, 2012.
- Khushi, Matloob, “Benchmarking Database Performance for Genomic Data,” Journal of Cellular Biochemistry, vol. 116, pp. 877–883, 2015.
- M. Z. Ercan and M. Lane, “Evaluation of NoSQL databases for EHR systems,” in 25th Australasian Conference on Information Systems, Auckland, New Zealand, 8th-10th December 2014, Accessed February 2015, http://aut.researchgateway.ac.nz/bitstream/handle/10292/8134/acis20140_submission_117.pdf?sequence=1.
- Centre for Health Informatics Multiprofessional Education, “Latest ISO EN, 13606 Reference Schema,” Accessed February 2015, http://www.ehr.chime.ucl.ac.uk/code/schema_3.0.4/.
- S. Kobayashi, D. Bosca, N. Kume, and H. Yoshihara, “Reforming MML, (Medical Markup Language) Standard with Archetype Technology,” in Official Organ of Indian Journal of Medial Informatics, A. Basu, Ed., vol. 8, ISSN, 0973-0379, pp. 57–60, 2014.
- D. Kalra, A. Tapuria, T. Austin, and G. de Moor, “Quality requirements for EHR Archetypes,” in Quality of Life through Quality of Information - Proceedings of MIE2012, J. Mantas, S. K. Andersen, M. C. Mazzoleni, B. Blobel, S. Quaglini, and A. Moen, Eds., vol. 180, pp. 48–52, Pisa, Italy, 2012.
- H. van der Linden, T. Austin, and J. Talmon, “Generic screen representations for future-proof systems, is it possible? There is more to a GUI than meets the eye,” Comput Methods Programs Biomed, vol. 95, pp. 213–226.
- R. Sánchez-de-Madariaga, A. Muoz, J. Caceres, R. Somolinos, M. Pascual, I. Martínez et al., “ccML, a new mark-up language to improve ISO/EN, 13606-based electronic health record extracts practical edition,” Journal of the American Medical Informatics Association, pp. 1–7, 2012, Accessed January 2015 http://jamia.oxfordjournals.org/content/20/2/298.
- Rajiv Mordani, Ed., Common Annotations for the Java Platform, April 19, 2006, Accessed March 2015, http://download.oracle.com/otn-pub/jcp/caj-1.0-fr-eval-oth-JSpec/com_annotations-1_0-fr-spec.pdf.
- R. Lozano-Rub, X. Pastor, and E. Lozano, “OWLing Clinical Data Repositories With the Ontology Web Language,” JMIR Med Inform, vol. 2, no. 2, Article ID e14, 2014, Accessed January 2015, http://www.postgresql.org/docs/9.2/static/auth-pg-hba-conf.html.
- C. Safran, D. Rind, M. Citroen, A. R. Bakker, W. V. Slack, and H. L. Bleich, “Protection of confidentiality in the computer-based patient record,” MD Computing, vol. 12, no. 3, pp. 187–192, May-Jun 1995.
- T. Austin, D. Kalra, N. Lea, D. Patterson, and D. Ingram, “Analysis of Clinical Record Data for Anticoagulation Management within an EHR System,” The Open Medical Informatics Journal, vol. 3, pp. 56–64, 2009.
- Directive 98/79/EC In vitro diagnostic medical devices. 27 October 1998.
- B. Vadher, D. L. H. Patterson, and M. S. Leaning, “Evaluation of a decision support system for initiation and control of oral anticoagulation in a randomised trial,” BMJ, vol. 314, pp. 1252–1256, 1997.
- T. Beale and S. Heard, Eds., OpenEHR Architecture - Architecture Overview, revision 1. 1. 1. 13 November 2008, Accessed March 2015, http://www.openehr.org/releases/1.0.2/architecture/overview.pdf.
- “Health Level Seven International. A basic overview of CDA,” Accessed March 2015, http://www.hl7.org.uk/repository/uploads/565/1/A%20basic%20view%20of%20CDA%20v3.doc.
- J. Calvillo-Arbizu, I. Romn-Martnez, and L. M. Roa-Romero, “Standardized access control mechanisms for protecting ISO, 13606-based electronic health record systems,” in IEEE-EMBS International Conference on Biomedical and Health Informatics (BHI), pp. 539–542, IEEE, Valencia, Spain, 1-4 June 2014.
Copyright © 2015 Hindawi Publishing Corporation. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.