{"id":"https://openalex.org/W4410538573","doi":"https://doi.org/10.14778/3717755.3717772","title":"Sphinteract: Resolving Ambiguities in NL2SQL through User Interaction","display_name":"Sphinteract: Resolving Ambiguities in NL2SQL through User Interaction","publication_year":2024,"publication_date":"2024-12-01","ids":{"openalex":"https://openalex.org/W4410538573","doi":"https://doi.org/10.14778/3717755.3717772"},"language":"en","primary_location":{"id":"doi:10.14778/3717755.3717772","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3717755.3717772","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5020064057","display_name":"Fuheng Zhao","orcid":null},"institutions":[{"id":"https://openalex.org/I154570441","display_name":"University of California, Santa Barbara","ror":"https://ror.org/02t274463","country_code":"US","type":"education","lineage":["https://openalex.org/I154570441"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Fuheng Zhao","raw_affiliation_strings":["UC Santa Barbara"],"affiliations":[{"raw_affiliation_string":"UC Santa Barbara","institution_ids":["https://openalex.org/I154570441"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5036934715","display_name":"Shaleen Deep","orcid":"https://orcid.org/0000-0003-2342-4060"},"institutions":[{"id":"https://openalex.org/I4210164937","display_name":"Microsoft Research (United Kingdom)","ror":"https://ror.org/05k87vq12","country_code":"GB","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Shaleen Deep","raw_affiliation_strings":["Microsoft"],"affiliations":[{"raw_affiliation_string":"Microsoft","institution_ids":["https://openalex.org/I4210164937"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5059914414","display_name":"Fotis Psallidas","orcid":null},"institutions":[{"id":"https://openalex.org/I4210164937","display_name":"Microsoft Research (United Kingdom)","ror":"https://ror.org/05k87vq12","country_code":"GB","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Fotis Psallidas","raw_affiliation_strings":["Microsoft"],"affiliations":[{"raw_affiliation_string":"Microsoft","institution_ids":["https://openalex.org/I4210164937"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5020678151","display_name":"Avrilia Floratou","orcid":"https://orcid.org/0009-0007-5760-8657"},"institutions":[{"id":"https://openalex.org/I4210164937","display_name":"Microsoft Research (United Kingdom)","ror":"https://ror.org/05k87vq12","country_code":"GB","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Avrilia Floratou","raw_affiliation_strings":["Microsoft"],"affiliations":[{"raw_affiliation_string":"Microsoft","institution_ids":["https://openalex.org/I4210164937"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5098190003","display_name":"Divyakant Agrawal","orcid":null},"institutions":[{"id":"https://openalex.org/I154570441","display_name":"University of California, Santa Barbara","ror":"https://ror.org/02t274463","country_code":"US","type":"education","lineage":["https://openalex.org/I154570441"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Divyakant Agrawal","raw_affiliation_strings":["UC Santa Barbara"],"affiliations":[{"raw_affiliation_string":"UC Santa Barbara","institution_ids":["https://openalex.org/I154570441"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5039292004","display_name":"Amr El Abbadi","orcid":"https://orcid.org/0000-0003-4692-3268"},"institutions":[{"id":"https://openalex.org/I154570441","display_name":"University of California, Santa Barbara","ror":"https://ror.org/02t274463","country_code":"US","type":"education","lineage":["https://openalex.org/I154570441"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Amr El Abbadi","raw_affiliation_strings":["UC Santa Barbara"],"affiliations":[{"raw_affiliation_string":"UC Santa Barbara","institution_ids":["https://openalex.org/I154570441"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5020064057"],"corresponding_institution_ids":["https://openalex.org/I154570441"],"apc_list":null,"apc_paid":null,"fwci":0.3641,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.71962679,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":91,"max":95},"biblio":{"volume":"18","issue":"4","first_page":"1145","last_page":"1158"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.9918000102043152,"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/T10028","display_name":"Topic Modeling","score":0.9918000102043152,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9847999811172485,"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/T10456","display_name":"Multi-Agent Systems and Negotiation","score":0.9785000085830688,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.4646334946155548},{"id":"https://openalex.org/keywords/human\u2013computer-interaction","display_name":"Human\u2013computer interaction","score":0.45401349663734436}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.4646334946155548},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.45401349663734436}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3717755.3717772","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3717755.3717772","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"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":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":33,"referenced_works":["https://openalex.org/W2159934185","https://openalex.org/W2165382777","https://openalex.org/W2269738476","https://openalex.org/W2502801113","https://openalex.org/W2536574992","https://openalex.org/W2762513422","https://openalex.org/W2801426799","https://openalex.org/W2886362482","https://openalex.org/W2890431379","https://openalex.org/W2896457183","https://openalex.org/W2963477458","https://openalex.org/W2970393840","https://openalex.org/W2981852735","https://openalex.org/W3034835156","https://openalex.org/W3046744391","https://openalex.org/W3133702157","https://openalex.org/W3169611685","https://openalex.org/W3176472386","https://openalex.org/W4283733706","https://openalex.org/W4288089799","https://openalex.org/W4317553049","https://openalex.org/W4317716303","https://openalex.org/W4385270687","https://openalex.org/W4386128198","https://openalex.org/W4387835442","https://openalex.org/W4389520086","https://openalex.org/W4389520756","https://openalex.org/W4392453936","https://openalex.org/W4393160302","https://openalex.org/W4396571402","https://openalex.org/W4399208468","https://openalex.org/W4399452982","https://openalex.org/W4404181195"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W4391913857","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052"],"abstract_inverted_index":{"Translating":[0],"natural":[1,59],"language":[2,60],"questions":[3,61,123,164],"into":[4,97],"SQL":[5,80,142],"queries":[6,143],"(NL2SQL)":[7],"is":[8,53,94],"a":[9,47,71],"challenging":[10,49,152],"task":[11],"of":[12,134,161,178],"great":[13],"practical":[14],"importance.":[15],"Prior":[16],"work":[17],"has":[18],"extensively":[19],"studied":[20],"how":[21,135],"to":[22,37,74,91,95,127,136,165,180],"address":[23],"NL2SQL":[24,52,118],"using":[25],"Large":[26],"Language":[27],"Models":[28],"(LLMs)":[29],"with":[30],"solutions":[31],"ranging":[32],"from":[33],"careful":[34],"prompt":[35],"engineering,":[36],"fine-tuning":[38],"existing":[39],"LLMs,":[40],"or":[41],"even":[42],"training":[43],"custom":[44],"models.":[45],"However,":[46],"remaining":[48],"problem":[50],"in":[51,57,77,114,117,175],"the":[54,58,85,105,125,151,166,172],"inherent":[55],"ambiguity":[56,93],"asked":[62],"by":[63,159],"users.":[64],"In":[65],"this":[66],"paper,":[67],"we":[68],"introduce":[69,104],"Sphinteract,":[70],"framework":[72],"designed":[73],"assist":[75],"LLMs":[76,113,168],"generating":[78],"high-quality":[79],"answers":[81],"that":[82,158],"accurately":[83],"reflect":[84],"user":[86,100,126,138,146],"intent.":[87],"Our":[88,148],"key":[89],"insight":[90],"resolve":[92],"take":[96],"account":[98],"minimal":[99],"feedback":[101,139],"interactively.":[102],"We":[103,129],"Summarize,":[106],"Review,":[107],"Ask":[108],"(SRA)":[109],"paradigm,":[110],"which":[111],"guides":[112],"identifying":[115],"ambiguities":[116],"tasks":[119],"and":[120,140,154],"generates":[121],"targeted":[122],"for":[124],"answer.":[128],"propose":[130],"three":[131],"different":[132],"methods":[133],"process":[137],"generate":[141],"based":[144],"on":[145,150],"input.":[147],"experiments":[149],"KaggleDBQA":[153],"BIRD":[155],"benchmarks":[156],"demonstrate":[157],"means":[160],"asking":[162],"clarification":[163],"user,":[167],"can":[169],"efficiently":[170],"incorporate":[171],"feedback,":[173],"resulting":[174],"accuracy":[176],"improvements":[177],"up":[179],"42%.":[181]},"counts_by_year":[{"year":2025,"cited_by_count":1}],"updated_date":"2026-03-09T08:58:05.943551","created_date":"2025-10-10T00:00:00"}