{"id":"https://openalex.org/W4308185518","doi":"https://doi.org/10.3233/shti220974","title":"ETL Processes for Integrating Healthcare Data \u2013 Tools and Architecture Patterns","display_name":"ETL Processes for Integrating Healthcare Data \u2013 Tools and Architecture Patterns","publication_year":2022,"publication_date":"2022-11-03","ids":{"openalex":"https://openalex.org/W4308185518","doi":"https://doi.org/10.3233/shti220974","pmid":"https://pubmed.ncbi.nlm.nih.gov/36325856"},"language":"en","primary_location":{"id":"doi:10.3233/shti220974","is_oa":true,"landing_page_url":"https://doi.org/10.3233/shti220974","pdf_url":"https://ebooks.iospress.nl/pdf/doi/10.3233/SHTI220974","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":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},"type":"book-chapter","indexed_in":["crossref","pubmed"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://ebooks.iospress.nl/pdf/doi/10.3233/SHTI220974","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5022387756","display_name":"Ka Yung Cheng","orcid":"https://orcid.org/0000-0002-0430-7902"},"institutions":[{"id":"https://openalex.org/I32021983","display_name":"Christian-Albrechts-Universit\u00e4t zu Kiel","ror":"https://ror.org/04v76ef78","country_code":"DE","type":"education","lineage":["https://openalex.org/I32021983"]},{"id":"https://openalex.org/I4210112713","display_name":"University Hospital Schleswig-Holstein","ror":"https://ror.org/01tvm6f46","country_code":"DE","type":"healthcare","lineage":["https://openalex.org/I4210112713"]},{"id":"https://openalex.org/I9341345","display_name":"University of L\u00fcbeck","ror":"https://ror.org/00t3r8h32","country_code":"DE","type":"education","lineage":["https://openalex.org/I9341345"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Ka Yung Cheng","raw_affiliation_strings":["Institute for Medical Informatics and Statistics, Kiel University, Germany","University Hospital Schleswig-Holstein, Kiel, Germany","Institute for Medical Informatics and Statistics, Kiel University, Germany; University Hospital Schleswig-Holstein, Kiel, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute for Medical Informatics and Statistics, Kiel University, Germany","institution_ids":["https://openalex.org/I32021983"]},{"raw_affiliation_string":"University Hospital Schleswig-Holstein, Kiel, Germany","institution_ids":["https://openalex.org/I4210112713","https://openalex.org/I9341345"]},{"raw_affiliation_string":"Institute for Medical Informatics and Statistics, Kiel University, Germany; University Hospital Schleswig-Holstein, Kiel, Germany","institution_ids":["https://openalex.org/I32021983","https://openalex.org/I4210112713","https://openalex.org/I9341345"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5026764518","display_name":"Santiago Pazmino","orcid":"https://orcid.org/0009-0009-7065-0221"},"institutions":[{"id":"https://openalex.org/I32021983","display_name":"Christian-Albrechts-Universit\u00e4t zu Kiel","ror":"https://ror.org/04v76ef78","country_code":"DE","type":"education","lineage":["https://openalex.org/I32021983"]},{"id":"https://openalex.org/I4210112713","display_name":"University Hospital Schleswig-Holstein","ror":"https://ror.org/01tvm6f46","country_code":"DE","type":"healthcare","lineage":["https://openalex.org/I4210112713"]},{"id":"https://openalex.org/I9341345","display_name":"University of L\u00fcbeck","ror":"https://ror.org/00t3r8h32","country_code":"DE","type":"education","lineage":["https://openalex.org/I9341345"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Santiago Pazmino","raw_affiliation_strings":["Institute for Medical Informatics and Statistics, Kiel University, Germany","University Hospital Schleswig-Holstein, Kiel, Germany","Institute for Medical Informatics and Statistics, Kiel University, Germany; University Hospital Schleswig-Holstein, Kiel, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute for Medical Informatics and Statistics, Kiel University, Germany","institution_ids":["https://openalex.org/I32021983"]},{"raw_affiliation_string":"University Hospital Schleswig-Holstein, Kiel, Germany","institution_ids":["https://openalex.org/I4210112713","https://openalex.org/I9341345"]},{"raw_affiliation_string":"Institute for Medical Informatics and Statistics, Kiel University, Germany; University Hospital Schleswig-Holstein, Kiel, Germany","institution_ids":["https://openalex.org/I32021983","https://openalex.org/I4210112713","https://openalex.org/I9341345"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5072978778","display_name":"Bj\u00f6rn Schreiweis","orcid":"https://orcid.org/0000-0002-1748-1563"},"institutions":[{"id":"https://openalex.org/I32021983","display_name":"Christian-Albrechts-Universit\u00e4t zu Kiel","ror":"https://ror.org/04v76ef78","country_code":"DE","type":"education","lineage":["https://openalex.org/I32021983"]},{"id":"https://openalex.org/I4210112713","display_name":"University Hospital Schleswig-Holstein","ror":"https://ror.org/01tvm6f46","country_code":"DE","type":"healthcare","lineage":["https://openalex.org/I4210112713"]},{"id":"https://openalex.org/I9341345","display_name":"University of L\u00fcbeck","ror":"https://ror.org/00t3r8h32","country_code":"DE","type":"education","lineage":["https://openalex.org/I9341345"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Bj\u00f6rn Schreiweis","raw_affiliation_strings":["Institute for Medical Informatics and Statistics, Kiel University, Germany","University Hospital Schleswig-Holstein, Kiel, Germany","Institute for Medical Informatics and Statistics, Kiel University, Germany; University Hospital Schleswig-Holstein, Kiel, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute for Medical Informatics and Statistics, Kiel University, Germany","institution_ids":["https://openalex.org/I32021983"]},{"raw_affiliation_string":"University Hospital Schleswig-Holstein, Kiel, Germany","institution_ids":["https://openalex.org/I4210112713","https://openalex.org/I9341345"]},{"raw_affiliation_string":"Institute for Medical Informatics and Statistics, Kiel University, Germany; University Hospital Schleswig-Holstein, Kiel, Germany","institution_ids":["https://openalex.org/I32021983","https://openalex.org/I4210112713","https://openalex.org/I9341345"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":21.5934,"has_fulltext":true,"cited_by_count":20,"citation_normalized_percentile":{"value":0.99441803,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":97,"max":99},"biblio":{"volume":"299","issue":null,"first_page":"151","last_page":"156"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9821000099182129,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9821000099182129,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T10350","display_name":"Electronic Health Records Systems","score":0.9787999987602234,"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/T11891","display_name":"Big Data and Business Intelligence","score":0.9715999960899353,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/interoperability","display_name":"Interoperability","score":0.8014435172080994},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.640898585319519},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.5999279022216797},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5708325505256653},{"id":"https://openalex.org/keywords/health-care","display_name":"Health care","score":0.5539377331733704},{"id":"https://openalex.org/keywords/software-architecture","display_name":"Software architecture","score":0.4592137336730957},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.4516370892524719},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.4140820801258087},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.40758806467056274},{"id":"https://openalex.org/keywords/knowledge-management","display_name":"Knowledge management","score":0.32304489612579346},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.30267077684402466},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.24365931749343872},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.1106865406036377}],"concepts":[{"id":"https://openalex.org/C20136886","wikidata":"https://www.wikidata.org/wiki/Q749647","display_name":"Interoperability","level":2,"score":0.8014435172080994},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.640898585319519},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.5999279022216797},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5708325505256653},{"id":"https://openalex.org/C160735492","wikidata":"https://www.wikidata.org/wiki/Q31207","display_name":"Health care","level":2,"score":0.5539377331733704},{"id":"https://openalex.org/C35869016","wikidata":"https://www.wikidata.org/wiki/Q846636","display_name":"Software architecture","level":3,"score":0.4592137336730957},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.4516370892524719},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.4140820801258087},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.40758806467056274},{"id":"https://openalex.org/C56739046","wikidata":"https://www.wikidata.org/wiki/Q192060","display_name":"Knowledge management","level":1,"score":0.32304489612579346},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.30267077684402466},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.24365931749343872},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.1106865406036377},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"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/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0}],"mesh":[{"descriptor_ui":"D000073458","descriptor_name":"Data Warehousing","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D000073458","descriptor_name":"Data Warehousing","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D000073458","descriptor_name":"Data Warehousing","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D003695","descriptor_name":"Delivery of Health Care","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D003695","descriptor_name":"Delivery of Health Care","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D003695","descriptor_name":"Delivery of Health Care","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D012984","descriptor_name":"Software","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D012984","descriptor_name":"Software","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D012984","descriptor_name":"Software","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true}],"locations_count":2,"locations":[{"id":"doi:10.3233/shti220974","is_oa":true,"landing_page_url":"https://doi.org/10.3233/shti220974","pdf_url":"https://ebooks.iospress.nl/pdf/doi/10.3233/SHTI220974","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":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},{"id":"pmid:36325856","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/36325856","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}],"best_oa_location":{"id":"doi:10.3233/shti220974","is_oa":true,"landing_page_url":"https://doi.org/10.3233/shti220974","pdf_url":"https://ebooks.iospress.nl/pdf/doi/10.3233/SHTI220974","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":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Studies in Health Technology and Informatics","raw_type":"book-chapter"},"sustainable_development_goals":[{"score":0.6299999952316284,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[{"id":"https://openalex.org/F4320321114","display_name":"Bundesministerium f\u00fcr Bildung und Forschung","ror":"https://ror.org/04pz7b180"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4308185518.pdf","grobid_xml":"https://content.openalex.org/works/W4308185518.grobid-xml"},"referenced_works_count":12,"referenced_works":["https://openalex.org/W85675793","https://openalex.org/W2381659900","https://openalex.org/W2742781925","https://openalex.org/W2883427794","https://openalex.org/W2883986511","https://openalex.org/W2910862973","https://openalex.org/W3011633931","https://openalex.org/W3038443423","https://openalex.org/W3081818761","https://openalex.org/W3094040540","https://openalex.org/W4225695762","https://openalex.org/W4225986620"],"related_works":["https://openalex.org/W1592250461","https://openalex.org/W2071217624","https://openalex.org/W2588970946","https://openalex.org/W1482865510","https://openalex.org/W193662669","https://openalex.org/W2140805128","https://openalex.org/W1541385688","https://openalex.org/W1532006926","https://openalex.org/W4308185518","https://openalex.org/W2350728071"],"abstract_inverted_index":{"Improving":[0],"the":[1,25,29,91],"interoperability":[2],"of":[3,27,45],"healthcare":[4,20,50],"information":[5,17],"systems":[6],"is":[7],"a":[8],"crucial":[9],"clinical":[10,61],"care":[11],"issue":[12],"involving":[13],"disparate":[14],"but":[15],"coexisting":[16],"systems.":[18],"However,":[19],"organizations":[21],"are":[22],"also":[23],"facing":[24],"dilemma":[26],"choosing":[28],"right":[30],"ETL":[31,47,58,66,98],"tool":[32,99],"and":[33,68,80,87,100],"architecture":[34,69,102],"pattern":[35,103],"as":[36],"data":[37,51,62,73,76],"warehouse":[38],"enterprises.":[39],"This":[40],"article":[41],"gives":[42],"an":[43],"overview":[44],"current":[46],"tools":[48,67],"for":[49,60],"integration.":[52],"In":[53],"addition,":[54],"we":[55,95],"demonstrate":[56],"three":[57],"processes":[59],"integration":[63],"using":[64],"different":[65],"patterns,":[70],"which":[71],"map":[72],"from":[74],"various":[75],"sources":[77],"(e.g.":[78,85],"MEONA":[79],"ORBIS)":[81],"to":[82,104],"diverse":[83],"standards":[84],"FHIR":[86],"openEHR).":[88],"Depending":[89],"on":[90],"project's":[92],"technical":[93],"requirements,":[94],"choose":[96],"our":[97],"software":[101],"boost":[105],"team":[106],"efficiency.":[107]},"counts_by_year":[{"year":2025,"cited_by_count":6},{"year":2024,"cited_by_count":9},{"year":2023,"cited_by_count":5}],"updated_date":"2026-07-22T07:51:19.307946","created_date":"2025-10-10T00:00:00"}