{"id":"https://openalex.org/W4409862577","doi":"https://doi.org/10.1016/j.ipm.2025.104136","title":"Optimizing text-to-SQL conversion techniques through the integration of intelligent agents and large language models","display_name":"Optimizing text-to-SQL conversion techniques through the integration of intelligent agents and large language models","publication_year":2025,"publication_date":"2025-04-27","ids":{"openalex":"https://openalex.org/W4409862577","doi":"https://doi.org/10.1016/j.ipm.2025.104136"},"language":"en","primary_location":{"id":"doi:10.1016/j.ipm.2025.104136","is_oa":true,"landing_page_url":"https://doi.org/10.1016/j.ipm.2025.104136","pdf_url":null,"source":{"id":"https://openalex.org/S174847851","display_name":"Information Processing & Management","issn_l":"0306-4573","issn":["0306-4573","1873-5371"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Processing & Management","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://doi.org/10.1016/j.ipm.2025.104136","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5117349618","display_name":"Samuel Ojuri","orcid":null},"institutions":[{"id":"https://openalex.org/I874055015","display_name":"Teesside University","ror":"https://ror.org/03z28gk75","country_code":"GB","type":"education","lineage":["https://openalex.org/I874055015"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Samuel Ojuri","raw_affiliation_strings":["School of Computing, Engineering and Digital Technologies, Teesside University, Middlesbrough, United Kingdom"],"raw_orcid":"https://orcid.org/0009-0004-0880-5601","affiliations":[{"raw_affiliation_string":"School of Computing, Engineering and Digital Technologies, Teesside University, Middlesbrough, United Kingdom","institution_ids":["https://openalex.org/I874055015"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5012915897","display_name":"The Anh Han","orcid":"https://orcid.org/0000-0002-3095-7714"},"institutions":[{"id":"https://openalex.org/I874055015","display_name":"Teesside University","ror":"https://ror.org/03z28gk75","country_code":"GB","type":"education","lineage":["https://openalex.org/I874055015"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"The Anh Han","raw_affiliation_strings":["School of Computing, Engineering and Digital Technologies, Teesside University, Middlesbrough, United Kingdom"],"raw_orcid":"https://orcid.org/0000-0002-3095-7714","affiliations":[{"raw_affiliation_string":"School of Computing, Engineering and Digital Technologies, Teesside University, Middlesbrough, United Kingdom","institution_ids":["https://openalex.org/I874055015"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027845071","display_name":"Raymond Chiong","orcid":"https://orcid.org/0000-0002-8285-1903"},"institutions":[{"id":"https://openalex.org/I4210116964","display_name":"New South Wales Institute of Psychiatry","ror":"https://ror.org/02fjxcw19","country_code":"AU","type":"education","lineage":["https://openalex.org/I4210116964"]},{"id":"https://openalex.org/I78757542","display_name":"University of Newcastle Australia","ror":"https://ror.org/00eae9z71","country_code":"AU","type":"education","lineage":["https://openalex.org/I78757542"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Raymond Chiong","raw_affiliation_strings":["School of Information and Physical Sciences, The University of Newcastle, Callaghan, Australia","School of Science and Technology, The University of New England, Parramatta, Australia"],"raw_orcid":"https://orcid.org/0000-0002-8285-1903","affiliations":[{"raw_affiliation_string":"School of Information and Physical Sciences, The University of Newcastle, Callaghan, Australia","institution_ids":["https://openalex.org/I78757542"]},{"raw_affiliation_string":"School of Science and Technology, The University of New England, Parramatta, Australia","institution_ids":["https://openalex.org/I4210116964"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5052537136","display_name":"Alessandro Di Stefano","orcid":"https://orcid.org/0000-0003-4905-3309"},"institutions":[{"id":"https://openalex.org/I874055015","display_name":"Teesside University","ror":"https://ror.org/03z28gk75","country_code":"GB","type":"education","lineage":["https://openalex.org/I874055015"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Alessandro Di Stefano","raw_affiliation_strings":["School of Computing, Engineering and Digital Technologies, Teesside University, Middlesbrough, United Kingdom"],"raw_orcid":"https://orcid.org/0000-0003-4905-3309","affiliations":[{"raw_affiliation_string":"School of Computing, Engineering and Digital Technologies, Teesside University, Middlesbrough, United Kingdom","institution_ids":["https://openalex.org/I874055015"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5052537136"],"corresponding_institution_ids":["https://openalex.org/I874055015"],"apc_list":{"value":3220,"currency":"USD","value_usd":3220},"apc_paid":{"value":3220,"currency":"USD","value_usd":3220},"fwci":34.1528,"has_fulltext":true,"cited_by_count":19,"citation_normalized_percentile":{"value":0.99658755,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":99,"max":100},"biblio":{"volume":"62","issue":"5","first_page":"104136","last_page":"104136"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10028","display_name":"Topic Modeling","score":0.9771000146865845,"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.9771000146865845,"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/T10679","display_name":"Service-Oriented Architecture and Web Services","score":0.9631999731063843,"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/T10456","display_name":"Multi-Agent Systems and Negotiation","score":0.9455999732017517,"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.7517348527908325},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.618223249912262},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.43732360005378723},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.42416250705718994},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.41075050830841064},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.32092875242233276}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7517348527908325},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.618223249912262},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.43732360005378723},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.42416250705718994},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.41075050830841064},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.32092875242233276}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1016/j.ipm.2025.104136","is_oa":true,"landing_page_url":"https://doi.org/10.1016/j.ipm.2025.104136","pdf_url":null,"source":{"id":"https://openalex.org/S174847851","display_name":"Information Processing & Management","issn_l":"0306-4573","issn":["0306-4573","1873-5371"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Processing & Management","raw_type":"journal-article"},{"id":"pmh:oai:rune.une.edu.au:1959.11/70690","is_oa":true,"landing_page_url":"https://hdl.handle.net/1959.11/70690","pdf_url":"https://rune.une.edu.au/bitstreams/41c58d28-e560-4aca-9ca4-c66fab5bd43c/download","source":{"id":"https://openalex.org/S7407055448","display_name":"RUNE (Research UNE)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"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":"Journal Article"},{"id":"pmh:oai:https://research.tees.ac.uk/ws/oai:openaire_cris_publications/30f6840f-ebca-4dc8-8cbd-4be77b2abf07","is_oa":true,"landing_page_url":"https://research.tees.ac.uk/en/publications/30f6840f-ebca-4dc8-8cbd-4be77b2abf07","pdf_url":"https://research.tees.ac.uk/ws/files/98256860/95907597.pdf","source":{"id":"https://openalex.org/S4306402475","display_name":"Teesside University Research Portal (Teesside University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I874055015","host_organization_name":"Teesside University","host_organization_lineage":["https://openalex.org/I874055015"],"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":"Ojuri, S, Han, T A, Chiong, R & Di Stefano, A 2025, 'Optimizing text-to-SQL conversion techniques through the integration of intelligent agents and large language models', Information Processing and Management, vol. 62, no. 5, 104136. https://doi.org/10.1016/j.ipm.2025.104136","raw_type":"info:eu-repo/semantics/publishedVersion"}],"best_oa_location":{"id":"doi:10.1016/j.ipm.2025.104136","is_oa":true,"landing_page_url":"https://doi.org/10.1016/j.ipm.2025.104136","pdf_url":null,"source":{"id":"https://openalex.org/S174847851","display_name":"Information Processing & Management","issn_l":"0306-4573","issn":["0306-4573","1873-5371"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320990","host_organization_name":"Elsevier BV","host_organization_lineage":["https://openalex.org/P4310320990"],"host_organization_lineage_names":["Elsevier BV"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Information Processing & Management","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G4237802725","display_name":"Evolutionary Game Theory Under Uncertainty","funder_award_id":"EP/Y00857X/1","funder_id":"https://openalex.org/F4320334627","funder_display_name":"Engineering and Physical Sciences Research Council"}],"funders":[{"id":"https://openalex.org/F4320334627","display_name":"Engineering and Physical Sciences Research Council","ror":"https://ror.org/0439y7842"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":37,"referenced_works":["https://openalex.org/W2599674900","https://openalex.org/W3101007570","https://openalex.org/W3102020135","https://openalex.org/W4286447321","https://openalex.org/W4292779060","https://openalex.org/W4304195432","https://openalex.org/W4322766882","https://openalex.org/W4323709074","https://openalex.org/W4360825313","https://openalex.org/W4366148812","https://openalex.org/W4382202531","https://openalex.org/W4383665181","https://openalex.org/W4384341905","https://openalex.org/W4385569970","https://openalex.org/W4386711999","https://openalex.org/W4386794445","https://openalex.org/W4387559744","https://openalex.org/W4388654530","https://openalex.org/W4389217347","https://openalex.org/W4390639297","https://openalex.org/W4390990236","https://openalex.org/W4391020701","https://openalex.org/W4391136507","https://openalex.org/W4391457536","https://openalex.org/W4391973028","https://openalex.org/W4392768505","https://openalex.org/W4392866984","https://openalex.org/W4393131873","https://openalex.org/W6750574679","https://openalex.org/W6763274620","https://openalex.org/W6777144453","https://openalex.org/W6778883912","https://openalex.org/W6851570467","https://openalex.org/W6853006304","https://openalex.org/W6853832984","https://openalex.org/W6854372778","https://openalex.org/W6860020858"],"related_works":["https://openalex.org/W1592149428","https://openalex.org/W650213220","https://openalex.org/W3204019825","https://openalex.org/W1980548249","https://openalex.org/W3092022493","https://openalex.org/W2183714398","https://openalex.org/W2042813897","https://openalex.org/W2340883001","https://openalex.org/W4382050951","https://openalex.org/W2079321164"],"abstract_inverted_index":{"In":[0],"many":[1],"organizations,":[2],"retrieving":[3],"valuable":[4],"information":[5],"from":[6],"complex":[7],"databases":[8,43],"has":[9],"traditionally":[10],"required":[11],"specialized":[12],"technical":[13,160],"skills,":[14],"often":[15],"leaving":[16],"non-technical":[17],"professionals":[18],"dependent":[19],"on":[20,90,124,159,181],"others":[21],"for":[22,127,201,224],"timely":[23],"insights.":[24],"This":[25,132],"study":[26],"presents":[27],"an":[28],"approach":[29],"that":[30,72,107,208],"allows":[31],"anyone,":[32],"even":[33],"without":[34],"knowledge":[35],"of":[36,102,138],"query":[37],"languages,":[38],"to":[39,146,154],"directly":[40],"interact":[41],"with":[42,68,111,150],"by":[44,53,98],"asking":[45],"questions":[46],"in":[47],"everyday":[48],"language.":[49],"We":[50,195],"achieve":[51],"this":[52],"combining":[54],"advanced":[55],"generative":[56],"language":[57,75,186],"models,":[58],"such":[59],"as":[60],"a":[61,91,100,109,171],"high-capacity":[62],"Generative":[63],"Pre-trained":[64],"Transformer":[65],"(GPT)":[66],"model,":[67],"intelligent":[69,199],"software":[70],"agents":[71,200],"translate":[73],"natural":[74],"queries":[76,120],"into":[77],"precise":[78],"SQL":[79,226],"statements.":[80],"Our":[81],"evaluation":[82],"compares":[83],"different":[84],"strategies,":[85],"including":[86],"models":[87,187],"specifically":[88],"trained":[89],"particular":[92],"database":[93,119],"domain":[94],"versus":[95],"those":[96],"guided":[97],"only":[99],"handful":[101],"examples.":[103],"The":[104],"results":[105],"show":[106,207],"training":[108],"model":[110,140,231],"tailored":[112],"examples":[113],"yields":[114],"more":[115,166,172],"accurate":[116],"and":[117,142,169,198,210,215,234],"reliable":[118],"than":[121],"relying":[122],"solely":[123],"minimal":[125],"guidance":[126],"the":[128,135],"given":[129],"use":[130],"case.":[131],"work":[133],"highlights":[134],"practical":[136],"value":[137],"refining":[139],"complexity":[141],"balancing":[143],"computational":[144],"costs":[145],"empower":[147],"business":[148,192],"users":[149],"easy,":[151],"direct":[152],"access":[153],"data.":[155],"By":[156],"reducing":[157],"reliance":[158],"teams,":[161],"organizations":[162],"can":[163,177,189],"enable":[164],"faster,":[165],"informed":[167],"decision-making":[168],"foster":[170],"inclusive":[173],"environment":[174],"where":[175],"everyone":[176],"uncover":[178],"data-driven":[179],"insights":[180],"their":[182],"own.":[183],"\u2022":[184,194,205,218,228],"Large":[185],"(LLMs)":[188],"enhance":[190],"real-time":[191],"analytics.":[193],"integrate":[196],"LLMs":[197],"text-to-SQL":[202],"conversion":[203],"optimization.":[204],"Results":[206],"GPT-4":[209],"Llama-3.3-70B-Instruct-Turbo":[211],"demonstrate":[212],"superior":[213],"syntax":[214],"semantic":[216],"understanding.":[217],"Model":[219],"fine-tuning":[220],"outperforms":[221],"few-shot":[222],"learning":[223],"domain-specific":[225],"generation.":[227],"Balance":[229],"between":[230],"sophistication,":[232],"cost,":[233],"enterprise":[235],"usability":[236],"is":[237],"crucial.":[238]},"counts_by_year":[{"year":2026,"cited_by_count":12},{"year":2025,"cited_by_count":7}],"updated_date":"2026-06-06T09:05:17.133730","created_date":"2025-10-10T00:00:00"}