A clinician friendly data warehouse oriented toward narrative reports: Dr. Warehouse

Journal of Biomedical Informatics

Volumn 80, Issue , 2018, Pages 52-63

  Garcelon, Nicolas ^a,b   Neuraz, Antoine ^b,c   Salomon, Rémi ^a,c   Faour, Hassan ^a   Benoit, Vincent ^a   Delapalme, Arthur ^a   Munnich, Arnold ^a,b,c   Burgun, Anita ^b,c   Rance, Bastien ^b,d  

^a IMAGINE INSTITUTE   (France)

^b INSERM   (France)

^c HÔPITAL NECKER ENFANTS MALADES   (France)

^d HÔPITAL EUROPÉEN GEORGES POMPIDOU   (France)

Author keywords

Computational biology; Data warehouse; Electronic health records; Information storage and retrieval; Method; Rare diseases; Software; Text mining

Indexed keywords

COMPUTER SOFTWARE; DATA MINING; DIGITAL STORAGE; GRAPHICAL USER INTERFACES; HTTP; MEDICAL COMPUTING; NATURAL LANGUAGE PROCESSING SYSTEMS; OPEN SOURCE SOFTWARE; QUERY PROCESSING; SEARCH ENGINES;

COMPUTATIONAL BIOLOGY; ELECTRONIC HEALTH RECORD; INFORMATION STORAGE AND RETRIEVAL; METHOD; RARE DISEASE; TEXT MINING;

DATA WAREHOUSES;

ACCESS TO INFORMATION; ARTICLE; ASSISTIVE TECHNOLOGY; CLINICAL RESEARCH; FACTUAL DATABASE; FAMILY HISTORY; HEALTH CARE PLANNING; HUMAN; MEDICAL DOCUMENTATION; MEDICAL INFORMATICS; MOLECULAR GENETICS; PEDIATRIC HOSPITAL; PHENOTYPE; PRIORITY JOURNAL; PROCESS OPTIMIZATION; TRANSLATIONAL RESEARCH; BIOLOGY; DATA MINING; DATA WAREHOUSE; ELECTRONIC HEALTH RECORD; NATURAL LANGUAGE PROCESSING; PROCEDURES; RARE DISEASE; SATISFACTION; SOFTWARE; VERBAL COMMUNICATION;

COMPUTATIONAL BIOLOGY; DATA MINING; DATA WAREHOUSING; ELECTRONIC HEALTH RECORDS; HUMANS; MEDICAL INFORMATICS; NARRATION; NATURAL LANGUAGE PROCESSING; PERSONAL SATISFACTION; RARE DISEASES; SOFTWARE;

EID: 85042945363     PISSN: 15320464     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.jbi.2018.02.019     Document Type: Article

References (57)

1. Hebbring, S.J., Rastegar-Mojarad, M., Ye, Z., Mayer, J., Jacobson, C., Lin, S., Application of clinical text data for phenome-wide association studies (PheWASs). Bioinform. Oxf. Engl., 2015, 10.1093/bioinformatics/btv076.
2. Namjou, B., Marsolo, K., Caroll, R.J., Denny, J.C., Ritchie, M.D., Verma, S.S., Lingren, T., Porollo, A., Cobb, B.L., Perry, C., Kottyan, L.C., Rothenberg, M.E., Thompson, S.D., Holm, I.A., Kohane, I.S., Harley, J.B., Phenome-wide association study (PheWAS) in EMR-linked pediatric cohorts, genetically links PLCL1 to speech language development and IL5-IL13 to Eosinophilic Esophagitis. Front. Genet., 5, 2014, 401, 10.3389/fgene.2014.00401.
3. Denny, J.C., Ritchie, M.D., Basford, M.A., Pulley, J.M., Bastarache, L., Brown-Gentry, K., Wang, D., Masys, D.R., Roden, D.M., Crawford, D.C., PheWAS: demonstrating the feasibility of a phenome-wide scan to discover gene-disease associations. Bioinform. Oxf. Engl. 26 (2010), 1205–1210, 10.1093/bioinformatics/btq126.
4. Neuraz, A., Chouchana, L., Malamut, G., Le Beller, C., Roche, D., Beaune, P., Degoulet, P., Burgun, A., Loriot, M.-A., Avillach, P., Phenome-wide association studies on a quantitative trait: application to TPMT enzyme activity and thiopurine therapy in pharmacogenomics. PLoS Comput. Biol., 9, 2013, e1003405, 10.1371/journal.pcbi.1003405.
5. Orsini, M., Travaglione, A., Capobianco, E., Warehousing re-annotated cancer genes for biomarker meta-analysis. Comput. Methods Prog. Biomed. 111 (2013), 166–180, 10.1016/j.cmpb.2013.03.010.
6. Chen, E.S., Sarkar, I.N., Mining the electronic health record for disease knowledge. Methods Mol. Biol. Clifton NJ 1159 (2014), 269–286, 10.1007/978-1-4939-0709-0_15.
7. Krasowski, M.D., Schriever, A., Mathur, G., Blau, J.L., Stauffer, S.L., Ford, B.A., Use of a data warehouse at an academic medical center for clinical pathology quality improvement, education, and research. J. Pathol. Inform., 6, 2015, 45, 10.4103/2153-3539.161615.
8. Shivade, C., Raghavan, P., Fosler-Lussier, E., Embi, P.J., Elhadad, N., Johnson, S.B., Lai, A.M., A review of approaches to identifying patient phenotype cohorts using electronic health records. J. Am. Med. Inform. Assoc. JAMIA 21 (2014), 221–230, 10.1136/amiajnl-2013-001935.
9. Odgers, D.J., Dumontier, M., Mining electronic health records using linked data. AMIA Jt. Summits Transl. Sci. Proc. AMIA Summit Transl. Sci. 2015 (2015), 217–221.
10. Cao, H., Markatou, M., Melton, G.B., Chiang, M.F., Hripcsak, G., Mining a clinical data warehouse to discover disease-finding associations using co-occurrence statistics. AMIA. Annu. Symp. Proc. 2005 (2005), 106–110.
11. Raghavan, P., Chen, J.L., Fosler-Lussier, E., Lai, A.M., How essential are unstructured clinical narratives and information fusion to clinical trial recruitment?. AMIA Jt. Summits Transl. Sci. Proc. AMIA Summit Transl. 2014 (2014), 218–223.
12. Hanauer, D.A., Mei, Q., Law, J., Khanna, R., Zheng, K., Supporting information retrieval from electronic health records: a report of University of Michigan's nine-year experience in developing and using the Electronic Medical Record Search Engine (EMERSE). J. Biomed. Inform. 55 (2015), 290–300, 10.1016/j.jbi.2015.05.003.
13. Charon, R., At the membranes of care: stories in narrative medicine. Acad. Med. J. Assoc. Am. Med. Coll. 87 (2012), 342–347, 10.1097/ACM.0b013e3182446fbb.
14. Groß A., Pruski, C., Rahm, E., Evolution of biomedical ontologies and mappings: Overview of recent approaches. Comput. Struct. Biotechnol. J. 14 (2016), 333–340, 10.1016/j.csbj.2016.08.002.
15. Rosenbloom, S.T., Denny, J.C., Xu, H., Lorenzi, N., Stead, W.W., Johnson, K.B., Data from clinical notes: a perspective on the tension between structure and flexible documentation. J. Am. Med. Inform. Assoc. JAMIA 18 (2011), 181–186, 10.1136/jamia.2010.007237.
16. S.N. Murphy, M.E. Mendis, D.A. Berkowitz, I. Kohane, H.C. Chueh, Integration of clinical and genetic data in the i2b2 architecture, in: AMIA Annu Symp. Proc. AMIA Symp. AMIA Symp. 2006, 2006, pp. 1040.
17. Murphy, S.N., Weber, G., Mendis, M., Gainer, V., Chueh, H.C., Churchill, S., Kohane, I., Serving the enterprise and beyond with informatics for integrating biology and the bedside (i2b2). J. Am. Med. Inform. Assoc. JAMIA 17 (2010), 124–130, 10.1136/jamia.2009.000893.
18. Observational Health Data Sciences and Informatics. Analytic tools, (n.d.). < https://www.ohdsi.org/analytic-tools/> (Accessed August 12, 2017).
19. Hripcsak, G., Duke, J.D., Shah, N.H., Reich, C.G., Huser, V., Schuemie, M.J., Suchard, M.A., Park, R.W., Wong, I.C.K., Rijnbeek, P.R., van der Lei, J., Pratt, N., Norén, G.N., Li, Y.-C., Stang, P.E., Madigan, D., Ryan, P.B., Observational Health Data Sciences and Informatics (OHDSI): opportunities for observational researchers. Stud. Health Technol. Inform. 216 (2015), 574–578.
20. H.J. Lowe, T.A. Ferris, P.M. Hernandez, S.C. Weber, STRIDE – an integrated standards-based translational research informatics platform, in: AMIA Annu Symp. Proc. AMIA Symp. AMIA Symp. 2009, 2009, pp. 391–395.
21. Danciu, I., Cowan, J.D., Basford, M., Wang, X., Saip, A., Osgood, S., Shirey-Rice, J., Kirby, J., Harris, P.A., Secondary use of clinical data: the Vanderbilt approach. J. Biomed. Inform. 52 (2014), 28–35, 10.1016/j.jbi.2014.02.003.
22. Chute, C.G., Beck, S.A., Fisk, T.B., Mohr, D.N., The enterprise data trust at mayo clinic: a semantically integrated warehouse of biomedical data. J. Am. Med. Inform. Assoc. 17 (2010), 131–135, 10.1136/jamia.2009.002691.
23. Rubin, D.L., Desser, T.S., A data warehouse for integrating radiologic and pathologic data. J. Am. Coll. Radiol. JACR 5 (2008), 210–217, 10.1016/j.jacr.2007.09.004.
24. Hu, H., Correll, M., Kvecher, L., Osmond, M., Clark, J., Bekhash, A., Schwab, G., Gao, D., Gao, J., Kubatin, V., Shriver, C.D., Hooke, J.A., Maxwell, L.G., Kovatich, A.J., Sheldon, J.G., Liebman, M.N., Mural, R.J., DW4TR: A Data Warehouse for translational research. J. Biomed. Inform. 44 (2011), 1004–1019, 10.1016/j.jbi.2011.08.003.
25. Puppala, M., He, T., Chen, S., Ogunti, R., Yu, X., Li, F., Jackson, R., Wong, S.T.C., METEOR: an enterprise health informatics environment to support evidence-based medicine. IEEE Trans. Biomed. Eng. 62 (2015), 2776–2786, 10.1109/TBME.2015.2450181.
26. Heudel, P., Livartowski, A., Arveux, P., Willm, E., Jamain, C., The ConSoRe project supports the implementation of big data in oncology. Bull. Cancer (Paris) 103 (2016), 949–950, 10.1016/j.bulcan.2016.10.001.
27. Kortüm, K.U., Müller, M., Kern, C., Babenko, A., Mayer, W.J., Kampik, A., Kreutzer, T.C., Priglinger, S., Hirneiss, C., Using electronic health records to build an ophthalmological data warehouse and visualize patients’ data. Am. J. Ophthalmol., 2017, 10.1016/j.ajo.2017.03.026.
28. D.A. Hanauer, EMERSE: the electronic medical record search engine, in: AMIA Annu. Symp. Proc. 2006, 2006, pp. 941.
29. Frankovich, J., Longhurst, C.A., Sutherland, S.M., Evidence-based medicine in the EMR era. N. Engl. J. Med. 365 (2011), 1758–1759, 10.1056/NEJMp1108726.
30. Garcelon, N., Neuraz, A., Benoit, V., Salomon, R., Burgun, A., Improving a full-text search engine: the importance of negation detection and family history context to identify cases in a biomedical data warehouse. J. Am. Med. Inform. Assoc. JAMIA, 2016, 10.1093/jamia/ocw144.
31. Oracle Text, n.d. < http://www.oracle.com/technetwork/testcontent/index-098492.html> (Accessed April 6, 2017).
32. Observations» Informatics for Integrating Biology & the Bedside (i2b2) | Boston University, n.d. < http://www.bu.edu/i2b2/mhdr/mhdr-data/observation_fact/> (Accessed August 29, 2017).
33. Lindberg, D.A., Humphreys, B.L., McCray, A.T., The unified medical language system. Methods Inf. Med. 32 (1993), 281–291.
34. Wu, S.T., Liu, H., Li, D., Tao, C., Musen, M.A., Chute, C.G., Shah, N.H., Unified Medical Language System term occurrences in clinical notes: a large-scale corpus analysis. J. Am. Med. Inform. Assoc. JAMIA 19 (2012), e149–e156, 10.1136/amiajnl-2011-000744.
35. Groza, T., Verspoor, K., Assessing the impact of case sensitivity and term information gain on biomedical concept recognition. PLoS ONE, 10, 2015, 10.1371/journal.pone.0119091.
36. Shin, S.K., Sanders, G.L., Denormalization strategies for data retrieval from data warehouses. Decis. Support Syst. 42 (2006), 267–282, 10.1016/j.dss.2004.12.004.
37. B.T. McInnes, T. Pedersen, S.V.S. Pakhomov, UMLS-interface and UMLS-similarity : open source software for measuring paths and semantic similarity, in: AMIA. Annu. Symp. Proc. 2009, 2009, pp. 431–435.
38. Graphviz | Graphviz - Graph Visualization Software, n.d. < http://www.graphviz.org/> (Accessed September 16, 2017).
39. Jones, K.S., A statistical interpretation of term specificity and its application in retrieval. J. Doc. 28 (1972), 11–21.
40. SIMILE Widgets | Timeline, n.d. < http://simile-widgets.org/timeline/> (Accessed September 16, 2017).
41. Garcelon, N., Neuraz, A., Benoit, V., Salomon, R., Kracker, S., Suarez, F., Bahi-Buisson, N., Hadj-Rabia, S., Fischer, A., Munnich, A., Burgun, A., Finding patients using similarity measures in a rare diseases-oriented clinical data warehouse: Dr. Warehouse and the needle in the needle stack. J. Biomed Inform. 73 (2017), 51–61, 10.1016/j.jbi.2017.07.016.
42. Introducing the Necker-Enfants Malades hospital, Hôp. Necker-Enfants Mal., 2015. < http://hopital-necker.aphp.fr/introducing-necker-enfants-malades-hospital/> (Accessed September 20, 2017).
43. Savova, G.K., Masanz, J.J., Ogren, P.V., Zheng, J., Sohn, S., Kipper-Schuler, K.C., Chute, C.G., Mayo clinical Text Analysis and Knowledge Extraction System (cTAKES): architecture, component evaluation and applications. J. Am. Med. Inform. Assoc. JAMIA 17 (2010), 507–513, 10.1136/jamia.2009.001560.
44. G. Divita, Q.T. Zeng, A.V. Gundlapalli, S. Duvall, J. Nebeker, M.H. Samore, Sophia: a expedient UMLS concept extraction annotator, in: AMIA Annu. Symp. Proc. 2014, 2014, pp. 467–476.
45. A.R. Aronson, Effective mapping of biomedical text to the UMLS Metathesaurus: the MetaMap program, in: Proc. AMIA Symp., 2001, pp. 17.
46. Chapman, W.W., Hillert, D., Velupillai, S., Kvist, M., Skeppstedt, M., Chapman, B.E., Conway, M., Tharp, M., Mowery, D.L., Deleger, L., Extending the NegEx lexicon for multiple languages. Stud. Health Technol. Inform. 192 (2013), 677–681.
47. Xu, H., Stenner, S.P., Doan, S., Johnson, K.B., Waitman, L.R., Denny, J.C., MedEx: a medication information extraction system for clinical narratives. J. Am. Med. Inform. Assoc. 17 (2010), 19–24, 10.1197/jamia.M3378.
48. Velupillai, S., Mowery, D., South, B.R., Kvist, M., Dalianis, H., Recent advances in clinical natural language processing in support of semantic analysis. Yearb. Med. Inform. 10 (2015), 183–193, 10.15265/IY-2015-009.
49. A. Névéol, C. Grouin, J. Leixa, S. Rosset, P. Zweigenbaum, The Quaero French medical corpus: a ressource for medical entity recognition and normalization, in: Proc BioTextM Reyk, 2014.
50. Kors, J.A., Clematide, S., Akhondi, S.A., van Mulligen, E.M., Rebholz-Schuhmann, D., A multilingual gold-standard corpus for biomedical concept recognition: the Mantra GSC. J. Am. Med. Inform. Assoc. JAMIA 22 (2015), 948–956, 10.1093/jamia/ocv037.
51. Campillos, L., Deléger, L., Grouin, C., Hamon, T., Ligozat, A.-L., Névéol, A., A French clinical corpus with comprehensive semantic annotations: development of the Medical Entity and Relation LIMSI annOtated Text corpus (MERLOT). Lang. Resour. Eval., 2017, 1–31, 10.1007/s10579-017-9382-y.
52. Jannot, A.-S., Zapletal, E., Avillach, P., Mamzer, M.-F., Burgun, A., Degoulet, P., The georges pompidou university hospital clinical data warehouse: a 8-years follow-up experience. Int. J. Med. Inf. 102 (2017), 21–28, 10.1016/j.ijmedinf.2017.02.006.
53. Hripcsak, G., Albers, D.J., Next-generation phenotyping of electronic health records. J. Am. Med. Inform. Assoc. JAMIA 20 (2013), 117–121, 10.1136/amiajnl-2012-001145.
54. Denny, J.C., Chapter 13: mining electronic health records in the genomics era. PLoS Comput. Biol., 8, 2012, 10.1371/journal.pcbi.1002823.
55. Canuel, V., Rance, B., Avillach, P., Degoulet, P., Burgun, A., Translational research platforms integrating clinical and omics data: a review of publicly available solutions. Brief. Bioinform. 16 (2015), 280–290, 10.1093/bib/bbu006.
56. Grande, D., Mitra, N., Shah, A., Wan, F., Asch, D.A., Public preferences about secondary uses of electronic health information. JAMA Int. Med. 173 (2013), 1798–1806, 10.1001/jamainternmed.2013.9166.
57. Spencer, K., Sanders, C., Whitley, E.A., Lund, D., Kaye, J., Dixon, W.G., Patient perspectives on sharing anonymized personal health data using a digital system for dynamic consent and research feedback: a qualitative study. J. Med. Internet Res., 18, 2016, e66, 10.2196/jmir.5011.