{"id":"https://openalex.org/W4410448030","doi":"https://doi.org/10.3233/shti250300","title":"Real-Time Automated Monitoring Architecture for Ensuring Quality ETL Processes in Healthcare Data: A Case Study from Cologne University Hospital\u2019s Medical Data Integration Center","display_name":"Real-Time Automated Monitoring Architecture for Ensuring Quality ETL Processes in Healthcare Data: A Case Study from Cologne University Hospital\u2019s Medical Data Integration Center","publication_year":2025,"publication_date":"2025-05-15","ids":{"openalex":"https://openalex.org/W4410448030","doi":"https://doi.org/10.3233/shti250300","pmid":"https://pubmed.ncbi.nlm.nih.gov/40380412"},"language":"en","primary_location":{"id":"doi:10.3233/shti250300","is_oa":true,"landing_page_url":"https://doi.org/10.3233/shti250300","pdf_url":"https://ebooks.iospress.nl/pdf/doi/10.3233/SHTI250300","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/SHTI250300","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5086684091","display_name":"Md. Mostafa Kamal","orcid":"https://orcid.org/0000-0002-5506-4875"},"institutions":[{"id":"https://openalex.org/I180923762","display_name":"University of Cologne","ror":"https://ror.org/00rcxh774","country_code":"DE","type":"education","lineage":["https://openalex.org/I180923762"]},{"id":"https://openalex.org/I4210153755","display_name":"University Hospital Cologne","ror":"https://ror.org/05mxhda18","country_code":"DE","type":"healthcare","lineage":["https://openalex.org/I4210153755"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Md. Mostafa Kamal","raw_affiliation_strings":["Institute for Biomedical Informatics, University of Cologne, Faculty of Medicine and University Hospital Cologne, Cologne, Germany","Medical Data Integration Center (MeDIC), University of Cologne, Faculty of Medicine and University Hospital Cologne, Cologne, Germany"],"raw_orcid":"https://orcid.org/0000-0002-5506-4875","affiliations":[{"raw_affiliation_string":"Institute for Biomedical Informatics, University of Cologne, Faculty of Medicine and University Hospital Cologne, Cologne, Germany","institution_ids":["https://openalex.org/I180923762","https://openalex.org/I4210153755"]},{"raw_affiliation_string":"Medical Data Integration Center (MeDIC), University of Cologne, Faculty of Medicine and University Hospital Cologne, Cologne, Germany","institution_ids":["https://openalex.org/I180923762","https://openalex.org/I4210153755"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5047693689","display_name":"Ekaterina Kutafina","orcid":"https://orcid.org/0000-0002-3430-5123"},"institutions":[{"id":"https://openalex.org/I180923762","display_name":"University of Cologne","ror":"https://ror.org/00rcxh774","country_code":"DE","type":"education","lineage":["https://openalex.org/I180923762"]},{"id":"https://openalex.org/I4210153755","display_name":"University Hospital Cologne","ror":"https://ror.org/05mxhda18","country_code":"DE","type":"healthcare","lineage":["https://openalex.org/I4210153755"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Ekaterina Kutafina","raw_affiliation_strings":["Institute for Biomedical Informatics, University of Cologne, Faculty of Medicine and University Hospital Cologne, Cologne, Germany"],"raw_orcid":"https://orcid.org/0000-0002-3430-5123","affiliations":[{"raw_affiliation_string":"Institute for Biomedical Informatics, University of Cologne, Faculty of Medicine and University Hospital Cologne, Cologne, Germany","institution_ids":["https://openalex.org/I180923762","https://openalex.org/I4210153755"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5067635650","display_name":"Oya Beyan","orcid":"https://orcid.org/0000-0001-7611-3501"},"institutions":[{"id":"https://openalex.org/I180923762","display_name":"University of Cologne","ror":"https://ror.org/00rcxh774","country_code":"DE","type":"education","lineage":["https://openalex.org/I180923762"]},{"id":"https://openalex.org/I4210110507","display_name":"Fraunhofer Institute for Applied Information Technology","ror":"https://ror.org/01ak24c12","country_code":"DE","type":"facility","lineage":["https://openalex.org/I4210110507","https://openalex.org/I4923324"]},{"id":"https://openalex.org/I4210153755","display_name":"University Hospital Cologne","ror":"https://ror.org/05mxhda18","country_code":"DE","type":"healthcare","lineage":["https://openalex.org/I4210153755"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Oya Beyan","raw_affiliation_strings":["Department of Data Science and Artificial Intelligence, Fraunhofer FIT, Germany","Institute for Biomedical Informatics, University of Cologne, Faculty of Medicine and University Hospital Cologne, Cologne, Germany","Medical Data Integration Center (MeDIC), University of Cologne, Faculty of Medicine and University Hospital Cologne, Cologne, Germany"],"raw_orcid":"https://orcid.org/0000-0001-7611-3501","affiliations":[{"raw_affiliation_string":"Department of Data Science and Artificial Intelligence, Fraunhofer FIT, Germany","institution_ids":["https://openalex.org/I4210110507"]},{"raw_affiliation_string":"Institute for Biomedical Informatics, University of Cologne, Faculty of Medicine and University Hospital Cologne, Cologne, Germany","institution_ids":["https://openalex.org/I180923762","https://openalex.org/I4210153755"]},{"raw_affiliation_string":"Medical Data Integration Center (MeDIC), University of Cologne, Faculty of Medicine and University Hospital Cologne, Cologne, Germany","institution_ids":["https://openalex.org/I180923762","https://openalex.org/I4210153755"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.27348311,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"327","issue":null,"first_page":"193","last_page":"197"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9671000242233276,"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.9671000242233276,"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.9585999846458435,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9049000144004822,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/dashboard","display_name":"Dashboard","score":0.7491757273674011},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6419321298599243},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5539127588272095},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.5020463466644287},{"id":"https://openalex.org/keywords/quality","display_name":"Quality (philosophy)","score":0.5007836818695068},{"id":"https://openalex.org/keywords/data-quality","display_name":"Data quality","score":0.4906226694583893},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3746780753135681},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3552987575531006},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.20690971612930298},{"id":"https://openalex.org/keywords/operations-management","display_name":"Operations management","score":0.15204289555549622},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.12437662482261658}],"concepts":[{"id":"https://openalex.org/C33499554","wikidata":"https://www.wikidata.org/wiki/Q1417134","display_name":"Dashboard","level":2,"score":0.7491757273674011},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6419321298599243},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5539127588272095},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.5020463466644287},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.5007836818695068},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.4906226694583893},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3746780753135681},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3552987575531006},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.20690971612930298},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.15204289555549622},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.12437662482261658},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C176217482","wikidata":"https://www.wikidata.org/wiki/Q860554","display_name":"Metric (unit)","level":2,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[{"descriptor_ui":"D000068598","descriptor_name":"Data Accuracy","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D000068598","descriptor_name":"Data Accuracy","qualifier_ui":null,"qualifier_name":null,"is_major_topic":true},{"descriptor_ui":"D005858","descriptor_name":"Germany","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D005858","descriptor_name":"Germany","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006785","descriptor_name":"Hospitals, University","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":true},{"descriptor_ui":"D006785","descriptor_name":"Hospitals, University","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":true},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D006801","descriptor_name":"Humans","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":true},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000379","qualifier_name":"methods","is_major_topic":true},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":true},{"descriptor_ui":"D016247","descriptor_name":"Information Storage and Retrieval","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":true},{"descriptor_ui":"D019982","descriptor_name":"Organizational Case Studies","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D019982","descriptor_name":"Organizational Case Studies","qualifier_ui":null,"qualifier_name":null,"is_major_topic":false},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":true},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":"Q000458","qualifier_name":"organization & administration","is_major_topic":true},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":true},{"descriptor_ui":"D057286","descriptor_name":"Electronic Health Records","qualifier_ui":"Q000592","qualifier_name":"standards","is_major_topic":true}],"locations_count":3,"locations":[{"id":"doi:10.3233/shti250300","is_oa":true,"landing_page_url":"https://doi.org/10.3233/shti250300","pdf_url":"https://ebooks.iospress.nl/pdf/doi/10.3233/SHTI250300","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:40380412","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/40380412","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":"Journal Article"},{"id":"pmh:oai:publica.fraunhofer.de:publica/512036","is_oa":false,"landing_page_url":"https://publica.fraunhofer.de/handle/publica/512036","pdf_url":null,"source":{"id":"https://openalex.org/S4306400318","display_name":"Fraunhofer-Publica (Fraunhofer-Gesellschaft)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4923324","host_organization_name":"Fraunhofer-Gesellschaft","host_organization_lineage":["https://openalex.org/I4923324"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"conference paper"}],"best_oa_location":{"id":"doi:10.3233/shti250300","is_oa":true,"landing_page_url":"https://doi.org/10.3233/shti250300","pdf_url":"https://ebooks.iospress.nl/pdf/doi/10.3233/SHTI250300","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.5199999809265137,"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions"}],"awards":[{"id":"https://openalex.org/G1818531448","display_name":null,"funder_award_id":"FKZ01KX2121","funder_id":"https://openalex.org/F4320321114","funder_display_name":"Bundesministerium f\u00fcr Bildung und Forschung"},{"id":"https://openalex.org/G750904052","display_name":null,"funder_award_id":"01KX2121","funder_id":"https://openalex.org/F4320321114","funder_display_name":"Bundesministerium f\u00fcr Bildung und Forschung"}],"funders":[{"id":"https://openalex.org/F4320321114","display_name":"Bundesministerium f\u00fcr Bildung und Forschung","ror":"https://ror.org/04pz7b180"},{"id":"https://openalex.org/F4320324811","display_name":"Universit\u00e4t zu K\u00f6ln","ror":"https://ror.org/00rcxh774"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4410448030.pdf","grobid_xml":"https://content.openalex.org/works/W4410448030.grobid-xml"},"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2607236244","https://openalex.org/W2382083831","https://openalex.org/W4239369595","https://openalex.org/W2169792944","https://openalex.org/W3048913176","https://openalex.org/W4386891374","https://openalex.org/W4292603292","https://openalex.org/W2135768893","https://openalex.org/W3021414116","https://openalex.org/W176219849"],"abstract_inverted_index":{"This":[0],"case":[1],"study":[2],"discusses":[3],"the":[4,14,27,34,40,52,76,86,93,105,108],"effectiveness":[5],"of":[6,96,98],"implementing":[7],"a":[8,83],"real-time":[9],"automated":[10],"monitoring":[11],"architecture":[12],"using":[13],"ELK":[15],"Stack":[16],"(Elasticsearch,":[17],"Logstash":[18],"and":[19,44,57,61,72],"Kibana)":[20],"to":[21,78,91,100],"ensure":[22],"data":[23,65],"ingestion":[24,94],"quality":[25,66],"within":[26],"Medical":[28],"Data":[29],"Integration":[30],"Center":[31],"(MeDIC)":[32],"at":[33],"University":[35],"Hospital":[36],"Cologne.":[37],"By":[38],"streamlining":[39],"ETL":[41],"(Extract,":[42],"Transform,":[43],"Load)":[45],"log":[46],"analysis":[47],"process,":[48],"this":[49],"system":[50],"minimizes":[51],"need":[53],"for":[54,104],"manual":[55],"effort":[56],"brings":[58],"increased":[59],"efficiency":[60],"precision":[62],"in":[63,68,107],"analyzing":[64],"issues":[67],"real-time,":[69],"detecting":[70],"errors":[71],"potential":[73],"problems,":[74],"including":[75],"ability":[77],"uncover":[79],"new":[80],"errors.":[81],"Over":[82],"six-month":[84],"period,":[85],"implemented":[87],"dashboard":[88],"was":[89],"able":[90],"process":[92],"logs":[95],"millions":[97],"files":[99],"provide":[101],"valuable":[102],"insights":[103],"stakeholders":[106],"decision-making":[109],"process.":[110]},"counts_by_year":[],"updated_date":"2026-08-21T09:56:20.448147","created_date":"2025-10-10T00:00:00"}