Skip to main content
SpringerLink
Log in

Data Warehousing for Clinical Research

  • Living reference work entry
  • First Online:
Encyclopedia of Database Systems

  • 76 Accesses

Synonyms

Clinical research chart

Definition

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 via an institution to check access.

Access this chapter

Log in via an institution

Institutional subscriptions

Recommended Reading

  1. Inmon WH. Building the data warehouse. 2nd ed. New York: Wiley; 1996.

    Google Scholar 

  2. Kimball R. The data warehousing toolkit. New York: Wiley; 1997.

    Google Scholar 

  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. 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. Nadkarni PM, Brandt C. Data extraction and ad hoc query of an entity-attribute-value database. J Am Med Inform Assoc. 1998;5:511–7.

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Massachusetts General Hospital, Boston, MA, USA

    Shawn Murphy

Authors
  1. Shawn Murphy
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Shawn Murphy .

Editor information

Editors and Affiliations

  1. Georgia Institute of Technology College of Computing, Atlanta, Georgia, USA

    Ling Liu

  2. University of Waterloo School of Computer Science, Waterloo, Ontario, Canada

    M. Tamer Özsu

Section Editor information

  1. Director, Clinical Programs, CIGNA Healthcare, Bloomfield, Connecticut, USA

    Vipul Kashyap

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer Science+Business Media LLC

About this entry

Cite this entry

Murphy, S. (2016). Data Warehousing for Clinical Research. In: Liu, L., Özsu, M. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4899-7993-3_120-2

Download citation

  • DOI: https://doi.org/10.1007/978-1-4899-7993-3_120-2

  • Received:

  • Accepted:

  • Published:

  • Publisher Name: Springer, New York, NY

  • Online ISBN: 978-1-4899-7993-3

  • eBook Packages: Springer Reference Computer SciencesReference Module Computer Science and Engineering

Publish with us

Policies and ethics

Search

Navigation