DW4TR: A Data Warehouse for Translational Research

Hai Hu*, Mick Correll, Leonid Kvecher, Michelle Osmond, Jim Clark, Anthony Bekhash, Gwendolyn Schwab, De Gao, Jun Gao, Vladimir Kubatin, Craig D. Shriver, Jeffrey A. Hooke, Larry G. Maxwell, Albert J. Kovatich, Jonathan G. Sheldon, Michael N. Liebman, Richard J. Mural

*Corresponding author for this work

Research output: Contribution to journalArticlepeer-review

36 Scopus citations


The linkage between the clinical and laboratory research domains is a key issue in translational research. Integration of clinicopathologic data alone is a major task given the number of data elements involved. For a translational research environment, it is critical to make these data usable at the point-of-need. Individual systems have been developed to meet the needs of particular projects though the need for a generalizable system has been recognized. Increased use of Electronic Medical Record data in translational research will demand generalizing the system for integrating clinical data to support the study of a broad range of human diseases. To ultimately satisfy these needs, we have developed a system to support multiple translational research projects. This system, the Data Warehouse for Translational Research (DW4TR), is based on a light-weight, patient-centric modularly-structured clinical data model and a specimen-centric molecular data model. The temporal relationships of the data are also part of the model. The data are accessed through an interface composed of an Aggregated Biomedical-Information Browser (ABB) and an Individual Subject Information Viewer (ISIV) which target general users. The system was developed to support a breast cancer translational research program and has been extended to support a gynecological disease program. Further extensions of the DW4TR are underway. We believe that the DW4TR will play an important role in translational research across multiple disease types.

Original languageEnglish
Pages (from-to)1004-1019
Number of pages16
JournalJournal of Biomedical Informatics
Issue number6
StatePublished - Dec 2011
Externally publishedYes


  • Data Warehouse
  • Ontology
  • Patient-centric data model
  • Translational research
  • User interface


Dive into the research topics of 'DW4TR: A Data Warehouse for Translational Research'. Together they form a unique fingerprint.

Cite this