Data Warehousing for Clinical Research
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.
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...
- 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