{"id":"https://openalex.org/W7162466949","doi":"https://doi.org/10.1145/3788853.3801613","title":"Root-Cause Diagnosis with Remediation Recommendations for ETL Pipelines via LLM-Based Reasoning","display_name":"Root-Cause Diagnosis with Remediation Recommendations for ETL Pipelines via LLM-Based Reasoning","publication_year":2026,"publication_date":"2026-05-26","ids":{"openalex":"https://openalex.org/W7162466949","doi":"https://doi.org/10.1145/3788853.3801613"},"language":null,"primary_location":{"id":"doi:10.1145/3788853.3801613","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3788853.3801613","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5035470346","display_name":"Deepak Vijaykeerthy","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Deepak Vijaykeerthy","raw_affiliation_strings":["IBM Research, Bengaluru, India"],"raw_orcid":"https://orcid.org/0009-0003-0398-5052","affiliations":[{"raw_affiliation_string":"IBM Research, Bengaluru, India","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5137055196","display_name":"Rajmohan C","orcid":"https://orcid.org/0000-0002-0832-4689"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Rajmohan C","raw_affiliation_strings":["IBM Research, Bengaluru, India"],"raw_orcid":"https://orcid.org/0000-0002-0832-4689","affiliations":[{"raw_affiliation_string":"IBM Research, Bengaluru, India","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102883954","display_name":"Arvind Agarwal","orcid":"https://orcid.org/0000-0002-0715-4972"},"institutions":[{"id":"https://openalex.org/I4210103279","display_name":"IBM Research - India","ror":"https://ror.org/014wt7r80","country_code":"IN","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210103279","https://openalex.org/I4210114115"]}],"countries":["IN"],"is_corresponding":false,"raw_author_name":"Arvind Agarwal","raw_affiliation_strings":["IBM Research, Gurgaon, India"],"raw_orcid":"https://orcid.org/0000-0002-0715-4972","affiliations":[{"raw_affiliation_string":"IBM Research, Gurgaon, India","institution_ids":["https://openalex.org/I4210103279"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5137007790","display_name":"Avirup Saha","orcid":"https://orcid.org/0000-0002-5014-3582"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Avirup Saha","raw_affiliation_strings":["IBM Research, Bengaluru, India"],"raw_orcid":"https://orcid.org/0000-0002-5014-3582","affiliations":[{"raw_affiliation_string":"IBM Research, Bengaluru, India","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5046646390","display_name":"Sameep Mehta","orcid":"https://orcid.org/0000-0002-9599-1526"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Sameep Mehta","raw_affiliation_strings":["IBM Research, Bengaluru, India"],"raw_orcid":"https://orcid.org/0000-0002-9599-1526","affiliations":[{"raw_affiliation_string":"IBM Research, Bengaluru, India","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5137056622","display_name":"Emmanuel Adhoute","orcid":"https://orcid.org/0009-0003-1461-1136"},"institutions":[{"id":"https://openalex.org/I4210143846","display_name":"Israel Cancer Association","ror":"https://ror.org/03yxd7304","country_code":"IL","type":"nonprofit","lineage":["https://openalex.org/I4210143846"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Emmanuel Adhoute","raw_affiliation_strings":["IBM Software, Givatayim, Israel"],"raw_orcid":"https://orcid.org/0009-0003-1461-1136","affiliations":[{"raw_affiliation_string":"IBM Software, Givatayim, Israel","institution_ids":["https://openalex.org/I4210143846"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5137002696","display_name":"Nadav Vahav","orcid":"https://orcid.org/0009-0004-3853-8591"},"institutions":[{"id":"https://openalex.org/I4210143846","display_name":"Israel Cancer Association","ror":"https://ror.org/03yxd7304","country_code":"IL","type":"nonprofit","lineage":["https://openalex.org/I4210143846"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Nadav Vahav","raw_affiliation_strings":["IBM Software, Givatayim, Israel"],"raw_orcid":"https://orcid.org/0009-0004-3853-8591","affiliations":[{"raw_affiliation_string":"IBM Software, Givatayim, Israel","institution_ids":["https://openalex.org/I4210143846"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5137083779","display_name":"Timur Porokhnia","orcid":"https://orcid.org/0009-0000-7455-8427"},"institutions":[{"id":"https://openalex.org/I4210158857","display_name":"VoicePIN.com (Poland)","ror":"https://ror.org/0571pz015","country_code":"PL","type":"company","lineage":["https://openalex.org/I4210158857"]}],"countries":["PL"],"is_corresponding":false,"raw_author_name":"Timur Porokhnia","raw_affiliation_strings":["IBM Software, Krakow, Poland"],"raw_orcid":"https://orcid.org/0009-0000-7455-8427","affiliations":[{"raw_affiliation_string":"IBM Software, Krakow, Poland","institution_ids":["https://openalex.org/I4210158857"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5137037411","display_name":"Adrian D\u0105browski","orcid":"https://orcid.org/0009-0001-7801-6075"},"institutions":[{"id":"https://openalex.org/I4210158857","display_name":"VoicePIN.com (Poland)","ror":"https://ror.org/0571pz015","country_code":"PL","type":"company","lineage":["https://openalex.org/I4210158857"]}],"countries":["PL"],"is_corresponding":false,"raw_author_name":"Adrian D\u0105browski","raw_affiliation_strings":["IBM Software, Krakow, Poland"],"raw_orcid":"https://orcid.org/0009-0001-7801-6075","affiliations":[{"raw_affiliation_string":"IBM Software, Krakow, Poland","institution_ids":["https://openalex.org/I4210158857"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5137048290","display_name":"Bat El Aharon Asher","orcid":"https://orcid.org/0009-0001-4469-1443"},"institutions":[{"id":"https://openalex.org/I4210143846","display_name":"Israel Cancer Association","ror":"https://ror.org/03yxd7304","country_code":"IL","type":"nonprofit","lineage":["https://openalex.org/I4210143846"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Bat El Aharon Asher","raw_affiliation_strings":["IBM Software, Givatayim, Israel"],"raw_orcid":"https://orcid.org/0009-0001-4469-1443","affiliations":[{"raw_affiliation_string":"IBM Software, Givatayim, Israel","institution_ids":["https://openalex.org/I4210143846"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5137055714","display_name":"Aviya Goldfarb","orcid":"https://orcid.org/0009-0004-8478-6932"},"institutions":[{"id":"https://openalex.org/I4210143846","display_name":"Israel Cancer Association","ror":"https://ror.org/03yxd7304","country_code":"IL","type":"nonprofit","lineage":["https://openalex.org/I4210143846"]}],"countries":["IL"],"is_corresponding":false,"raw_author_name":"Aviya Goldfarb","raw_affiliation_strings":["IBM Software, Givatayim, Israel"],"raw_orcid":"https://orcid.org/0009-0004-8478-6932","affiliations":[{"raw_affiliation_string":"IBM Software, Givatayim, Israel","institution_ids":["https://openalex.org/I4210143846"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":11,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.84811158,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"126","last_page":"129"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11303","display_name":"Bayesian Modeling and Causal Inference","score":0.14830000698566437,"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"}},"topics":[{"id":"https://openalex.org/T11303","display_name":"Bayesian Modeling and Causal Inference","score":0.14830000698566437,"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"}},{"id":"https://openalex.org/T12086","display_name":"Structural Integrity and Reliability Analysis","score":0.035100001841783524,"subfield":{"id":"https://openalex.org/subfields/2210","display_name":"Mechanical Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11357","display_name":"Risk and Safety Analysis","score":0.03139999881386757,"subfield":{"id":"https://openalex.org/subfields/1804","display_name":"Statistics, Probability and Uncertainty"},"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/pipeline-transport","display_name":"Pipeline transport","score":0.5978000164031982},{"id":"https://openalex.org/keywords/pipeline","display_name":"Pipeline (software)","score":0.3481000065803528},{"id":"https://openalex.org/keywords/environmental-remediation","display_name":"Environmental remediation","score":0.303600013256073},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.27379998564720154}],"concepts":[{"id":"https://openalex.org/C175309249","wikidata":"https://www.wikidata.org/wiki/Q725864","display_name":"Pipeline transport","level":2,"score":0.5978000164031982},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.4546999931335449},{"id":"https://openalex.org/C43521106","wikidata":"https://www.wikidata.org/wiki/Q2165493","display_name":"Pipeline (software)","level":2,"score":0.3481000065803528},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.3328999876976013},{"id":"https://openalex.org/C39432304","wikidata":"https://www.wikidata.org/wiki/Q188847","display_name":"Environmental science","level":0,"score":0.3133000135421753},{"id":"https://openalex.org/C522964758","wikidata":"https://www.wikidata.org/wiki/Q2019586","display_name":"Environmental remediation","level":3,"score":0.303600013256073},{"id":"https://openalex.org/C107053488","wikidata":"https://www.wikidata.org/wiki/Q2674423","display_name":"Construction engineering","level":1,"score":0.3025999963283539},{"id":"https://openalex.org/C201995342","wikidata":"https://www.wikidata.org/wiki/Q682496","display_name":"Systems engineering","level":1,"score":0.2743000090122223},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.27379998564720154},{"id":"https://openalex.org/C77595967","wikidata":"https://www.wikidata.org/wiki/Q3151013","display_name":"Forensic engineering","level":1,"score":0.2702000141143799}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3788853.3801613","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3788853.3801613","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W3032244227","https://openalex.org/W4389418086","https://openalex.org/W4393213222","https://openalex.org/W4394946189","https://openalex.org/W4411551762"],"related_works":[],"abstract_inverted_index":null,"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2026-05-27T00:00:00"}
