Journal of Healthcare Engineering

Journal of Healthcare Engineering / 2015 / Article

Research Article | Open Access

Volume 6 |Article ID 342108 | 20 pages | https://doi.org/10.1260/2040-2295.6.3.325

An Electronic Healthcare Record Server Implemented in PostgreSQL

Received01 Feb 2015
Accepted01 Jun 2015

Abstract

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.

References

  1. “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. View at: Google Scholar
  2. 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. View at: Google Scholar
  3. 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. View at: Google Scholar
  4. 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. View at: Google Scholar
  5. “Introducing computer based patient records: prerequisites and requirements,” Swedish Institute for Health Services Development (SPRI), Sweden, 1998, Report number 477, ISSN 0586-1691. View at: Google Scholar
  6. 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/.
  7. ISO, 18308: 2011 Health informatics Requirements for an electronic health record architecture.
  8. P. Hurlen, Ed., ENV, 12265: 1995. Electronic Healthcare Record Architecture, 1995. Brussels CEN Technical Committee/251.
  9. S. Kay and T. Marley, EHCR Communications: Part 1 Electronic Healthcare Record Architecture. ENV, 13606. CEN, Brussels, 1999.
  10. 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. View at: Google Scholar
  11. ISO, BS ISO EN, 13606 part 1 (No. EN, 13606) (Kalra D & Lloyd D Eds.), vol. 1, 1-103, 2007.
  12. ISO, BS ISO/IEC, 19770 part 2 (No. 19770), vol. 2, 1-112, 2009.
  13. ISO, BS ISO EN, 13606 part 3 (No. EN, 13606) (Kalra D & Lloyd D Eds.), vol. 3, 1-47, 2008.
  14. ISO, ISO EN, 13606 part 4 (No. EN, 13606) (Kalra D & Lloyd D Eds.), vol. 4, 1-52, 2009.
  15. ISO, BS ISO EN, 13606 part 5 (No. EN, 13606) (Kalra D & Lloyd D Eds.), vol. 5, 1-21, 2010.
  16. “PostgreSQL Consortium. History,” Accessed January 2015, http://www.postgresql.org/about/history. View at: Google Scholar
  17. 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. View at: Google Scholar
  18. 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. View at: Publisher Site | Google Scholar
  19. Khushi, Matloob, “Benchmarking Database Performance for Genomic Data,” Journal of Cellular Biochemistry, vol. 116, pp. 877–883, 2015. View at: Publisher Site | Google Scholar
  20. 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. View at: Google Scholar
  21. 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/. View at: Google Scholar
  22. 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. View at: Google Scholar
  23. 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. View at: Google Scholar
  24. 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. View at: Google Scholar
  25. 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. View at: Google Scholar
  26. 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.
  27. 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. View at: Publisher Site | Google Scholar
  28. 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. View at: Google Scholar
  29. 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. View at: Google Scholar
  30. Directive 98/79/EC In vitro diagnostic medical devices. 27 October 1998.
  31. 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. View at: Google Scholar
  32. 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.
  33. “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. View at: Google Scholar
  34. 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. View at: Publisher Site | Google Scholar

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.

404 Views | 1150 Downloads | 6 Citations
 PDF  Download Citation  Citation
 Order printed copiesOrder

We are committed to sharing findings related to COVID-19 as quickly and safely as possible. Any author submitting a COVID-19 paper should notify us at help@hindawi.com to ensure their research is fast-tracked and made available on a preprint server as soon as possible. We will be providing unlimited waivers of publication charges for accepted articles related to COVID-19.