title: Designing ETL Tools to Feed a Data Warehouse Based on Electronic Healthcare Record Infrastructure.
abstract: Aim of this paper is to propose a methodology to design Extract, Transform and Load (ETL) tools in a clinical data warehouse architecture based on the Electronic Healthcare Record (EHR). This approach takes advantages on the use of this infrastructure as one of the main source of information to feed the data warehouse, taking also into account that clinical documents produced by heterogeneous legacy systems are structured using the HL7 CDA standard. This paper describes the main activities to be performed to map the information collected in the different types of document with the dimensional model primitives.
authors.affiliation: Institute for Research on Population and Social Policies, National Research Council, Italy.
authors.forename: Fabrizio
authors.initials: F
authors.lastname: Pecoraro
authors.affiliation: Institute for Research on Population and Social Policies, National Research Council, Italy.
authors.forename: Daniela
authors.initials: D
authors.lastname: Luzi
authors.affiliation: Institute for System Analysis and Computer Science, National Research Council, Italy.
authors.forename: Fabrizio L
authors.initials: FL
authors.lastname: Ricci
mesh_terms: D003628:Database Management Systems / Q000458:organization & administration*; D016208:Databases, Factual / Q000592:standards; D066264:Datasets as Topic; D057286:Electronic Health Records / Q000458:organization & administration*; D057208:Health Level Seven / Q000592:standards; D016247:Information Storage and Retrieval / Q000379:methods / Q000592:standards*; D007558:Italy; D008498:Medical Record Linkage / Q000592:standards*; D017410:Practice Guidelines as Topic; D012984:Software; D012985:Software Design