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

Stud Health Technol Inform. 2024 Aug 22:316:354-355. doi: 10.3233/SHTI240418.

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.

Keywords: Common Data Model; Data Standardization; ETL; Epilepsy; Genetics.

MeSH terms

  • Databases, Genetic
  • Epilepsy* / diagnosis
  • Epilepsy* / drug therapy
  • Epilepsy* / genetics
  • Humans