DW4TR: A Data Warehouse for Translational Research

Journal of Biomedical Informatics

Volumn 44, Issue 6, 2011, Pages 1004-1019

  Hu, Hai ^a   Correll, Mick ^c,g   Kvecher, Leonid ^a   Osmond, Michelle ^b,h   Clark, Jim ^b,h   Bekhash, Anthony ^a   Schwab, Gwendolyn ^a   Gao, De ^d,h   Gao, Jun ^d,h   Kubatin, Vladimir ^c,h   Shriver, Craig D ^e   Hooke, Jeffrey A ^e   Maxwell, Larry G ^e   Kovatich, Albert J ^f   Sheldon, Jonathan G ^b,i   Liebman, Michael N ^a,j   Mural, Richard J ^a  

^a WINDBER RESEARCH INSTITUTE   (United States)

^b InforSense LLC   (United Kingdom)

^c InforSense Ltd   (United States)

^d InforSense Ltd   (China)

^e WALTER REED ARMY MEDICAL CENTER   (United States)

^f MDR Global   (United States)

^g DANA FARBER CANCER INSTITUTE   (United States)

^h IDBS   (United States)

ⁱ NONE

^j Strategic Medicine   (United States)

more..

Author keywords

Data Warehouse; Ontology; Patient centric data model; Translational research; User interface

Indexed keywords

BREAST CANCER; CLINICAL DATA; ELECTRONIC MEDICAL RECORD; HUMAN DISEASE; INDIVIDUAL SYSTEMS; LIGHT WEIGHT; MOLECULAR DATA; NUMBER OF DATUM; RESEARCH DOMAINS; TEMPORAL RELATIONSHIPS; TRANSLATIONAL RESEARCH;

DATA STRUCTURES; DATA WAREHOUSES; MEDICAL COMPUTING; MODELS; ONTOLOGY; USER INTERFACES;

RESEARCH;

EPIDERMAL GROWTH FACTOR RECEPTOR 2; ESTROGEN RECEPTOR; PROGESTERONE RECEPTOR;

ACCESS TO INFORMATION; AGGREGATED BIOMEDICAL INFORMATION BROWSER; ARTICLE; BREAST CANCER; COMPUTER INTERFACE; COMPUTER NETWORK; COMPUTER PROGRAM; COMPUTER SECURITY; DATA BASE; DATA WAREHOUSE FOR TRANSLATIONAL RESEARCH; DIAGNOSTIC IMAGING; GYNECOLOGIC DISEASE; HUMAN; IMMUNOHISTOCHEMISTRY; INDIVIDUAL SUBJECT INFORMATION VIEWER; MEDICAL HISTORY; MEDICAL INFORMATION SYSTEM; MOLECULAR MODEL; PHYSICAL EXAMINATION; PRIORITY JOURNAL; RISK ASSESSMENT; TRANSLATIONAL RESEARCH; VIRTUAL REALITY;

ELECTRONIC HEALTH RECORDS; HUMANS; MEDICAL INFORMATICS APPLICATIONS; SOFTWARE; TRANSLATIONAL MEDICAL RESEARCH; USER-COMPUTER INTERFACE;

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

References (94)

1. Hu H., Mural R.J., Liebman M.N., Hu H., Mural R.J., Liebman M.N., et al. Biomedical informatics in translational research 2008, Artech House, Boston, London.
2. Bernstam E.V., Hersh W.R., Johnson S.B., Chute C.G., Nguyen H., Sim I., et al. Synergies and distinctions between computational disciplines in biomedical research: perspective from the Clinical and Translational Science Award programs. Acad Med 2009, 84:964-970.
3. Payne P.R., Embi P.J., Sen C.K. Translational informatics: enabling high-throughput research paradigms. Physiol Genomics 2009, 39:131-140.
4. Sarkar I.N. Biomedical informatics and translational medicine. J Transl Med 2010, 8:22.
5. Nadkarni PM, Reeders ST, Zhou J. CECIL: a database for storing and retrieving clinical and molecular information on patients with Alport syndrome. In: Proc annu symp comput appl med care; 1993. p. 649-53.
6. Hu H., Brzeski H., Hutchins J., Ramaraj M., Qu L., Xiong R., et al. Biomedical informatics: development of a comprehensive data warehouse for clinical and genomic breast cancer research. Pharmacogenomics 2004, 5:933-941.
7. Brammen D., Katzer C., Rohrig R., Weismuller K., Maier M., Hossain H., et al. An integrated data-warehouse-concept for clinical and biological information. Stud Health Technol Inform 2005, 116:9-14.
8. Murphy SN, Mendis ME, Berkowitz DA, Kohane I, Chueh HC. Integration of clinical and genetic data in the i2b2 architecture. In: AMIA annu symp proc; 2006. p. 1040.
9. Hu H, Correll M, Osmond M, Gao J, Oleynikov A, Sheldon J, et al. A clinical data warehouse to support translational research. In: 15th annual international conference on Intelligent Systems for Molecular Biology (ISMB), Vienna, Austria; July 21-25, 2007.
10. Burgun A., Bodenreider O. Accessing and integrating data and knowledge for biomedical research. Yearb Med Inform 2008, 91-101.
11. Rossille D., Burgun A., Pangault-Lorho C., Fest T. Integrating clinical, gene expression, protein expression and preanalytical data for in silico cancer research. Stud Health Technol Inform 2008, 136:455-460.
12. Hu H. Data centralization. In: Hu H, Mural RJ, Liebman MN, editors. Biomedical informatics in translational research; 2008. p. 141-71 [chapter 8].
13. Lowe HJ, Ferris TA, Hernandez PM, Weber SC. STRIDE - an integrated standards-based translational research informatics platform. In: AMIA annu symp proc; 2009. p. 391-5.
14. Inmon W.H., Kelley C. Developing the data warehouse 1993, QED Publishing Group.
15. Kimball R., Ross M. The data warehouse Toolkit 2002, John Wiley and Sons. 2nd ed.
16. Stead W.W., Hammond W.E., Straube M.J. A chartless record - is it adequate?. J Med Syst 1983, 7:103-109.
17. Niedner CD. The entity-attribute-value data model in radiology informatics. In: Proceedings of the 10th conference on computer applications in radiology, Anaheim, CA; 1990.
18. Nadkarni P.M., Brandt C. Data extraction and ad hoc query of an entity-attribute-value database. J Am Med Inform Assoc 1998, 5:511-527.
19. Codd F, Codd SB, Salley CT. Providing OLAP (Online Analytical Processing) to user-analysts: an IT mandate. San Jose: Codd & Date, Inc; 1993.
20. Rubin D.L., Shah N.H., Noy N.F. Biomedical ontologies: a functional perspective. Brief Bioinform 2008, 9:75-90.
21. Health Level 7. http://www.hl7.org/.
22. Lowe H.J., Barnett G.O. Understanding and using the medical subject headings (MeSH) vocabulary to perform literature searches. JAMA 1994, 271:1103-1108.
23. SNOMED Clinical Terms® (SNOMED CT®). http://www.nlm.nih.gov/research/umls/Snomed/snomed_main.html.
24. DICOM - Digital Imaging Communications in Medicine. http://www.medical.nema.org/.
25. Ashburner M., Ball C.A., Blake J.A., Botstein D., Butler H., Cherry J.M., et al. Gene ontology: tool for the unification of biology. The gene ontology consortium. Nat Genet 2000, 25:25-29.
26. Brazma A., Hingamp P., Quackenbush J., Sherlock G., Spellman P., Stoeckert C., et al. Minimum information about a microarray experiment (MIAME)-toward standards for microarray data. Nat Genet 2001, 29:365-371.
27. BioPAX: Biological Pathways Exchange. http://www.biopax.org/.
28. Sioutos N., de Coronado S., Haber M.W., Hartel F.W., Shaiu W.L., Wright L.W. NCI Thesaurus: a semantic model integrating cancer-related clinical and molecular information. J Biomed Inform 2007, 40:30-43.
29. Rubin D.L., Lewis S.E., Mungall C.J., Misra S., Westerfield M., Ashburner M., et al. National Center for Biomedical Ontology: advancing biomedicine through structured organization of scientific knowledge. OMICS 2006, 10:185-198.
30. Cote R.G., Jones P., Apweiler R., Hermjakob H. The Ontology Lookup Service, a lightweight cross-platform tool for controlled vocabulary queries. BMC Bioinform 2006, 7:97.
31. Lindberg D.A., Humphreys B.L., McCray A.T. The unified medical language system. Methods Inf Med 1993, 32:281-291.
32. Bard J.B., Rhee S.Y. Ontologies in biology: design, applications and future challenges. Nat Rev Genet 2004, 5:213-222.
33. Yu A.C. Methods in biomedical ontology. J Biomed Inform 2006, 39:252-266.
34. Cimino J.J., Zhu X. The practical impact of ontologies on biomedical informatics. Yearb Med Inform 2006, 124-135.
35. Weedon-Fekjaer H., Lindqvist B.H., Vatten L.J., Aalen O.O., Tretli S. Breast cancer tumor growth estimated through mammography screening data. Breast Cancer Res 2008, 10:R41.
36. Shoham Y. Reasoning about change: time and causation from the standpoint of artificial intelligence 1988, MIT Press, Cambridge, MA, USA.
37. Shahar Y. A framework for knowledge-based temporal abstraction. Art Intell 1997, 90:79-133.
38. Deshpande A.M., Brandt C., Nadkarni P.M. Temporal query of attribute-value patient data: utilizing the constraints of clinical studies. Int J Med Inform 2003, 70:59-77.
39. Ceusters W., Steurs F., Zanstra P., Van Der Haring E., Rogers J. From a time standard for medical informatics to a controlled language for health. Int J Med Inform 1998, 48:85-101.
40. Das AK, Shahar Y, Tu SW, Musen MA. A temporal-abstraction mediator for protocol-based decision-support systems. In: Proc annu symp comput appl med care; 1994. p. 320-4.
41. Shahar Y, Das AK, Tu SW, Kraemer FB, Musen MA. Knowledge-based temporal abstraction for diabetic monitoring. In: Proc annu symp comput appl med care; 1994. p. 697-701.
42. Nguyen JH, Shahar Y, Tu SW, Das AK, Musen MA. A temporal database mediator for protocol-based decision support. In: Proc AMIA annu fall symp; 1997. p. 298-302.
43. Post A.R., Harrison J.H. PROTEMPA: a method for specifying and identifying temporal sequences in retrospective data for patient selection. J Am Med Inform Assoc 2007, 14:674-683.
44. Post AR, Sovarel AN, Harrison JH, Jr. Abstraction-based temporal data retrieval for a Clinical Data Repository. In: AMIA annu symp proc; 2007. p. 603-7.
45. Chen J., Zhao P., Massaro D., Clerch L.B., Almon R.R., DuBois D.C., et al. The PEPR GeneChip data warehouse, and implementation of a dynamic time series query tool (SGQT) with graphical interface. Nucleic Acids Res 2004, 32:D578-D581.
46. Yamamoto Y., Namikawa H., Inamura K. Development of a time-oriented data warehouse based on a medical information event model. Igaku Butsuri 2002, 22:327-333.
47. Informatics for Integrating Biology and the Bedside (I2B2). http://www.i2b2.org/.
48. Mendis M, Wattanasin N, Kuttan R, Pan W, Philips L, Hackett K, et al. Integration of hive and cell software in the i2b2 architecture. In: AMIA annu symp proc; 2007. p. 1048.
49. Mendis M, Phillips LC, Kuttan R, Pan W, Gainer V, Kohane I, et al. Integrating outside modules into the i2b2 architecture. In: AMIA annu symp proc; 2008. p. 1054.
50. Uzuner O., Luo Y., Szolovits P. Evaluating the state-of-the-art in automatic de-identification. J Am Med Inform Assoc 2007, 14:550-563.
51. Barrett N., Weber-Jahnke J.H. Applying natural language processing toolkits to electronic health records - an experience report. Stud Health Technol Inform 2009, 143:441-446.
52. Deshmukh V.G., Meystre S.M., Mitchell J.A. Evaluating the informatics for integrating biology and the bedside system for clinical research. BMC Med Res Methodol 2009, 9:70.
53. Meystre SM, Deshmukh VG, Mitchell J. A clinical use case to evaluate the i2b2 Hive: predicting asthma exacerbations. In: AMIA annu symp proc; 2009. p. 442-6.
54. Murphy S.N., Weber G., Mendis M., Gainer V., Chueh H.C., Churchill S., et al. Serving the enterprise and beyond with informatics for integrating biology and the bedside (i2b2). J Am Med Inform Assoc 2010, 17:124-130.
55. The stanford translational research integrated database environment (STRIDE). http://www.clinicalinformatics.stanford.edu/STRIDE/.
56. Hernandez P., Podchiyska T., Weber S., Ferris T., Lowe H. Automated mapping of pharmacy orders from two electronic health record systems to RxNorm within the STRIDE clinical data warehouse. AMIA Annu Symp Proc 2009, 2009:244-248.
57. Lowe HJ, Huang Y, Regula DP. Using a statistical natural language parser augmented with the UMLS specialist lexicon to assign SNOMED CT codes to anatomic sites and pathologic diagnoses in full text pathology reports. In: AMIA annu symp proc; 2009 p. 386-90.
58. caIntegrator. http://www.cabig.nci.nih.gov/tools/caIntegrator.
59. Repository of Molecular Brain Neoplasia Data (REMBRANDT). http://www.caintegrator-info.nci.nih.gov/rembrandt/.
60. Cancer Genetic Markers of Susceptibility (CGEMS). http://www.cgems.cancer.gov/.
61. Clinical and Translational Science Award (CTSA, on the website of National Center for Research Resources). http://www.ncrr.nih.gov/clinical_research_resources/clinical_and_translational_science_awards.
62. The Cancer Biomedical Informatics Grid (caBIG). http://www.cabig.nci.nih.gov/.
63. von Eschenbach A.C., Buetow K.H. Cancer informatics vision: caBIGTM. Cancer Inform 2006, 2:22-24.
64. The Cancer Biomedical Informatics Grid (caBIG): infrastructure and applications for a worldwide research community. Stud Health Technol Inform 2007;129:330-4.
65. Covitz P.A., Hartel F., Schaefer C., De Coronado S., Fragoso G., Sahni H., et al. caCORE: a common infrastructure for cancer informatics. Bioinformatics 2003, 19:2404-2412.
66. Komatsoulis G.A., Warzel D.B., Hartel F.W., Shanbhag K., Chilukuri R., Fragoso G., et al. caCORE version 3: implementation of a model driven, service-oriented architecture for semantic interoperability. J Biomed Inform 2008, 41:106-123.
67. McCusker J.P., Phillips J.A., Gonzalez Beltran A., Finkelstein A., Krauthammer M. Semantic web data warehousing for caGrid. BMC Bioinform 2009, 10(Suppl. 10):S2.
68. The Clinical Breast Care Project. http://www.cbcp.info/.
69. The Gynecological Disease Program. http://www.gyndisease.org/index.html.
70. Rector A.L., Zanstra P.E., Solomon W.D., Rogers J.E., Baud R., Ceusters W., et al. Reconciling users' needs and formal requirements: issues in developing a reusable ontology for medicine. IEEE Trans Inf Technol Biomed 1998, 2:229-242.
71. Richesson R.L., Krischer J. Data standards in clinical research: gaps, overlaps, challenges and future directions. J Am Med Inform Assoc 2007, 14:687-696.
72. Mohanty S.K., Mistry A.T., Amin W., Parwani A.V., Pople A.K., Schmandt L., et al. The development and deployment of Common Data Elements for tissue banks for translational research in cancer - an emerging standard based approach for the Mesothelioma Virtual Tissue Bank. BMC Cancer 2008, 8:91.
73. Min H., Manion F.J., Goralczyk E., Wong Y.N., Ross E., Beck J.R. Integration of prostate cancer clinical data using an ontology. J Biomed Inform 2009, 42:1035-1045.
74. caBIG Vocabularies & Common Data Elements (VCDE) Workspace. http://www.cabig.nci.nih.gov/workspaces/VCDE/.
75. Brandt C.A., Cohen D.B., Shifman M.A., Miller P.L., Nadkarni P.M., Frawley S.J. Approaches and informatics tools to assist in the integration of similar clinical research questionnaires. Methods Inf Med 2004, 43:156-162.
76. Wolff A.C., Hammond M.E., Schwartz J.N., Hagerty K.L., Allred D.C., Cote R.J., et al. American Society of Clinical Oncology/College of American Pathologists guideline recommendations for human epidermal growth factor receptor 2 testing in breast cancer. Arch Pathol Lab Med 2007, 131:18-43.
77. Hammond M.E., Hayes D.F., Dowsett M., Allred D.C., Hagerty K.L., Badve S., et al. American Society of Clinical Oncology/College of American Pathologists guideline recommendations for immunohistochemical testing of estrogen and progesterone receptors in breast cancer. Arch Pathol Lab Med 2010, 134:907-922.
78. Beaulah S.A., Correll M.A., Munro R.E., Sheldon J.G. Addressing informatics challenges in Translational Research with workflow technology. Drug Discov Today 2008, 13:771-777.
79. Hu H, Kvecher L. Data tracking systems. In: Hu H, Mural RJ, Liebman MN, editors. Biomedical informatics in translational research; 2008. p. 111-36 [chapter 7].
80. Hu H, Zhang Y, Kvecher L, Sun W, Hooke J, Mural RJ, et al. Different characteristics of invasive breast cancers between Caucasian and African American women. In: The 29th San Antonio breast cancer symposium, San Antonio, TX; 14-17 December 2006.
81. Maskery S.M., Hu H., Hooke J., Shriver C.D., Liebman M.N. A Bayesian derived network of breast pathology co-occurrence. J Biomed Inform 2008, 41:242-250.
82. Bekhash A, Maskery SM, Kvecher L, Correll M, Zhang Y, Hooke J, et al. Clinical breast care project data warehouse as a research environment for breast cancer risk factor studies; submitted for publication.
83. Bekhash A, Maskery SM, Kvecher L, Hooke J, Liebman MN, Shriver CD, et al. A pilot study of known or controversial breast cancer risk factors using the Clinical Breast Care Project database as a research environment. In: The 30th San Antonio breast cancer symposium, San Antonio, TX; 13-16 December 2007.
84. Saini J., Kovatich A., Bekhash A., Hooke J., Mural R.J., Shriver C.D., et al. Association of clinicopathologic characteristics with IHC-based breast cancer subtypes. Cancer Res 2009, 69:635s.
85. Bekhash A., Saini J., Li X., Rapuri P., Hooke A.J., Mural R.J., et al. Ethnicity difference of benign breast diseases in breast cancer and non-cancer patients. Cancer Res 2010, 288s-289s.
86. Saini J., Li X., Kvecher L., Larson C., Croft D., Yang Y.C., et al. Differential gene expression analysis among post-menopausal caucasian invasive breast cancer, benign and normal subjects. Cancer Res 2010, 245s.
87. Li X, Rapuri P, Melley J, Brilhart G, Wu W, Kvecher L, et al. Comparative analysis of gene expression profiles in human breast cancer from microarray data using breast tissues and peripheral blood samples. In: International conference on intelligent systems for molecular biology (ISMB), Boston, MA; 11-13 July 2010.
88. Edge SB, Byrd DR, Compton CC, Fritz AG, Greene FL, Trotti A. AJCC cancer staging manual. 7th ed. New York, NY: Springer-Verlag; 2010 [6th printing].
89. Lester S.C., Bose S., Chen Y.Y., Connolly J.L., de Baca M.E., Fitzgibbons P.L., et al. Protocol for the examination of specimens from patients with invasive carcinoma of the breast. Arch Pathol Lab Med 2009, 133:1515-1538.
90. Lester S.C., Bose S., Chen Y.Y., Connolly J.L., de Baca M.E., Fitzgibbons P.L., et al. Protocol for the examination of specimens from patients with ductal carcinoma in situ of the breast. Arch Pathol Lab Med 2009, 133:15-25.
91. Printz C. New AJCC cancer staging manual reflects changes in cancer knowledge. Cancer 2010, 116:2-3.
92. Andrews J.E., Richesson R.L., Krischer J. Variation of SNOMED CT coding of clinical research concepts among coding experts. J Am Med Inform Assoc 2007, 14:497-506.
93. Childs L.C., Enelow R., Simonsen L., Heintzelman N.H., Kowalski K.M., Taylor R.J. Description of a rule-based system for the i2b2 challenge in natural language processing for clinical data. J Am Med Inform Assoc 2009, 16:571-575.
94. Murphy SN, Mendis M, Hackett K, Kuttan R, Pan W, Phillips LC, et al. Architecture of the open-source clinical research chart from Informatics for Integrating Biology and the Bedside. In: AMIA annu symp proc; 2007. p. 548-52.