Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Data Warehousing for Clinical Research

  • Shawn MurphyEmail author
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_120


Clinical research chart


The clinical data warehouse allows rapid querying and reporting across patients. It is used to support the discovery of new relationships between the cause and effects of diseases, and to find specific patients that qualify for research studies.

Historical Background

In healthcare, the term “data warehouse” is generally reserved for those databases optimized for analysis and integrated queries across patient populations. This is as opposed to the transactional database, which is optimized for rapid updating and highly specific kinds of retrieval (like those based upon a specific patient identifier).

There appear to be three fundamentally different approaches to organizing the healthcare data warehouse. The first is to extract tables from the transaction systems of the healthcare organization and load them into the database platform of the data warehouse with minimal transformation of the data model. The codes present in the columns are...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Inmon WH. Building the data warehouse. 2nd ed. New York: Wiley; 1996.Google Scholar
  2. 2.
    Kimball R. The data warehousing toolkit. New York: Wiley; 1997.Google Scholar
  3. 3.
    Murphy SN, Gainer VS, Chueh H. A visual interface designed for novice users to find research patient cohorts in a large biomedical database. In: Proceedings of the AMIA Annual Fall Symposium; 2003.p. 489–93.Google Scholar
  4. 4.
    Murphy SN, Morgan MM, Barnett GO, Chueh HC. Optimizing healthcare research data warehouse design through past COSTAR query analysis. In: Proceedings of the AMIA Fall Symposium; 1999. p. 892–6.Google Scholar
  5. 5.
    Nadkarni PM, Brandt C. Data extraction and ad hoc query of an entity-attribute-value database. J Am Med Inform Assoc. 1998;5(6):511–7.CrossRefGoogle Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Massachusetts General HospitalBostonUSA

Section editors and affiliations

  • Vipul Kashyap
    • 1
  1. 1.Director, Clinical ProgramsCIGNA HealthcareBloomfieldUSA