Data Warehouse Project for Clinical Data in the Pharmaceutical Industry Sylvia Pratz and Dipl.-Ing. (FH) Karlheinz Dreher
Boehringer Ingelheim Pharma GmbH & Co. KG, Biberach (Germany)
The analysis and reporting of data collected in clinical trials is a c rucial part in the lifecycle of a drug. Trial data analysis must be controlled and must deliver reproducible results. Special emphasis has to be paid to a controlled environment that complies with 21 CFR Part 11.
This article describes a project set up by a pharmaceutical company (Boehringer Ingelheim) in order to develop an integrated system for clinical data building, storage, analysis, and reporting on an international basis. A partnership with Oracle Corporation (Oracle®) and IBM® was formed with the goal of developing a commercially available product called Clinical Data Repository (CDR). The following article starts with a brief description of the existing setup, which was taken as the starting point for the requirements for the new application. Then, it continues with a discussion of the requirements, the functions of and process supported by the system, and its technical implementation.
The article concludes with an overview of the project, describing the challenges that lie ahead and outlining possible future applications of CDR.
Key words Clinical data, analysis, reporting • Clinical Data Repository (CDR)