A dimensional warehouse for integrating operational data from clinical trials
Autor: | Victor S. Lobanov, Paul Konstant, Michael A Farnum, Joseph Ciervo, Dimitris K. Agrafiotis, Lalit Mohanty, Mathangi Ashok |
---|---|
Rok vydání: | 2019 |
Předmět: |
Research Report
Clinical Trials as Topic 0303 health sciences Process management business.industry Relational database Computer science 030302 biochemistry & molecular biology General Biochemistry Genetics and Molecular Biology Data warehouse Set (abstract data type) 03 medical and health sciences Data visualization Data Warehousing Database Management Systems Humans Resource allocation (computer) Original Article General Agricultural and Biological Sciences business Risk management 030304 developmental biology Information Systems Clinical data repository Graphical user interface |
Zdroj: | Database: The Journal of Biological Databases and Curation |
ISSN: | 1758-0463 |
Popis: | Timely, consistent and integrated access to clinical trial data remains one of the pharmaceutical industry’s most pressing needs. As part of a comprehensive clinical data repository, we have developed a data warehouse that can integrate operational data from any source, conform it to a canonical data model and make it accessible to study teams in a timely, secure and contextualized manner to support operational oversight, proactive risk management and other analytic and reporting needs. Our solution consists of a dimensional relational data warehouse, a set of extraction, transformation and loading processes to coordinate data ingestion and mapping, a generalizable metrics engine to enable the computation of operational metrics and key performance, quality and risk indicators and a set of graphical user interfaces to facilitate configuration, management and administration. When combined with the appropriate data visualization tools, the warehouse enables convenient access to raw operational data and derived metrics to help track study conduct and performance, identify and mitigate risks, monitor and improve operational processes, manage resource allocation, strengthen investigator and sponsor relationships and other purposes. |
Databáze: | OpenAIRE |
Externí odkaz: | |
Nepřihlášeným uživatelům se plný text nezobrazuje | K zobrazení výsledku je třeba se přihlásit. |