Methods Inf Med 2008; 47(06): 560-568
DOI: 10.3414/ME9125
Original Article
Schattauer GmbH

High Speed Clinical Data Retrieval System with Event Time Sequence Feature

With 10 Years of Clinical Data of Hamamatsu University Hospital CPOE
M. Kimura
1   Hamamatsu University, School of Medicine, Hamamatsu, Japan
,
S. Tani
1   Hamamatsu University, School of Medicine, Hamamatsu, Japan
,
H. Watanabe
1   Hamamatsu University, School of Medicine, Hamamatsu, Japan
,
Y. Naito
1   Hamamatsu University, School of Medicine, Hamamatsu, Japan
,
T. Sakusabe
2   Fujita Health University, School of Health Sciences, Toyoake, Japan
,
H. Watanabe
3   The University of Tokyo, Dept. of Planning, Information and Management, Tokyo, Japan
,
J. Nakaya
4   Tokyo Medical and Dental University, Information Center for Medical Sciences, Tokyo, Japan
,
F. Sasaki
5   NEC Corporation, Tokyo, Japan
,
T. Numano
6   NTT Data Tokai Corporation, Nagoya, Japan
,
T. Furuta
6   NTT Data Tokai Corporation, Nagoya, Japan
,
T. Furuta
1   Hamamatsu University, School of Medicine, Hamamatsu, Japan
› Author Affiliations
Further Information

Publication History

Publication Date:
18 January 2018 (online)

Summary

Objectives: This paper illustrates a high speed clinical data retrieving system, from 10 years of data of operating hospital information system for the purposes of research, evidence creation, patient safety, etc., even incorporating time sequence of causal relations.

Methods: Total of 73,709,298 records of 10 years at Hamamatsu University Hospital (as of June 2008) are sent from HIS to retrieval system in HL7 v2.5 format. Hierarchical variable length database is used to install them.

Results: A search for “listing patients who were prescribed Pravastatin (Mevalotin and generic drugs, any titer)” took 1.92 seconds. “Pravastatin (any) prescribed and recorded AST >150 within two weeks” took 112.22 seconds. Searching conditions can be set to be more complex, connected by Boolean operator and/or. This system called D*D is in operation at Hamamatsu University Hospital since August 2002. It is used for 48,518 times (monthly average of 703 searches). Neither searching, nor background export of data from HIS caused delay of routine operating CPOE.

Conclusions: Search database outside of routine operating CPOE, with daily export of order data in HL7 v2.5 format, is proved to provide excellent search environment without causing trouble. Hierarchical representation gives high-speed search response, especially with time sequence of events.

 
  • References

  • 1 Bakker AR. The development of an integrated and co-operative hospital information system. Med Inform (Lond) 1984; 9 (02) 135-142.
  • 2 Safran C, Slack WV, Bleich HL. Role of computing in patient care in two hospitals. MD Comput 1989; 6 (03) 141-148.
  • 3 McDonald CJ, Tierney WM, Overhage JM, Markin DK, Wilson GA. The Regenstrief Medical Record System: 20 years of experience in hospitals, clinics, and neighbourhood health centers. MD Comput 1992; 9: 206-217.
  • 4 Rector AL, Nowlan WA, Kay S. Foundations for an Electronic Medical Record. Methods Inf Med 1991; 30: 179-186.
  • 5 Ohe K, Kaihara S. Implementation of HL7 to client-server hospital information system (HIS) in the University of Tokyo Hospital. J Med Syst 1996; 20 (04) 197-205.
  • 6 Kuperman GJ, Teich JM, Gandhi TK, Bates DW. Patient safety and computerized medication ordering at Brigham and Women's Hospital. Jt Comm J Qual Improv 2001; 27 (10) 509-521.
  • 7 Kaushal R, Shojania KG, Bates DW. Effects of computerized physician order entry and clinical decision support systems on medication safety: a systematic review. Arch Intern Med 2003; 163 (12) 1409-1416.
  • 8 Koppel R, Metlay JP, Cohen A, Abaluck B, Localio AR, Kimmel SE, Strom BL. Role of computerized physician order entry systems in facilitating medication errors. JAMA 2005; 293 (10) 1197-1203.
  • 9 Horsky J, Kuperman GJ, Patel VL. Comprehensive analysis of a medication dosing error related to CPOE. J Am Med Inform Assoc 2005; 12 (04) 377-382.
  • 10 Sowan AK, Mohamed G, Soeken K, Mills ME, Johantgen M, Vaidya V. A comparison of medication administration errors using CPOE orders vs. handwritten orders for pediatric continuous drug infusions. AMIA Annu Symp Proc 2006. p 1105
  • 11 Eslami S, de Keizer NF, Abu-Hanna A. The impact of computerized physician medication order entry in hospitalized patients – a systematic review. Int J Med Inform 2008; 77 (06) 365-376.
  • 12 Gorman PN, Lavelle MB, Ash JS. Order Creation and Communication in Healthcare. Methods Inf Med 2003; 42 (04) 376-385.
  • 13 Aarts J, Berg M. Same Systems, Different Outcomes – Comparing the Implementation of Computerized Physician Order Entry in Two Dutch Hospitals. Methods Inf Med 2006; 45 (01) 53-61.
  • 14 Japan Association of Healthcare Information Systems Industry, JAHIS NEWS vol.14, 2006. http://www.jahis.jp/en/activity/news.html (in Japanese) (accessed 27 06 2008).
  • 15 Kimura M, Miyamoto M, Akiyama M, Toyoda K. What We Obtained and What Were the Real Barriers of CPOE and EHR – Lessons Learned From CPOE and RHIO in Japan. Workshop 09, AMIA 2006: 32, Washington DC; USA: November 11 2006
  • 16 Sittig DF, Guappone K, Campbell EM, Dykstra RH, Ash JS. A survey of U.S.A. acute care hospitals’ computer-based provider order entry system infusion levels. Medinfo 2007; 12 Pt 1 252-256.
  • 17 Kimura M, Kanno T, Tani S, Satomura Y. Standardizations of clinical laboratory examinations in Japan. Int J Med Inform 1998; 48 1-3 239-246.
  • 18 Young D. CPOE reduces number of steps in medication- use process. Am J Health Syst Pharm 2001; 58 (13) 1170-1173.
  • 19 Kuperman GJ, Marston E, Paterno M, Rogala J, Plaks N, Hanson C, Blumenfeld B, Middleton B, Spurr CD, Kaushal R, Gandhi TK, Bates DW. Creating an enterprise-wide allergy repository at Partners HealthCare System. AMIA Annu Symp Proc 2003; pp 376-380.
  • 20 Kimura M, Shimizu K, Tsuchiya F, Tsuchiya I, Koyama T, Kaihara S, Yashiro N, Iio M. Crosshierarchy representation of medical knowledge. Symposium on Computer Application in Medical Care 87. IEEE Computer Society Press 1987; 812: 207-212.
  • 21 Harrington JJ. IEEE (Institute of Electrical and Electronic Engineers) P1157 Medical Data Interchange (MEDIX): application of open systems to health care communications. Top Health Rec Manage 1991; 11 (04) 45-58.
  • 22 http://www.hama-med.ac.jp/index_e.html (accessed 27 06 2008).
  • 22 Kimura M, Tani S, Baatar S, Naito Y, Kanno T, Sakusabe T, Aizawa M. Implementation of multivendor DICOM standard image transfer in hospital wide ATM network. Comput Methods Programs Biomed 1998; 57 1-2 85-89.
  • 24 Health Level Seven,. Inc. Standards available at: http://www.hl7.org (accessed 27 06 008).
  • 25 Kimura M, Ohe K, Yoshihara H, Ando Y, Kawamata F, Tsuchiya F, Furukawa H, Horiguchi S, Sakusabe T, Tani S, Akiyama M. MERIT-9: a patient information exchange guideline using MML, HL7 and DICOM. Int J Med Inform 1998; 51 (01) 59-68.
  • 26 Kimura M. Role of standardization: how to achieve it, and how to cooperate, nationally and internationally?. Comput Methods Programs Biomed 1994; 43 1-2 19-20.
  • 27 Hartleb M, Biernet L, Kochel A. Drug-induced liver damage – a three-year study of patients from one gastroenterological department. Med Sci Monit 2002; 8 (04) 292-296.
  • 28 Schachter M. Chemical, pharmacokinetic and pharmacodynamic properties of statins: an update. Fundam Clin Pharmacol 2005; 19 (01) 117-125.
  • 29 Neuvonen PJ, Niemi M, Backman JT. Drug interactions with lipid-lowering drugs: mechanisms and clinical relevance. Clin Pharmacol Ther 2006; 80 (06) 565-581.
  • 30 Barnett GO, Souder DE, Bowie JK, Justice NS. MUMPS – a support for medical information systems. Med Inform 1976; 1: 183-189.
  • 31 van Ginneken AM, Smeulders AW, Jansen W, Baak JP, Brooymans I. Design of the diagnostic encyclopedia workstation (DEW). Comput Biol Med 1990; 20 (04) 281-292.
  • 32 Cache and XML based Data Exchange Standards. http://www.intersystems.com/cache/whitepapers/xml_standards.html, 2007 (accessed 27 06 2008).
  • 33 Dolin RH, Alschuler L, Boyer S, Beebe C, Behlen FM, Biron PV, Shabo Shvo A. HL7 Clinical Document Architecture, Release 2. J Am Med Inform Assoc 2006; 13 (01) 30-39.
  • 34 Ferranti JM, Musser RC, Kawamoto K, Hammond WE. The clinical document architecture and the continuity of care record: a critical analysis. J Am Med Inform Assoc 2006; 13 (03) 245-252.