Logo image
Data warehouse design for pharmaceutical drug discovery research
Conference proceeding

Data warehouse design for pharmaceutical drug discovery research

M.G Axel and Il-Yeol Song
Database and Expert Systems Applications. 8th International Conference, DEXA '97. Proceedings, pp 644-650
1997

Abstract

Chemical compounds Data analysis Data models Data warehouses Diseases Drugs Pharmaceuticals Testing Transaction databases Warehousing
Pharmaceutical companies spend billions of dollars annually on drug discovery research. In the process, they generate vast amounts of scientific data. Data warehousing could significantly shorten the research cycle that leads to a new drug. We propose a framework for the application of data warehousing to integrate a pharmaceutical company's drug discovery data. We provide an analysis of the principal activities involved in drug discovery in the pharmaceutical industry, and a set of questions from which potential queries can be derived. This information is used to identify fact and dimension tables, and a dimensional data model for a drug discovery data warehouse is proposed.

Metrics

41 Record Views

Details

Logo image