title: [Technical improvement of cohort constitution in administrative health databases: Providing a tool for integration and standardization of data applicable in the French National Health Insurance Database (SNIIRAM)].
abstract: OBJECTIVE
  Administrative health databases such as the French National Heath Insurance Database - SNIIRAM - are a major tool to answer numerous public health research questions. However the use of such data requires complex and time-consuming data management. Our objective was to develop and make available a tool to optimize cohort constitution within administrative health databases.
  
  
  METHODS
  We developed a process to extract, transform and load (ETL) data from various heterogeneous sources in a standardized data warehouse. This data warehouse is architected as a star schema corresponding to an i2b2 star schema model. We then evaluated the performance of this ETL using data from a pharmacoepidemiology research project conducted in the SNIIRAM database.
  
  
  RESULTS
  The ETL we developed comprises a set of functionalities for creating SAS scripts. Data can be integrated into a standardized data warehouse. As part of the performance assessment of this ETL, we achieved integration of a dataset from the SNIIRAM comprising more than 900 million lines in less than three hours using a desktop computer. This enables patient selection from the standardized data warehouse within seconds of the request.
  
  
  CONCLUSIONS
  The ETL described in this paper provides a tool which is effective and compatible with all administrative health databases, without requiring complex database servers. This tool should simplify cohort constitution in health databases; the standardization of warehouse data facilitates collaborative work between research teams.
authors: Unité de soutien méthodologique, département d'informatique médicale, CHU La-Réunion, allée des Topazes, CS11021, 97400 Saint-Denis, France; Inserm, CIC 1410, 97410 Saint-Pierre, France. Electronic address: cyril.ferdynus@chu-reunion.fr.
authors: C
authors: C
authors: Ferdynus
authors: Unité de soutien méthodologique, département d'informatique médicale, CHU La-Réunion, allée des Topazes, CS11021, 97400 Saint-Denis, France; Inserm, CIC 1410, 97410 Saint-Pierre, France. Electronic address: laetitia.huiart@chu-reunion.fr.
authors: L
authors: L
authors: Huiart
mesh_terms: D000465:Algorithms; D015331:Cohort Studies; D016208:Databases, Factual / Q000592:standards*; D015340:Epidemiologic Research Design; D005602:France / Q000453:epidemiology; D006801:Humans; D016247:Information Storage and Retrieval / Q000592:standards*; D008499:Medical Records / Q000592:standards* / Q000706:statistics & numerical data; D009313:National Health Programs / Q000458:organization & administration / Q000592:standards; D017891:Pharmacoepidemiology / Q000458:organization & administration / Q000592:standards; D058996:Quality Improvement; D012015:Reference Standards
keywords: Algorithm; Algorithme; Base de données; Cohort; Cohorte; Database; I2b2; Pharmaco-épidémiologie; Pharmacoepidemiology; SAS; SNIIRAM