Scientific Data Warehouses

Inventiva, based in Dijon, France, is a clinical stage drug-discovery company delivering breakthrough therapies in the area of oncology, fibrosis and rare diseases. quattro research is proud to support the research and development at Inventiva by building and maintaining a Scientific Data Warehouse. The heterogeneous source data handled in Inventiva’s Data Warehouse consist of screening results (HTS and HCS), an electronic lab notebook for DMPK and other biological results, chemical registration and legacy data. These are fed into the Warehouse using ETL (Extract, Transform, Load) processes. The Data mart is a layer within the Data Warehouse where the data are prepared to be used by Inventiva’s scientists. Outgoing data packages fall into three categories: reports, data analysis and ad-hoc queries. The scientists may request these packages in three different levels, depending on the question they are asking: aggregated data, main results and drill-down results.