Skip to main content
SpringerLink
Log in
Book cover

Encyclopedia of Database Systems pp 903–907Cite as

Data Warehousing for Clinical Research

  • Reference work entry
  • First Online:

  • 33 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.

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   4,499.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book
USD   6,499.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about 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(6):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, GA, USA

    Ling Liu

  2. University of Waterloo School of Computer Science, Waterloo, ON, 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

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

About this entry

Check for updates. Verify currency and authenticity via CrossMark

Cite this entry

Murphy, S. (2018). Data Warehousing for Clinical Research. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_120

Download citation

Publish with us

Policies and ethics

Search

Navigation