{"id":"https://openalex.org/W2405773865","doi":"https://doi.org/10.3233/978-1-61499-512-8-929","title":"Designing ETL Tools to Feed a Data Warehouse Based on Electronic Healthcare Record Infrastructure","display_name":"Designing ETL Tools to Feed a Data Warehouse Based on Electronic Healthcare Record Infrastructure","publication_year":2015,"publication_date":"2015-01-01","ids":{"openalex":"https://openalex.org/W2405773865","doi":"https://doi.org/10.3233/978-1-61499-512-8-929","mag":"2405773865","pmid":"https://pubmed.ncbi.nlm.nih.gov/25991292"},"language":"en","primary_location":{"id":"doi:10.3233/978-1-61499-512-8-929","is_oa":false,"landing_page_url":"https://doi.org/10.3233/978-1-61499-512-8-929","pdf_url":null,"source":{"id":"https://openalex.org/S4210179765","display_name":"Studies in health technology and informatics","issn_l":"0926-9630","issn":["0926-9630","1879-8365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},"type":"article","indexed_in":["crossref","pubmed"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://www.cnr.it/prodotto/i/412187","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5061292206","display_name":"Fabrizio Pecoraro","orcid":"https://orcid.org/0000-0001-5718-4240"},"institutions":[{"id":"https://openalex.org/I4210117484","display_name":"Institute for Research on Population and Social Policies","ror":"https://ror.org/01n1ayq61","country_code":"IT","type":"facility","lineage":["https://openalex.org/I4210117484","https://openalex.org/I4210155236"]},{"id":"https://openalex.org/I4210155236","display_name":"National Research Council","ror":"https://ror.org/04zaypm56","country_code":"IT","type":"nonprofit","lineage":["https://openalex.org/I4210155236"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Pecoraro Fabrizio","raw_affiliation_strings":["Institute for Research on Population and Social Policies, National Research Council, Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute for Research on Population and Social Policies, National Research Council, Italy","institution_ids":["https://openalex.org/I4210117484","https://openalex.org/I4210155236"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010067486","display_name":"Daniela Luzi","orcid":"https://orcid.org/0000-0003-3404-3271"},"institutions":[{"id":"https://openalex.org/I4210117484","display_name":"Institute for Research on Population and Social Policies","ror":"https://ror.org/01n1ayq61","country_code":"IT","type":"facility","lineage":["https://openalex.org/I4210117484","https://openalex.org/I4210155236"]},{"id":"https://openalex.org/I4210155236","display_name":"National Research Council","ror":"https://ror.org/04zaypm56","country_code":"IT","type":"nonprofit","lineage":["https://openalex.org/I4210155236"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"Luzi Daniela","raw_affiliation_strings":["Institute for Research on Population and Social Policies, National Research Council, Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute for Research on Population and Social Policies, National Research Council, Italy","institution_ids":["https://openalex.org/I4210117484","https://openalex.org/I4210155236"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5102868767","display_name":"Fabrizio L. Ricci","orcid":"https://orcid.org/0000-0002-6110-7712"},"institutions":[{"id":"https://openalex.org/I4210115688","display_name":"Institute for Systems Analysis","ror":"https://ror.org/02kmet255","country_code":"RU","type":"facility","lineage":["https://openalex.org/I4210115688"]},{"id":"https://openalex.org/I4210155236","display_name":"National Research Council","ror":"https://ror.org/04zaypm56","country_code":"IT","type":"nonprofit","lineage":["https://openalex.org/I4210155236"]}],"countries":["IT","RU"],"is_corresponding":false,"raw_author_name":"Ricci Fabrizio L.","raw_affiliation_strings":["Institute for System Analysis and Computer Science, National Research Council, Italy"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute for System Analysis and Computer Science, National Research Council, Italy","institution_ids":["https://openalex.org/I4210115688","https://openalex.org/I4210155236"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.8577,"has_fulltext":false,"cited_by_count":13,"citation_normalized_percentile":{"value":0.86222077,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":"210","issue":null,"first_page":"929","last_page":"33"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11710","display_name":"Biomedical Text Mining and Ontologies","score":0.9926999807357788,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},"topics":[{"id":"https://openalex.org/T11710","display_name":"Biomedical Text Mining and Ontologies","score":0.9926999807357788,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},{"id":"https://openalex.org/T10350","display_name":"Electronic Health Records Systems","score":0.989799976348877,"subfield":{"id":"https://openalex.org/subfields/3605","display_name":"Health Information Management"},"field":{"id":"https://openalex.org/fields/36","display_name":"Health Professions"},"domain":{"id":"https://openalex.org/domains/4","display_name":"Health Sciences"}},{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9718999862670898,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.8382562398910522},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7141717672348022},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.6271699666976929},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5093966126441956},{"id":"https://openalex.org/keywords/electronic-health-record","display_name":"Electronic health record","score":0.4986445903778076},{"id":"https://openalex.org/keywords/warehouse","display_name":"Warehouse","score":0.49555957317352295},{"id":"https://openalex.org/keywords/health-care","display_name":"Health care","score":0.4390888810157776},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.3464395999908447},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3254811763763428},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.07179084420204163}],"concepts":[{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.8382562398910522},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7141717672348022},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.6271699666976929},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5093966126441956},{"id":"https://openalex.org/C3020144179","wikidata":"https://www.wikidata.org/wiki/Q10871684","display_name":"Electronic health record","level":3,"score":0.4986445903778076},{"id":"https://openalex.org/C50416739","wikidata":"https://www.wikidata.org/wiki/Q181623","display_name":"Warehouse","level":2,"score":0.49555957317352295},{"id":"https://openalex.org/C160735492","wikidata":"https://www.wikidata.org/wiki/Q31207","display_name":"Health care","level":2,"score":0.4390888810157776},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3464395999908447},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3254811763763428},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.07179084420204163},{"id":"https://openalex.org/C50522688","wikidata":"https://www.wikidata.org/wiki/Q189833","display_name":"Economic growth","level":1,"score":0.0},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0}],"mesh":[{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D003628","descriptor_name":"Database Management Systems","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D007558","descriptor_name":"Italy","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D007558","descriptor_name":"Italy","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D007558","descriptor_name":"Italy","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D008498","descriptor_name":"Medical Record Linkage","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D008498","descriptor_name":"Medical Record Linkage","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D008498","descriptor_name":"Medical Record Linkage","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D012984","descriptor_name":"Software","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D012984","descriptor_name":"Software","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D012984","descriptor_name":"Software","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D012985","descriptor_name":"Software Design","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D012985","descriptor_name":"Software Design","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D012985","descriptor_name":"Software Design","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D016208","descriptor_name":"Databases, Factual","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":false},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D017410","descriptor_name":"Practice Guidelines as Topic","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D017410","descriptor_name":"Practice Guidelines as Topic","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D017410","descriptor_name":"Practice Guidelines as Topic","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D057208","descriptor_name":"Health Level Seven","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D057208","descriptor_name":"Health Level Seven","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D057208","descriptor_name":"Health Level Seven","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":false},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":false},{"descriptor_ui":"D066264","descriptor_name":"Datasets as Topic","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D066264","descriptor_name":"Datasets as Topic","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D066264","descriptor_name":"Datasets as Topic","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true}],"locations_count":3,"locations":[{"id":"doi:10.3233/978-1-61499-512-8-929","is_oa":false,"landing_page_url":"https://doi.org/10.3233/978-1-61499-512-8-929","pdf_url":null,"source":{"id":"https://openalex.org/S4210179765","display_name":"Studies in health technology and informatics","issn_l":"0926-9630","issn":["0926-9630","1879-8365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318577","host_organization_name":"IOS Press","host_organization_lineage":["https://openalex.org/P4310318577"],"host_organization_lineage_names":["IOS Press"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},{"id":"pmid:25991292","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/25991292","pdf_url":null,"source":{"id":"https://openalex.org/S4306525036","display_name":"PubMed","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in health technology and informatics","raw_type":null},{"id":"pmh:oai:it.cnr:prodotti:412187","is_oa":true,"landing_page_url":"http://www.cnr.it/prodotto/i/412187","pdf_url":null,"source":{"id":"https://openalex.org/S7407055101","display_name":"CNR ExploRA","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"info:cnr-pdr/source/autori:Fabrizio Pecoraro, Daniela Luzi, Fabrizio L Ricci/congresso_nome:26th Medical Informatics Europe Conference/congresso_luogo:Madrid, Spain/congresso_data:27-29%2F05%2F2015/anno:2015/pagina_da:929/pagina_a:936/intervallo_pagine:929\u2013936","raw_type":"Contributo in atti di convegno"}],"best_oa_location":{"id":"pmh:oai:it.cnr:prodotti:412187","is_oa":true,"landing_page_url":"http://www.cnr.it/prodotto/i/412187","pdf_url":null,"source":{"id":"https://openalex.org/S7407055101","display_name":"CNR ExploRA","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"info:cnr-pdr/source/autori:Fabrizio Pecoraro, Daniela Luzi, Fabrizio L Ricci/congresso_nome:26th Medical Informatics Europe Conference/congresso_luogo:Madrid, Spain/congresso_data:27-29%2F05%2F2015/anno:2015/pagina_da:929/pagina_a:936/intervallo_pagine:929\u2013936","raw_type":"Contributo in atti di convegno"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.6399999856948853,"display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W4863458","https://openalex.org/W53661100","https://openalex.org/W574355879","https://openalex.org/W1575680235","https://openalex.org/W2113164419","https://openalex.org/W2398973590","https://openalex.org/W2406550977"],"related_works":["https://openalex.org/W3135624046","https://openalex.org/W2099525665","https://openalex.org/W4399515993","https://openalex.org/W2392996360","https://openalex.org/W2373884155","https://openalex.org/W4200307027","https://openalex.org/W4308822502","https://openalex.org/W2531755459","https://openalex.org/W4388421435","https://openalex.org/W2389559488"],"abstract_inverted_index":{"Aim":[0],"of":[1,37,42,46,90],"this":[2,38],"paper":[3,73],"is":[4],"to":[5,9,48,78,81],"propose":[6],"a":[7,18],"methodology":[8],"design":[10],"Extract,":[11],"Transform":[12],"and":[13],"Load":[14],"(ETL)":[15],"tools":[16],"in":[17,86],"clinical":[19,58],"data":[20,51],"warehouse":[21],"architecture":[22],"based":[23],"on":[24,34],"the":[25,35,43,50,68,75,83,87,93],"Electronic":[26],"Healthcare":[27],"Record":[28],"(EHR).":[29],"This":[30,72],"approach":[31],"takes":[32],"advantages":[33],"use":[36],"infrastructure":[39],"as":[40],"one":[41],"main":[44,76],"source":[45],"information":[47,84],"feed":[49],"warehouse,":[52],"taking":[53],"also":[54],"into":[55],"account":[56],"that":[57],"documents":[59],"produced":[60],"by":[61],"heterogeneous":[62],"legacy":[63],"systems":[64],"are":[65],"structured":[66],"using":[67],"HL7":[69],"CDA":[70],"standard.":[71],"describes":[74],"activities":[77],"be":[79],"performed":[80],"map":[82],"collected":[85],"different":[88],"types":[89],"document":[91],"with":[92],"dimensional":[94],"model":[95],"primitives.":[96]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":3},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}