Search

We have created a data warehouse for human pharmacokinetic (PK) and pharmacodynamic (PD) data generated primarily within the Clinical PK Group of the Drug Metabolism and Pharmacokinetics (DMPK) Department of DuPont Pharmaceuticals.Data which enters an Oracle-based LIMS directly from chromatography systems or through files from contract research organizations are accessed via SAS/PH.Kinetics, GLP-compliant data analysis software residing on individual users' workstations. Upon completion of the final PK or PD analysis, data are pushed to a predefined location. Data analyzed/created with other software (i.e., WinNonlin, NONMEM, Adapt, etc.) are added to this file repository as well. The warehouse creates views to these data and accumulates metadata on all data sources defined in the warehouse. The warehouse is managed via the SAS/Warehouse Administrator product that defines the environment, creates summarized data structures, and schedules data refresh.The clinical PK/PD warehouse encompasses laboratory, biometric, PK and PD data streams. Detailed logical tables for each compound are created/updated as the clinical PK/PD data warehouse is populated. The data model defined to the warehouse is based on a star schema. Summarized data structures such as multidimensional data bases (MDDB), infomarts, and datamarts are created from detail tables. Data mining and querying of highly summarized data as well as drill-down to detail data is possible via the creation of exploitation tools which front-end the warehouse data. Based on periodic refreshing of the warehouse data, these applications are able to access the most current data available and do not require a manual interface to update/populate the data store. Prototype applications have been web-enabled to facilitate their usage to varied data customers across platform and location. The warehouse also contains automated mechanisms for the construction of study data listings and SAS transport files for eventual incorporation into an electronic submission.This environment permits the management of online analytical processing via a single administrator once the data model and warehouse configuration have been designed. The expansion of the current environment will eventually connect data from all phases of research and development ensuring the return on investment and hopefully efficiencies in data processing unforeseen with earlier legacy systems.

The highly competitive pharmaceutical industry has seen many external changes to its landscape as companies consume each other increasing their pipelines while removing redundant functions and processes. Internally, companies have sought to streamline the discovery and development phases in an attempt to improve candidate selection and reduce the time to regulatory filing. In conjunction with efforts to screen and develop more compounds faster and more efficiently, database management systems (DBMS) have been developed for numerous groups supporting various RD efforts. An outgrowth of DBMS evolution has been the birth of data warehousing. Often confused with DBMS, data warehousing provides a conduit for data residing across platforms, networks, and in different data structures. Through the use of metadata, the warehouse establishes connectivity of varied data stores (operational detail data, ODD) and permits identification of data ownership, location and transaction history. This evolution has closely mirrored and in some ways been driven by the electronic submission (formerly CANDA). The integration of the electronic submissions and document management with RD data warehousing initiatives should provide a platform by which companies can address compliance with 21 CFR Part 11. Now more than ever "corporate memory" is being extended to the data itself. The when, why and how of successes and failures are constantly being probed by RD management teams. The volume of information being generated by today's pharmaceutical companies requires mining of historical data on a routine basis. Data warehousing represents a core technology to assist in this endeavor. New initiatives in this field address the necessity of data portals through which warehouse data can be web-enabled and exploited by diverse data customers both internal and external to the company. The epiphany of data warehousing technologies within the pharmaceutical industry has begun and promises to change the way in which companies process and provide data to regulatory agencies. The improvements in drug discovery and reduction in development timelines remain to be seen but would seem to be rational if such technology is fully exploited.