{"id":"https://openalex.org/W4403276993","doi":"https://doi.org/10.1109/is61756.2024.10705186","title":"RAGSQL: Context Retrieval Evaluation on Augmenting Text-to-SQL Prompts","display_name":"RAGSQL: Context Retrieval Evaluation on Augmenting Text-to-SQL Prompts","publication_year":2024,"publication_date":"2024-08-29","ids":{"openalex":"https://openalex.org/W4403276993","doi":"https://doi.org/10.1109/is61756.2024.10705186"},"language":"en","primary_location":{"id":"doi:10.1109/is61756.2024.10705186","is_oa":false,"landing_page_url":"https://doi.org/10.1109/is61756.2024.10705186","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 IEEE 12th International Conference on Intelligent Systems (IS)","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/A5108183860","display_name":"Sergey Vichev","orcid":null},"institutions":[{"id":"https://openalex.org/I58918642","display_name":"Sofia University \"St. Kliment Ohridski\"","ror":"https://ror.org/02jv3k292","country_code":"BG","type":"education","lineage":["https://openalex.org/I58918642"]}],"countries":["BG"],"is_corresponding":true,"raw_author_name":"Sergey Vichev","raw_affiliation_strings":["Sofia University “St. Kliment Ohridski”,Faculty of Economics and Business Administration,Department of Statistics and Econometrics"],"affiliations":[{"raw_affiliation_string":"Sofia University “St. Kliment Ohridski”,Faculty of Economics and Business Administration,Department of Statistics and Econometrics","institution_ids":["https://openalex.org/I58918642"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5049133493","display_name":"Angel Marchev","orcid":"https://orcid.org/0000-0002-5090-3123"},"institutions":[{"id":"https://openalex.org/I211070993","display_name":"University of National and World Economy","ror":"https://ror.org/017ph0934","country_code":"BG","type":"education","lineage":["https://openalex.org/I211070993"]}],"countries":["BG"],"is_corresponding":false,"raw_author_name":"Angel Marchev","raw_affiliation_strings":["University of National and World Economy,Faculty of Management and Administration,Department of Management"],"affiliations":[{"raw_affiliation_string":"University of National and World Economy,Faculty of Management and Administration,Department of Management","institution_ids":["https://openalex.org/I211070993"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5108183860"],"corresponding_institution_ids":["https://openalex.org/I58918642"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.15443813,"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":"6"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10215","display_name":"Semantic Web and Ontologies","score":0.9848999977111816,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9848999977111816,"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.9847999811172485,"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.9660000205039978,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8564629554748535},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7359245419502258},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.6282675266265869},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.6054680347442627},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.41770172119140625},{"id":"https://openalex.org/keywords/natural-language-processing","display_name":"Natural language processing","score":0.37969931960105896},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.37058591842651367}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8564629554748535},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7359245419502258},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.6282675266265869},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.6054680347442627},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.41770172119140625},{"id":"https://openalex.org/C204321447","wikidata":"https://www.wikidata.org/wiki/Q30642","display_name":"Natural language processing","level":1,"score":0.37969931960105896},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.37058591842651367},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/is61756.2024.10705186","is_oa":false,"landing_page_url":"https://doi.org/10.1109/is61756.2024.10705186","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2024 IEEE 12th International Conference on Intelligent Systems (IS)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W2890431379","https://openalex.org/W2970641574","https://openalex.org/W4375869868","https://openalex.org/W4388639106","https://openalex.org/W4389518685","https://openalex.org/W4389649881","https://openalex.org/W4392872984","https://openalex.org/W4399175046","https://openalex.org/W6777615688","https://openalex.org/W6778883912","https://openalex.org/W6793511141","https://openalex.org/W6809646742","https://openalex.org/W6810730852","https://openalex.org/W6839395728","https://openalex.org/W6849760658","https://openalex.org/W6851928915","https://openalex.org/W6853859572"],"related_works":["https://openalex.org/W2003932708","https://openalex.org/W1967424056","https://openalex.org/W2284877871","https://openalex.org/W2138102289","https://openalex.org/W868043274","https://openalex.org/W2513523087","https://openalex.org/W1187916458","https://openalex.org/W2373861055","https://openalex.org/W1559716973","https://openalex.org/W3109364360"],"abstract_inverted_index":{"Text-to-SQL":[0],"area":[1],"evolves":[2],"rapidly":[3],"in":[4,47,53,65],"the":[5,17,33,62,69,105,118],"era":[6],"of":[7],"large":[8],"language":[9],"models":[10,122],"(LLMs)":[11],"as":[12,38],"organizations":[13],"look":[14],"for":[15,101],"adapting":[16,80],"technology.":[18],"A":[19],"gained":[20],"popularity":[21],"method":[22],"to":[23],"improve":[24],"LLM":[25,70],"outputs":[26],"is":[27],"through":[28],"giving":[29],"relevant":[30],"context":[31,64],"about":[32],"database":[34],"and":[35,91,98,126],"organizational":[36],"data":[37,81],"few-shot":[39],"prompting.":[40],"Recent":[41],"research":[42],"showcases":[43],"that":[44,116],"better":[45],"results":[46],"text-to-SQL":[48],"tasks":[49,103],"can":[50],"be":[51],"achieved":[52],"a":[54],"Retrieval":[55],"Augmented":[56],"Generation":[57],"(RAG)":[58],"setting":[59],"by":[60,79],"augmenting":[61],"prompt":[63],"dynamic":[66],"fashion":[67],"during":[68],"inference.":[71],"In":[72],"this":[73],"paper":[74],"we":[75],"design":[76],"such":[77,102],"experiment":[78],"from":[82],"BIRD":[83],"benchmark,":[84],"on":[85,123],"more":[86],"than":[87],"10":[88],"thousand":[89],"examples":[90],"evaluate":[92],"existing":[93],"embedding":[94,121],"models,":[95],"both":[96,124],"closed":[97],"open":[99],"source,":[100],"reporting":[104],"comparison":[106],"results.":[107],"We":[108],"then":[109],"fine-tune":[110],"an":[111],"open-source":[112],"sentence":[113],"transformer":[114],"model":[115],"outperforms":[117],"state-of-the-art":[119],"(SOTA)":[120],"question-to-evidence":[125],"question-to-SQL":[127],"retrieval":[128],"experiments.":[129]},"counts_by_year":[],"updated_date":"2025-12-22T23:10:17.713674","created_date":"2025-10-10T00:00:00"}