Download PDF
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)

    Permissions and Reprints

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.

Keywords

Medical order entry systems - hospital information systems - evidence-based medicine - standards - clinical research
 

  • References

  • 1 Bakker AR. The development of an integrated and co-operative hospital information system. Med Inform (Lond) 1984; 9 (02) 135-142.
    PubMedSearch in Google Scholar
  • 2 Safran C, Slack WV, Bleich HL. Role of computing in patient care in two hospitals. MD Comput 1989; 6 (03) 141-148.
    PubMedSearch in Google Scholar
  • 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.
    PubMedSearch in Google Scholar
  • 4 Rector AL, Nowlan WA, Kay S. Foundations for an Electronic Medical Record. Methods Inf Med 1991; 30: 179-186.
    Thieme ConnectPubMedSearch in Google Scholar
  • 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.
    CrossrefPubMedSearch in Google Scholar
  • 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.
    PubMedSearch in Google Scholar
  • 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.
    CrossrefPubMedSearch in Google Scholar
  • 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.
    CrossrefPubMedSearch in Google Scholar
  • 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.
    CrossrefPubMedSearch in Google Scholar
  • 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
    PubMedSearch in Google Scholar
  • 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.
    CrossrefPubMedSearch in Google Scholar
  • 12 Gorman PN, Lavelle MB, Ash JS. Order Creation and Communication in Healthcare. Methods Inf Med 2003; 42 (04) 376-385.
    Thieme ConnectPubMedSearch in Google Scholar
  • 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.
    Thieme ConnectPubMedSearch in Google Scholar
  • 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).
    PubMed
  • 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
    Search in Google Scholar
  • 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.
    PubMedSearch in Google Scholar
  • 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.
    Search in Google Scholar
  • 18 Young D. CPOE reduces number of steps in medication- use process. Am J Health Syst Pharm 2001; 58 (13) 1170-1173.
    PubMedSearch in Google Scholar
  • 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.
    PubMedSearch in Google Scholar
  • 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.
    PubMedSearch in Google Scholar
  • 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.
    PubMedSearch in Google Scholar
  • 22 http://www.hama-med.ac.jp/index_e.html (accessed 27 06 2008).
    PubMed
  • 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.
    CrossrefPubMedSearch in Google Scholar
  • 24 Health Level Seven,. Inc. Standards available at: http://www.hl7.org (accessed 27 06 008).
    PubMed
  • 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.
    CrossrefPubMedSearch in Google Scholar
  • 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.
    CrossrefPubMedSearch in Google Scholar
  • 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.
    PubMedSearch in Google Scholar
  • 28 Schachter M. Chemical, pharmacokinetic and pharmacodynamic properties of statins: an update. Fundam Clin Pharmacol 2005; 19 (01) 117-125.
    CrossrefPubMedSearch in Google Scholar
  • 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.
    CrossrefPubMedSearch in Google Scholar
  • 30 Barnett GO, Souder DE, Bowie JK, Justice NS. MUMPS – a support for medical information systems. Med Inform 1976; 1: 183-189.
    PubMedSearch in Google Scholar
  • 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.
    CrossrefPubMedSearch in Google Scholar
  • 32 Cache and XML based Data Exchange Standards. http://www.intersystems.com/cache/whitepapers/xml_standards.html, 2007 (accessed 27 06 2008).
    PubMed
  • 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.
    CrossrefPubMedSearch in Google Scholar
  • 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.
    CrossrefPubMedSearch in Google Scholar