{"id":"https://openalex.org/W4400582692","doi":"https://doi.org/10.1145/3643761","title":"DeSQL: Interactive Debugging of SQL in Data-Intensive Scalable Computing","display_name":"DeSQL: Interactive Debugging of SQL in Data-Intensive Scalable Computing","publication_year":2024,"publication_date":"2024-07-12","ids":{"openalex":"https://openalex.org/W4400582692","doi":"https://doi.org/10.1145/3643761"},"language":"en","primary_location":{"id":"doi:10.1145/3643761","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3643761","pdf_url":null,"source":{"id":"https://openalex.org/S4404663975","display_name":"Proceedings of the ACM on software engineering.","issn_l":"2994-970X","issn":["2994-970X"],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Software Engineering","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://doi.org/10.1145/3643761","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5093759737","display_name":"Sabaat Haroon","orcid":"https://orcid.org/0009-0002-4655-6912"},"institutions":[{"id":"https://openalex.org/I859038795","display_name":"Virginia Tech","ror":"https://ror.org/02smfhw86","country_code":"US","type":"education","lineage":["https://openalex.org/I859038795"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Sabaat Haroon","raw_affiliation_strings":["Virginia Tech, Blacksburg, USA"],"raw_orcid":"https://orcid.org/0009-0002-4655-6912","affiliations":[{"raw_affiliation_string":"Virginia Tech, Blacksburg, USA","institution_ids":["https://openalex.org/I859038795"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101487551","display_name":"Chris Brown","orcid":"https://orcid.org/0000-0002-6036-4733"},"institutions":[{"id":"https://openalex.org/I859038795","display_name":"Virginia Tech","ror":"https://ror.org/02smfhw86","country_code":"US","type":"education","lineage":["https://openalex.org/I859038795"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Chris Brown","raw_affiliation_strings":["Virginia Tech, Blacksburg, USA"],"raw_orcid":"https://orcid.org/0000-0002-6036-4733","affiliations":[{"raw_affiliation_string":"Virginia Tech, Blacksburg, USA","institution_ids":["https://openalex.org/I859038795"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5003747461","display_name":"Muhammad Ali Gulzar","orcid":"https://orcid.org/0000-0002-8007-8662"},"institutions":[{"id":"https://openalex.org/I859038795","display_name":"Virginia Tech","ror":"https://ror.org/02smfhw86","country_code":"US","type":"education","lineage":["https://openalex.org/I859038795"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Muhammad Ali Gulzar","raw_affiliation_strings":["Virginia Tech, Blacksburg, USA"],"raw_orcid":"https://orcid.org/0000-0002-8007-8662","affiliations":[{"raw_affiliation_string":"Virginia Tech, Blacksburg, USA","institution_ids":["https://openalex.org/I859038795"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5093759737"],"corresponding_institution_ids":["https://openalex.org/I859038795"],"apc_list":null,"apc_paid":null,"fwci":1.8862,"has_fulltext":true,"cited_by_count":2,"citation_normalized_percentile":{"value":0.90352258,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":95,"max":96},"biblio":{"volume":"1","issue":"FSE","first_page":"767","last_page":"788"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9998000264167786,"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"}},"topics":[{"id":"https://openalex.org/T11986","display_name":"Scientific Computing and Data Management","score":0.9998000264167786,"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"}},{"id":"https://openalex.org/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.9997000098228455,"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.9988999962806702,"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/computer-science","display_name":"Computer science","score":0.8134467601776123},{"id":"https://openalex.org/keywords/debugging","display_name":"Debugging","score":0.7330424189567566},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6099891066551208},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.5837964415550232},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.5659161806106567},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.5082427859306335},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4631257951259613},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.37563958764076233},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.34214746952056885},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.25628066062927246},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.16703307628631592}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8134467601776123},{"id":"https://openalex.org/C168065819","wikidata":"https://www.wikidata.org/wiki/Q845566","display_name":"Debugging","level":2,"score":0.7330424189567566},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6099891066551208},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5837964415550232},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.5659161806106567},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.5082427859306335},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4631257951259613},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.37563958764076233},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.34214746952056885},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.25628066062927246},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.16703307628631592},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3643761","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3643761","pdf_url":null,"source":{"id":"https://openalex.org/S4404663975","display_name":"Proceedings of the ACM on software engineering.","issn_l":"2994-970X","issn":["2994-970X"],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Software Engineering","raw_type":"journal-article"},{"id":"pmh:oai:vtechworks.lib.vt.edu:10919/120880","is_oa":true,"landing_page_url":"https://hdl.handle.net/10919/120880","pdf_url":"https://vtechworks.lib.vt.edu/bitstreams/a9ec7564-6550-48af-97d2-4a25a1df9a6c/download","source":{"id":"https://openalex.org/S4306400248","display_name":"VTechWorks (Virginia Tech)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I859038795","host_organization_name":"Virginia Tech","host_organization_lineage":["https://openalex.org/I859038795"],"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":null,"raw_type":"Text"}],"best_oa_location":{"id":"doi:10.1145/3643761","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3643761","pdf_url":null,"source":{"id":"https://openalex.org/S4404663975","display_name":"Proceedings of the ACM on software engineering.","issn_l":"2994-970X","issn":["2994-970X"],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Software Engineering","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G975585376","display_name":null,"funder_award_id":"2106420","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":32,"referenced_works":["https://openalex.org/W1964691382","https://openalex.org/W1983178058","https://openalex.org/W2001808951","https://openalex.org/W2024834471","https://openalex.org/W2038412523","https://openalex.org/W2047182010","https://openalex.org/W2072269087","https://openalex.org/W2089745089","https://openalex.org/W2092433005","https://openalex.org/W2098961002","https://openalex.org/W2123304966","https://openalex.org/W2140509629","https://openalex.org/W2173213060","https://openalex.org/W2288788587","https://openalex.org/W2400796894","https://openalex.org/W2401893145","https://openalex.org/W2542459869","https://openalex.org/W2758552291","https://openalex.org/W2789282297","https://openalex.org/W2885090162","https://openalex.org/W2964115955","https://openalex.org/W2986928101","https://openalex.org/W3029646768","https://openalex.org/W3086803357","https://openalex.org/W3086891830","https://openalex.org/W3095119922","https://openalex.org/W3195440983","https://openalex.org/W3210623679","https://openalex.org/W4233502048","https://openalex.org/W4285611945","https://openalex.org/W4365786623","https://openalex.org/W6930138917"],"related_works":["https://openalex.org/W2387821011","https://openalex.org/W637318291","https://openalex.org/W1980548249","https://openalex.org/W2184771611","https://openalex.org/W7869049","https://openalex.org/W1554917839","https://openalex.org/W2614112517","https://openalex.org/W953805165","https://openalex.org/W3142149542","https://openalex.org/W4386768611"],"abstract_inverted_index":{"SQL":[0,30,88,102,139,186,213,231,279],"is":[1],"the":[2,39,74,79,83,94,109,127,171,194,206,216,225,242,281,294],"most":[3],"commonly":[4],"used":[5],"front-end":[6],"language":[7],"for":[8,48,148],"data-intensive":[9],"scalable":[10],"computing":[11],"(DISC)":[12],"applications":[13],"due":[14,156],"to":[15,50,69,92,100,108,120,125,157,177,191,196,255],"its":[16,142],"broad":[17],"presence":[18],"in":[19,55,163,237,253,268,289],"new":[20],"and":[21,24,41,52,77,86,151,161],"legacy":[22],"workflows":[23],"shallow":[25],"learning":[26],"curve.":[27],"However,":[28,155],"DISC-backed":[29],"introduces":[31],"several":[32],"layers":[33],"of":[34,43,73,96,112,129,251],"abstraction":[35],"that":[36,274],"significantly":[37],"reduce":[38],"visibility":[40],"transparency":[42],"workflows,":[44],"making":[45,174],"it":[46,64,175],"challenging":[47,176],"developers":[49],"find":[51,78,273],"fix":[53],"errors":[54],"a":[56,59,66,122,138,166,220,233,261,285],"query.":[57,89],"When":[58],"query":[60,75,135,140,159,168,287],"returns":[61],"incorrect":[62],"outputs,":[63],"takes":[65],"non-trivial":[67],"effort":[68],"comprehend":[70],"every":[71],"stage":[72],"execution":[76],"root":[80,282],"cause":[81,283],"among":[82],"input":[84],"data":[85,218],"complex":[87],"We":[90],"aim":[91],"bring":[93],"benefits":[95],"step-through":[97],"interactive":[98],"debugging":[99,235,270],"DISC-powered":[101],"with":[103,180],"D":[104,131,184,211,229,277],"e":[105,132,185,212,230,278],"SQL.":[106],"Due":[107],"declarative":[110],"nature":[111],"SQL,":[113],"there":[114],"are":[115],"no":[116],"ordered":[117],"atomic":[118],"statements":[119],"place":[121],"break":[123],"point":[124],"monitor":[126],"flow":[128],"data.":[130,154,183,223],"SQL\u2019s":[133],"automated":[134],"decomposition":[136],"breaks":[137],"into":[141],"constituent":[143],"sub-queries,":[144],"offering":[145],"natural":[146],"locations":[147],"setting":[149],"breakpoints":[150],"monitoring":[152],"intermediate":[153,182,198,217],"advanced":[158],"optimization":[160],"translation":[162],"DISC":[164],"systems,":[165],"user":[167,262],"rarely":[169],"matches":[170],"physical":[172],"execution,":[173],"associate":[178],"subqueries":[179,195,203],"their":[181,197],"performs":[187],"fine-grained":[188],"taint":[189],"analysis":[190],"dynamically":[192],"map":[193],"data,":[199],"while":[200,246],"also":[201],"recognizing":[202],"removed":[204],"by":[205],"optimizers.":[207],"For":[208],"such":[209],"subqueries,":[210],"efficiently":[214],"regenerates":[215],"from":[219],"nearby":[221],"subquery\u2019s":[222],"On":[224],"popular":[226],"TPC-DC":[227],"benchmark,":[228],"provides":[232],"complete":[234],"view":[236],"13%":[238],"less":[239,291],"time":[240,245,292],"than":[241,293],"original":[243],"job":[244],"incurring":[247],"an":[248],"average":[249],"overhead":[250],"10%":[252],"addition":[254],"retaining":[256],"Apache":[257],"Spark\u2019s":[258],"scalability.":[259],"In":[260],"study":[263],"comprising":[264],"15":[265],"participants":[266,275],"engaged":[267],"two":[269],"tasks,":[271],"we":[272],"utilizing":[276],"identify":[280],"behind":[284],"wrong":[286],"output":[288],"74%":[290],"de-facto,":[295],"manual":[296],"debugging.":[297]},"counts_by_year":[{"year":2025,"cited_by_count":2}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}