{"id":"https://openalex.org/W4416249387","doi":"https://doi.org/10.1109/ijcnn64981.2025.11227910","title":"HITSQL: Human-In-The-Loop Techniques for Enhancing Text-to-SQL Query Generation with Large Language Models","display_name":"HITSQL: Human-In-The-Loop Techniques for Enhancing Text-to-SQL Query Generation with Large Language Models","publication_year":2025,"publication_date":"2025-06-30","ids":{"openalex":"https://openalex.org/W4416249387","doi":"https://doi.org/10.1109/ijcnn64981.2025.11227910"},"language":null,"primary_location":{"id":"doi:10.1109/ijcnn64981.2025.11227910","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ijcnn64981.2025.11227910","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2025 International Joint Conference on Neural Networks (IJCNN)","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/A5092055177","display_name":"Dhoyazan Al-Turki","orcid":null},"institutions":[{"id":"https://openalex.org/I12870472","display_name":"Birmingham City University","ror":"https://ror.org/00t67pt25","country_code":"GB","type":"education","lineage":["https://openalex.org/I12870472"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Dhoyazan Al-Turki","raw_affiliation_strings":["Birmingham City University,School of Computing and Digital Technology,Birmingham,UK,B4 7XG"],"affiliations":[{"raw_affiliation_string":"Birmingham City University,School of Computing and Digital Technology,Birmingham,UK,B4 7XG","institution_ids":["https://openalex.org/I12870472"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5060045903","display_name":"Shadi Basurra","orcid":"https://orcid.org/0000-0003-2316-094X"},"institutions":[{"id":"https://openalex.org/I12870472","display_name":"Birmingham City University","ror":"https://ror.org/00t67pt25","country_code":"GB","type":"education","lineage":["https://openalex.org/I12870472"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Shadi Basurra","raw_affiliation_strings":["Birmingham City University,School of Computing and Digital Technology,Birmingham,UK,B4 7XG"],"affiliations":[{"raw_affiliation_string":"Birmingham City University,School of Computing and Digital Technology,Birmingham,UK,B4 7XG","institution_ids":["https://openalex.org/I12870472"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5016157034","display_name":"Mohamed Medhat Gaber","orcid":"https://orcid.org/0000-0003-0339-4474"},"institutions":[{"id":"https://openalex.org/I12870472","display_name":"Birmingham City University","ror":"https://ror.org/00t67pt25","country_code":"GB","type":"education","lineage":["https://openalex.org/I12870472"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Mohamed Gaber","raw_affiliation_strings":["Birmingham City University,School of Computing and Digital Technology,Birmingham,UK,B4 7XG"],"affiliations":[{"raw_affiliation_string":"Birmingham City University,School of Computing and Digital Technology,Birmingham,UK,B4 7XG","institution_ids":["https://openalex.org/I12870472"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5120403154","display_name":"Bushra Attasi","orcid":null},"institutions":[{"id":"https://openalex.org/I145019703","display_name":"Al-Zaytoonah University of Jordan","ror":"https://ror.org/04a5b0p13","country_code":"JO","type":"education","lineage":["https://openalex.org/I145019703"]}],"countries":["JO"],"is_corresponding":false,"raw_author_name":"Bushra Attasi","raw_affiliation_strings":["SkyTech LLC,Amman,Jordan"],"affiliations":[{"raw_affiliation_string":"SkyTech LLC,Amman,Jordan","institution_ids":["https://openalex.org/I145019703"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5107806587","display_name":"Mohammed M. Abdelsamea","orcid":"https://orcid.org/0009-0000-5677-6818"},"institutions":[{"id":"https://openalex.org/I23923803","display_name":"University of Exeter","ror":"https://ror.org/03yghzc09","country_code":"GB","type":"education","lineage":["https://openalex.org/I23923803"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Mohammed M. Abdelsamea","raw_affiliation_strings":["University of Exeter,Department of Computer Science,Exeter,UK,EX4 4QF"],"affiliations":[{"raw_affiliation_string":"University of Exeter,Department of Computer Science,Exeter,UK,EX4 4QF","institution_ids":["https://openalex.org/I23923803"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5092055177"],"corresponding_institution_ids":["https://openalex.org/I12870472"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.49406012,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"8"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.18619999289512634,"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"}},"topics":[{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.18619999289512634,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.09000000357627869,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.0794999971985817,"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/sql","display_name":"SQL","score":0.6474000215530396},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.49459999799728394},{"id":"https://openalex.org/keywords/component","display_name":"Component (thermodynamics)","score":0.48649999499320984},{"id":"https://openalex.org/keywords/training-set","display_name":"Training set","score":0.36899998784065247},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.3652999997138977},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.34060001373291016},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.3278000056743622}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8514000177383423},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6474000215530396},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.49459999799728394},{"id":"https://openalex.org/C168167062","wikidata":"https://www.wikidata.org/wiki/Q1117970","display_name":"Component (thermodynamics)","level":2,"score":0.48649999499320984},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4595000147819519},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.37599998712539673},{"id":"https://openalex.org/C51632099","wikidata":"https://www.wikidata.org/wiki/Q3985153","display_name":"Training set","level":2,"score":0.36899998784065247},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.3652999997138977},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3578999936580658},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.35429999232292175},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.34060001373291016},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.3278000056743622},{"id":"https://openalex.org/C137293760","wikidata":"https://www.wikidata.org/wiki/Q3621696","display_name":"Language model","level":2,"score":0.32280001044273376},{"id":"https://openalex.org/C2777960535","wikidata":"https://www.wikidata.org/wiki/Q131508","display_name":"Enterprise resource planning","level":2,"score":0.31779998540878296},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.31679999828338623},{"id":"https://openalex.org/C206345919","wikidata":"https://www.wikidata.org/wiki/Q20380951","display_name":"Resource (disambiguation)","level":2,"score":0.2994000017642975},{"id":"https://openalex.org/C192209626","wikidata":"https://www.wikidata.org/wiki/Q190909","display_name":"Focus (optics)","level":2,"score":0.29490000009536743},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.27070000767707825},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.2687999904155731},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.2637999951839447},{"id":"https://openalex.org/C58489278","wikidata":"https://www.wikidata.org/wiki/Q1172284","display_name":"Data set","level":2,"score":0.2619999945163727}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/ijcnn64981.2025.11227910","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ijcnn64981.2025.11227910","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2025 International Joint Conference on Neural Networks (IJCNN)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W2887966340","https://openalex.org/W2895585783","https://openalex.org/W4312407813","https://openalex.org/W4367185264","https://openalex.org/W4383163609","https://openalex.org/W4387098803","https://openalex.org/W4388551928","https://openalex.org/W4389523781","https://openalex.org/W4396571402","https://openalex.org/W4402683779","https://openalex.org/W4412603362","https://openalex.org/W4413240314","https://openalex.org/W7081978817"],"related_works":[],"abstract_inverted_index":{"This":[0,159],"paper":[1],"presents":[2],"a":[3,162],"novel":[4],"model":[5,68],"we":[6],"called":[7],"HIT-SQL":[8],"to":[9,53,81,89,156,178],"enhance":[10],"text-to-SQL":[11],"query":[12],"generation":[13],"using":[14],"large":[15],"language":[16,168],"models":[17],"(LLMs)":[18],"with":[19,59,116,175],"progressive":[20],"active":[21],"learning.":[22],"HITSQL":[23,44,176],"is":[24],"specifically":[25],"tailored":[26],"for":[27,140,165,170,184],"SAP":[28,36],"Business":[29],"One":[30],"and":[31,50,100,106,136,153,182],"has":[32],"been":[33],"validated":[34],"on":[35,122,147],"HANA":[37],"databases.":[38,142],"Using":[39],"an":[40,60,117],"iterative":[41],"refinement":[42],"process,":[43],"combines":[45],"expert":[46],"feedback,":[47],"systematic":[48],"evaluation,":[49,97,102],"adaptive":[51],"fine-tuning":[52],"achieve":[54],"significant":[55],"performance":[56],"improvements.":[57],"Starting":[58],"initial":[61],"dataset":[62],"of":[63,108,120,130],"20":[64],"training":[65,79],"samples,":[66],"the":[67,78,86,128,131],"iteratively":[69],"incorporated":[70],"180":[71],"evaluation":[72,92],"samples":[73,83],"over":[74],"four":[75],"iterations,":[76],"expanding":[77,148],"set":[80],"200":[82],"while":[84],"reducing":[85],"low-confidence":[87],"pool":[88],"zero.":[90],"The":[91,125],"framework,":[93],"which":[94],"employs":[95],"execution-based":[96],"component":[98],"matching,":[99],"semantic":[101],"ensured":[103],"robust":[104],"assessment":[105],"classification":[107],"SQL":[109,138],"queries.":[110,124],"External":[111],"testing":[112],"demonstrated":[113],"high":[114],"generalisability,":[115],"average":[118],"accuracy":[119],"97%":[121],"unseen":[123],"results":[126],"highlight":[127],"efficacy":[129],"framework":[132],"in":[133],"generating":[134],"reliable":[135],"accurate":[137],"queries":[139],"enterprise":[141,171],"Future":[143],"work":[144],"will":[145],"focus":[146],"datasets,":[149],"automating":[150],"feedback":[151],"mechanisms,":[152],"extending":[154],"applicability":[155],"cross-domain":[157],"environments.":[158],"study":[160],"establishes":[161],"strong":[163],"foundation":[164],"LLM-based":[166],"natural":[167],"interfaces":[169],"resource":[172],"planning":[173],"systems,":[174],"contributing":[177],"improved":[179],"data":[180],"accessibility":[181],"decision-making":[183],"SMEs.":[185]},"counts_by_year":[],"updated_date":"2026-03-07T16:01:11.037858","created_date":"2025-11-14T00:00:00"}