Multi-Source Data ETL (Extract, Transform, Load) for a Genetic Epilepsy Diagnosis and Treatment Dashboard

Studies in health technology and informatics, vol. 316, pp. 354–355

Abstract

The growing number of genes identified in relation to epilepsy represents a major breakthrough in diagnosis and treatment, but experts face the challenge of efficiently accessing and consolidating the vast amount of genetic data available. Therefore, we present the process of transforming data from different sources and formats into an Entity-Attribute-Value (EAV) model database. Combined with the use of standard coding systems, this approach will provide a scalable and adaptable database to present the data in a comprehensive way to experts via a dashboard.

Authors 9

1. Ariadna Pérez Garriga corresponding Aachen Institute of Medical Informatics Medical Faculty

   RWTH Aachen University

   Affiliation as printed

   Institute of Medical Informatics, Medical Faculty, RWTH Aachen University, Aachen, Germany

2. Philipp Honrath Aachen Department of Epileptology and Neurology Medical Faculty

   RWTH Aachen University

   Affiliation as printed

   Department of Epileptology and Neurology, Medical Faculty, RWTH Aachen University, Aachen, Germany

3. Stefan Wolking Aachen Department of Epileptology and Neurology Medical Faculty

   RWTH Aachen University

   Affiliation as printed

   Department of Epileptology and Neurology, Medical Faculty, RWTH Aachen University, Aachen, Germany

4. Beatrice Coldewey Aachen Institute of Medical Informatics Medical Faculty

   RWTH Aachen University

   Affiliation as printed

   Institute of Medical Informatics, Medical Faculty, RWTH Aachen University, Aachen, Germany

5. Susann A. Bozkir Aachen Institute of Medical Informatics Medical Faculty

   RWTH Aachen University

   Affiliation as printed

   Institute of Medical Informatics, Medical Faculty, RWTH Aachen University, Aachen, Germany

6. Patrick May

   University of Luxembourg · Luxembourg Centre for Systems Biomedicine

   Affiliation as printed

   Luxembourg Centre for Systems Biomedicine, University of Luxembourg, Esch-sur-Alzette, Luxembourg

7. Yvonne G. Weber Aachen Department of Epileptology and Neurology Medical Faculty

   RWTH Aachen University

   Affiliation as printed

   Department of Epileptology and Neurology, Medical Faculty, RWTH Aachen University, Aachen, Germany

8. Rainer Röhrig Aachen Institute of Medical Informatics Medical Faculty

   RWTH Aachen University

   Affiliation as printed

   Institute of Medical Informatics, Medical Faculty, RWTH Aachen University, Aachen, Germany

9. Myriam Lipprandt Aachen Institute of Medical Informatics Medical Faculty

   RWTH Aachen University

   Affiliation as printed

   Institute of Medical Informatics, Medical Faculty, RWTH Aachen University, Aachen, Germany