An Electronic Healthcare Record Server Implemented in PostgreSQL

Austin, Tony; Sun, Shanghua; Lim, Yin Su; Nguyen, David; Lea, Nathan; Tapuria, Archana; Kalra, Dipak

doi:https://doi.org/10.1260/2040-2295.6.3.325

Journal of Healthcare Engineering

On this page

Abstract References Copyright Related Articles

Research Article | Open Access

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

An Electronic Healthcare Record Server Implemented in PostgreSQL

Tony Austin,¹Shanghua Sun,²Yin Su Lim,¹David Nguyen,²Nathan Lea,¹Archana Tapuria,¹and Dipak Kalra¹

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

“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
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
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
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
“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
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.
View at: Google Scholar
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.
View at: Google Scholar
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
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
Khushi, Matloob, “Benchmarking Database Performance for Genomic Data,” Journal of Cellular Biochemistry, vol. 116, pp. 877–883, 2015.
View at: Publisher Site | Google Scholar
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
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
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
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
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
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
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.
View at: Publisher Site | Google Scholar
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
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
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.
View at: Google Scholar
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.
View at: Google Scholar
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

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.

PDF Download Citation Order printed copies

Views

999

Downloads

2004

Citations