title: Semantic integration of medication data into the EHOP Clinical Data Warehouse.
abstract: Reusing medication data is crucial for many medical research domains. Semantic integration of such data in clinical data warehouse (CDW) is quite challenging. Our objective was to develop a reliable and scalable method for integrating prescription data into EHOP (a French CDW).
  
  
  METHODS
  PN13/PHAST was used as the semantic interoperability standard during the ETL process, and to store the prescriptions as documents in the CDW. Theriaque was used as a drug knowledge database (DKDB), to annotate the prescription dataset with the finest granularity, and to provide semantic capabilities to the EHOP query workbench.
  
  
  RESULTS
  the system was evaluated on a clinical data set. Depending on the use case, the precision ranged from 52% to 100%, Recall was always 100%.
  
  
  CONCLUSIONS
  interoperability standards and DKDB, document approach, and the finest granularity approach are the key factors for successful drug data integration in CDW.
authors.affiliation: INSERM, U1099, Rennes, F-35000, France.
authors.forename: Denis
authors.initials: D
authors.lastname: Delamarre
authors.affiliation: INSERM, U1099, Rennes, F-35000, France.
authors.forename: Guillaume
authors.initials: G
authors.lastname: Bouzille
authors.affiliation: Université de Rennes 1, LTSI, Rennes, F-35000, France.
authors.forename: Kevin
authors.initials: K
authors.lastname: Dalleau
authors.affiliation: CHU Rennes, DIFSI, Rennes, F-35000, France.
authors.forename: Denis
authors.initials: D
authors.lastname: Courtel
authors.affiliation: INSERM, U1099, Rennes, F-35000, France.
authors.forename: Marc
authors.initials: M
authors.lastname: Cuggia
mesh_terms: D062313:Databases, Pharmaceutical; D057286:Electronic Health Records / Q000458:organization & administration*; D016247:Information Storage and Retrieval / Q000379:methods; D050316:Medical Order Entry Systems / Q000458:organization & administration*; D008498:Medical Record Linkage / Q000379:methods*; D008510:Medication Systems, Hospital / Q000458:organization & administration*; D009323:Natural Language Processing; D012660:Semantics; D018511:Systems Integration