{"id":"https://openalex.org/W4415427424","doi":"https://doi.org/10.3233/faia251458","title":"The Quest for an LLM-Based Natural Language Interface for an Industrial Database","display_name":"The Quest for an LLM-Based Natural Language Interface for an Industrial Database","publication_year":2025,"publication_date":"2025-10-21","ids":{"openalex":"https://openalex.org/W4415427424","doi":"https://doi.org/10.3233/faia251458"},"language":null,"primary_location":{"id":"doi:10.3233/faia251458","is_oa":true,"landing_page_url":"https://doi.org/10.3233/faia251458","pdf_url":null,"source":{"id":"https://openalex.org/S4210201731","display_name":"Frontiers in artificial intelligence and applications","issn_l":"0922-6389","issn":["0922-6389","1879-8314"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers in Artificial Intelligence and Applications","raw_type":"book-chapter"},"type":"book-chapter","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://doi.org/10.3233/faia251458","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5042902878","display_name":"Melissa Lemos","orcid":"https://orcid.org/0000-0003-1723-9897"},"institutions":[{"id":"https://openalex.org/I2699952","display_name":"Pontif\u00edcia Universidade Cat\u00f3lica do Rio de Janeiro","ror":"https://ror.org/01dg47b60","country_code":"BR","type":"education","lineage":["https://openalex.org/I2699952"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Melissa Lemos","raw_affiliation_strings":["Department of Informatics, PUC-Rio \u2013 Rio de Janeiro, RJ \u2013 Brazil","Tecgraf Institute, PUC-Rio \u2013 Rio de Janeiro, RJ \u2013 Brazil"],"raw_orcid":"https://orcid.org/0000-0003-1723-9897","affiliations":[{"raw_affiliation_string":"Department of Informatics, PUC-Rio \u2013 Rio de Janeiro, RJ \u2013 Brazil","institution_ids":["https://openalex.org/I2699952"]},{"raw_affiliation_string":"Tecgraf Institute, PUC-Rio \u2013 Rio de Janeiro, RJ \u2013 Brazil","institution_ids":["https://openalex.org/I2699952"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042227828","display_name":"Yenier Torres Izquierdo","orcid":"https://orcid.org/0000-0003-0971-8572"},"institutions":[{"id":"https://openalex.org/I2699952","display_name":"Pontif\u00edcia Universidade Cat\u00f3lica do Rio de Janeiro","ror":"https://ror.org/01dg47b60","country_code":"BR","type":"education","lineage":["https://openalex.org/I2699952"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Yenier T. Izquierdo","raw_affiliation_strings":["Tecgraf Institute, PUC-Rio \u2013 Rio de Janeiro, RJ \u2013 Brazil"],"raw_orcid":"https://orcid.org/0000-0003-0971-8572","affiliations":[{"raw_affiliation_string":"Tecgraf Institute, PUC-Rio \u2013 Rio de Janeiro, RJ \u2013 Brazil","institution_ids":["https://openalex.org/I2699952"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5041556518","display_name":"Grettel Monteagudo Garc\u00eda","orcid":"https://orcid.org/0000-0001-9713-300X"},"institutions":[{"id":"https://openalex.org/I2699952","display_name":"Pontif\u00edcia Universidade Cat\u00f3lica do Rio de Janeiro","ror":"https://ror.org/01dg47b60","country_code":"BR","type":"education","lineage":["https://openalex.org/I2699952"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Grettel M. Garc\u00eda","raw_affiliation_strings":["Tecgraf Institute, PUC-Rio \u2013 Rio de Janeiro, RJ \u2013 Brazil"],"raw_orcid":"https://orcid.org/0000-0001-9713-300X","affiliations":[{"raw_affiliation_string":"Tecgraf Institute, PUC-Rio \u2013 Rio de Janeiro, RJ \u2013 Brazil","institution_ids":["https://openalex.org/I2699952"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102922432","display_name":"Eduardo Nascimento","orcid":"https://orcid.org/0009-0005-3391-7813"},"institutions":[{"id":"https://openalex.org/I2699952","display_name":"Pontif\u00edcia Universidade Cat\u00f3lica do Rio de Janeiro","ror":"https://ror.org/01dg47b60","country_code":"BR","type":"education","lineage":["https://openalex.org/I2699952"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Eduardo R.S. Nascimento","raw_affiliation_strings":["Department of Informatics, PUC-Rio \u2013 Rio de Janeiro, RJ \u2013 Brazil","Tecgraf Institute, PUC-Rio \u2013 Rio de Janeiro, RJ \u2013 Brazil"],"raw_orcid":"https://orcid.org/0009-0005-3391-7813","affiliations":[{"raw_affiliation_string":"Department of Informatics, PUC-Rio \u2013 Rio de Janeiro, RJ \u2013 Brazil","institution_ids":["https://openalex.org/I2699952"]},{"raw_affiliation_string":"Tecgraf Institute, PUC-Rio \u2013 Rio de Janeiro, RJ \u2013 Brazil","institution_ids":["https://openalex.org/I2699952"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5036463225","display_name":"Matheus O. Silva","orcid":null},"institutions":[{"id":"https://openalex.org/I2699952","display_name":"Pontif\u00edcia Universidade Cat\u00f3lica do Rio de Janeiro","ror":"https://ror.org/01dg47b60","country_code":"BR","type":"education","lineage":["https://openalex.org/I2699952"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Matheus O. Silva","raw_affiliation_strings":["Department of Informatics, PUC-Rio \u2013 Rio de Janeiro, RJ \u2013 Brazil"],"raw_orcid":"https://orcid.org/0009-0009-1932-296X","affiliations":[{"raw_affiliation_string":"Department of Informatics, PUC-Rio \u2013 Rio de Janeiro, RJ \u2013 Brazil","institution_ids":["https://openalex.org/I2699952"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075402378","display_name":"Pedro Henrique Thompson Furtado","orcid":"https://orcid.org/0000-0001-6355-7031"},"institutions":[{"id":"https://openalex.org/I32393484","display_name":"Petrobras (Brazil)","ror":"https://ror.org/0235kyq22","country_code":"BR","type":"company","lineage":["https://openalex.org/I32393484"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Pedro H.T. Furtado","raw_affiliation_strings":["Petrobras \u2013 Rio de Janeiro, RJ \u2013 Brazil"],"raw_orcid":"https://orcid.org/0000-0001-6355-7031","affiliations":[{"raw_affiliation_string":"Petrobras \u2013 Rio de Janeiro, RJ \u2013 Brazil","institution_ids":["https://openalex.org/I32393484"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5028790094","display_name":"Michelle S. P. Facina","orcid":"https://orcid.org/0000-0002-0785-9606"},"institutions":[{"id":"https://openalex.org/I32393484","display_name":"Petrobras (Brazil)","ror":"https://ror.org/0235kyq22","country_code":"BR","type":"company","lineage":["https://openalex.org/I32393484"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Michelle S.P. Facina","raw_affiliation_strings":["Petrobras \u2013 Rio de Janeiro, RJ \u2013 Brazil"],"raw_orcid":"https://orcid.org/0000-0002-0785-9606","affiliations":[{"raw_affiliation_string":"Petrobras \u2013 Rio de Janeiro, RJ \u2013 Brazil","institution_ids":["https://openalex.org/I32393484"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5077506036","display_name":"Marco A. Casanova","orcid":"https://orcid.org/0000-0003-0765-9636"},"institutions":[{"id":"https://openalex.org/I2699952","display_name":"Pontif\u00edcia Universidade Cat\u00f3lica do Rio de Janeiro","ror":"https://ror.org/01dg47b60","country_code":"BR","type":"education","lineage":["https://openalex.org/I2699952"]}],"countries":["BR"],"is_corresponding":false,"raw_author_name":"Marco A. Casanova","raw_affiliation_strings":["Department of Informatics, PUC-Rio \u2013 Rio de Janeiro, RJ \u2013 Brazil","Tecgraf Institute, PUC-Rio \u2013 Rio de Janeiro, RJ \u2013 Brazil"],"raw_orcid":"https://orcid.org/0000-0003-0765-9636","affiliations":[{"raw_affiliation_string":"Department of Informatics, PUC-Rio \u2013 Rio de Janeiro, RJ \u2013 Brazil","institution_ids":["https://openalex.org/I2699952"]},{"raw_affiliation_string":"Tecgraf Institute, PUC-Rio \u2013 Rio de Janeiro, RJ \u2013 Brazil","institution_ids":["https://openalex.org/I2699952"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":8,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.46537992,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"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/T13734","display_name":"Advanced Computational Techniques and Applications","score":0.8920000195503235,"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/T13734","display_name":"Advanced Computational Techniques and Applications","score":0.8920000195503235,"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.8910999894142151,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.7825999855995178,"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/joins","display_name":"Joins","score":0.7153000235557556},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.6158000230789185},{"id":"https://openalex.org/keywords/database-schema","display_name":"Database schema","score":0.6122000217437744},{"id":"https://openalex.org/keywords/natural-language-user-interface","display_name":"Natural language user interface","score":0.6003999710083008},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.597000002861023},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5861999988555908},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.49869999289512634},{"id":"https://openalex.org/keywords/interface","display_name":"Interface (matter)","score":0.4490000009536743},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.4357999861240387},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.39579999446868896}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8216000199317932},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.7153000235557556},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.6158000230789185},{"id":"https://openalex.org/C30775581","wikidata":"https://www.wikidata.org/wiki/Q632285","display_name":"Database schema","level":3,"score":0.6122000217437744},{"id":"https://openalex.org/C174252522","wikidata":"https://www.wikidata.org/wiki/Q3816772","display_name":"Natural language user interface","level":3,"score":0.6003999710083008},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.597000002861023},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5861999988555908},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5550000071525574},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.49869999289512634},{"id":"https://openalex.org/C113843644","wikidata":"https://www.wikidata.org/wiki/Q901882","display_name":"Interface (matter)","level":4,"score":0.4490000009536743},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4357999861240387},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.39579999446868896},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.391400009393692},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.3831999897956848},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.374099999666214},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.3488999903202057},{"id":"https://openalex.org/C2778625365","wikidata":"https://www.wikidata.org/wiki/Q5227393","display_name":"Database application","level":2,"score":0.33230000734329224},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.328900009393692},{"id":"https://openalex.org/C89505385","wikidata":"https://www.wikidata.org/wiki/Q47146","display_name":"User interface","level":2,"score":0.31119999289512634},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2994999885559082},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.2915000021457672},{"id":"https://openalex.org/C150012506","wikidata":"https://www.wikidata.org/wiki/Q6031185","display_name":"Information schema","level":5,"score":0.28780001401901245},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.2833999991416931},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.2793000042438507},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.2777999937534332},{"id":"https://openalex.org/C29275276","wikidata":"https://www.wikidata.org/wiki/Q2268965","display_name":"Conceptual schema","level":3,"score":0.27639999985694885},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.2759999930858612},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2687999904155731},{"id":"https://openalex.org/C103593891","wikidata":"https://www.wikidata.org/wiki/Q624546","display_name":"Entity\u2013relationship model","level":3,"score":0.267300009727478},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.26330000162124634},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.26260000467300415},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.2623000144958496},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.25850000977516174}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.3233/faia251458","is_oa":true,"landing_page_url":"https://doi.org/10.3233/faia251458","pdf_url":null,"source":{"id":"https://openalex.org/S4210201731","display_name":"Frontiers in artificial intelligence and applications","issn_l":"0922-6389","issn":["0922-6389","1879-8314"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers in Artificial Intelligence and Applications","raw_type":"book-chapter"}],"best_oa_location":{"id":"doi:10.3233/faia251458","is_oa":true,"landing_page_url":"https://doi.org/10.3233/faia251458","pdf_url":null,"source":{"id":"https://openalex.org/S4210201731","display_name":"Frontiers in artificial intelligence and applications","issn_l":"0922-6389","issn":["0922-6389","1879-8314"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"journal"},"license":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Frontiers in Artificial Intelligence and Applications","raw_type":"book-chapter"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"This":[0],"paper":[1,29,77,201],"describes":[2],"the":[3,38,46,58,85,93,96,106,123,154,158,161,167,183,198,205,214,221],"steps":[4],"taken":[5],"to":[6,44],"construct":[7],"a":[8,54,62,170,176,193],"Natural":[9,66,208],"Language":[10,15,67,209],"interface":[11,210],"based":[12,52],"on":[13,37,53,84],"Large":[14],"Models":[16],"(LLMs)":[17],"for":[18,34],"Busca360,":[19],"an":[20,25],"application":[21],"in":[22,105],"production":[23],"at":[24],"energy":[26],"company.":[27],"The":[28,49,76,89,113,200],"analyses":[30],"how":[31,80],"technologies":[32],"developed":[33],"text-to-SQL":[35,81],"perform":[36,83],"Busca360":[39,59,86,114,222],"database":[40,60,115,223],"and":[41,61,70,125,128,153,213,219],"proposes":[42],"solutions":[43],"overcome":[45],"limitations":[47],"observed.":[48],"analysis":[50],"is":[51],"benchmark":[55],"that":[56,92,103,121,132,135,148,181],"uses":[57],"set":[63,141,172],"of":[64,95,142,160,173,187],"100":[65],"(NL)":[68],"questions":[69],"their":[71],"ground":[72],"truth":[73],"SQL":[74],"translations.":[75],"first":[78],"investigates":[79],"strategies":[82,97],"relational":[87],"schema.":[88],"experiments":[90,143,174],"showed":[91],"performance":[94],"tested":[98,175],"was":[99,116],"significantly":[100],"less":[101],"than":[102],"reported":[104],"leaderboards,":[107],"mainly":[108],"because":[109],"schema":[110,149],"linking":[111,150],"failed.":[112],"then":[117],"equipped":[118],"with":[119,185],"views":[120,146,212],"rename":[122],"table":[124],"column":[126],"names":[127],"have":[129],"new":[130],"columns":[131],"predefine":[133],"joins":[134,156],"follow":[136],"foreign":[137],"keys.":[138],"A":[139],"second":[140],"using":[144,211],"such":[145],"corroborated":[147],"largely":[151],"improved,":[152],"predefined":[155],"reduced":[157],"complexity":[159],"NL":[162,188],"question":[163],"translation.":[164],"To":[165],"enhance":[166],"results":[168],"further,":[169],"third":[171],"dynamic":[177,215],"few-shot":[178,216],"examples":[179,186,217],"technique":[180],"prompted":[182],"LLM":[184],"question/SQL":[189],"translation,":[190],"retrieved":[191],"from":[192,197],"synthetic":[194],"dataset":[195],"pre-computed":[196],"database.":[199],"concludes":[202],"by":[203],"outlining":[204],"current":[206],"LLM-based":[207],"technique,":[218],"leveraging":[220],"keyword":[224],"search":[225],"services.":[226]},"counts_by_year":[],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-24T00:00:00"}