{"id":"https://openalex.org/W4405626360","doi":"https://doi.org/10.48550/arxiv.2412.13679","title":"On Enhancing Root Cause Analysis with SQL Summaries for Failures in Database Workload Replays at SAP HANA","display_name":"On Enhancing Root Cause Analysis with SQL Summaries for Failures in Database Workload Replays at SAP HANA","publication_year":2024,"publication_date":"2024-12-18","ids":{"openalex":"https://openalex.org/W4405626360","doi":"https://doi.org/10.48550/arxiv.2412.13679"},"language":"en","primary_location":{"id":"pmh:oai:arXiv.org:2412.13679","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2412.13679","pdf_url":"https://arxiv.org/pdf/2412.13679","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},"type":"preprint","indexed_in":["arxiv","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2412.13679","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5000654668","display_name":"Neetha Jambigi","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jambigi, Neetha","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5088750471","display_name":"Joshua Hammesfahr","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Hammesfahr, Joshua","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5114971371","display_name":"Moritz Mueller","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mueller, Moritz","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5026267087","display_name":"Thomas Bach","orcid":"https://orcid.org/0000-0002-9993-2814"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Bach, Thomas","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5055476405","display_name":"Michael Felderer","orcid":"https://orcid.org/0000-0003-3818-4442"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Felderer, Michael","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.9890999794006348,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T12127","display_name":"Software System Performance and Reliability","score":0.9890999794006348,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9828000068664551,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.982699990272522,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/workload","display_name":"Workload","score":0.7835765480995178},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7307184934616089},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6730833649635315},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6034015417098999},{"id":"https://openalex.org/keywords/sql-server","display_name":"Sql server","score":0.5391331911087036},{"id":"https://openalex.org/keywords/root-cause-analysis","display_name":"Root cause analysis","score":0.470403254032135},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.19882309436798096},{"id":"https://openalex.org/keywords/reliability-engineering","display_name":"Reliability engineering","score":0.11368995904922485},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.11258190870285034}],"concepts":[{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.7835765480995178},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7307184934616089},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6730833649635315},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6034015417098999},{"id":"https://openalex.org/C2984286706","wikidata":"https://www.wikidata.org/wiki/Q400708","display_name":"Sql server","level":2,"score":0.5391331911087036},{"id":"https://openalex.org/C130963320","wikidata":"https://www.wikidata.org/wiki/Q1401207","display_name":"Root cause analysis","level":2,"score":0.470403254032135},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.19882309436798096},{"id":"https://openalex.org/C200601418","wikidata":"https://www.wikidata.org/wiki/Q2193887","display_name":"Reliability engineering","level":1,"score":0.11368995904922485},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.11258190870285034}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:arXiv.org:2412.13679","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2412.13679","pdf_url":"https://arxiv.org/pdf/2412.13679","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},{"id":"doi:10.48550/arxiv.2412.13679","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2412.13679","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2412.13679","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2412.13679","pdf_url":"https://arxiv.org/pdf/2412.13679","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"text"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":false},"content_urls":{"pdf":"https://content.openalex.org/works/W4405626360.pdf"},"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2110363179","https://openalex.org/W2000785801","https://openalex.org/W986318368","https://openalex.org/W2384410913","https://openalex.org/W2352878646","https://openalex.org/W2004734601","https://openalex.org/W2130149817","https://openalex.org/W2990194547","https://openalex.org/W1480123525","https://openalex.org/W4320802139"],"abstract_inverted_index":{"Capturing":[0],"the":[1,15,48,60,77,93,151,157,183,189,192],"workload":[2,9],"of":[3,14,64,84,92,191],"a":[4,11,53,130],"database":[5,16],"and":[6,140,186],"replaying":[7],"this":[8,103],"for":[10,22,105,163,171],"new":[12,115],"version":[13],"can":[17,45],"be":[18],"an":[19,146],"effective":[20],"approach":[21,169],"regression":[23],"testing.":[24],"However,":[25,69],"false":[26],"positive":[27],"errors":[28],"caused":[29],"by":[30,161],"many":[31],"factors":[32],"such":[33],"as":[34,145],"data":[35,79],"privacy":[36],"limitations,":[37],"time":[38],"dependency":[39],"or":[40],"non-determinism":[41],"in":[42,76],"multi-threaded":[43],"environment":[44],"negatively":[46],"impact":[47],"effectiveness.":[49],"Therefore,":[50],"we":[51,99,128],"employ":[52],"machine":[54,85],"learning":[55,86],"based":[56],"framework":[57],"to":[58,90,101,120,135,149,178,187],"automate":[59],"root":[61,125],"cause":[62],"analysis":[63],"failures":[65,116],"found":[66,75,184],"during":[67],"replays.":[68],"handling":[70],"unseen":[71],"novel":[72],"issues":[73,185],"not":[74],"training":[78],"is":[80,117],"one":[81],"general":[82],"challenge":[83,104],"approaches":[87],"with":[88,114,175],"respect":[89],"generalizability":[91],"learned":[94],"model.":[95],"We":[96,166],"describe":[97],"how":[98],"continue":[100],"address":[102],"more":[106,180],"robust":[107],"long-term":[108],"solutions.":[109],"From":[110],"our":[111,164,168],"experience,":[112],"retraining":[113],"inadequate":[118],"due":[119],"features":[121],"overlapping":[122],"across":[123],"distinct":[124],"causes.":[126],"Hence,":[127],"leverage":[129],"large":[131],"language":[132],"model":[133],"(LLM)":[134],"analyze":[136],"failed":[137],"SQL":[138],"statements":[139],"extract":[141],"concise":[142],"failure":[143],"summaries":[144],"additional":[147,176],"feature":[148],"enhance":[150],"classification":[152],"process.":[153],"Our":[154],"experiments":[155],"show":[156],"F1-Macro":[158],"score":[159],"improved":[160],"4.77%":[162],"data.":[165],"consider":[167],"beneficial":[170],"providing":[172],"end":[173],"users":[174],"information":[177],"gain":[179],"insights":[181],"into":[182],"improve":[188],"assessment":[190],"replay":[193],"results.":[194]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2024-12-21T00:00:00"}