{"id":"https://openalex.org/W4416047834","doi":"https://doi.org/10.48550/arxiv.2505.22096","title":"Knowledge Base Construction for Knowledge-Augmented Text-to-SQL","display_name":"Knowledge Base Construction for Knowledge-Augmented Text-to-SQL","publication_year":2025,"publication_date":"2025-05-28","ids":{"openalex":"https://openalex.org/W4416047834","doi":"https://doi.org/10.48550/arxiv.2505.22096"},"language":"en","primary_location":{"id":"pmh:oai:arXiv.org:2505.22096","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2505.22096","pdf_url":"https://arxiv.org/pdf/2505.22096","source":{"id":"https://openalex.org/S4393918464","display_name":"ArXiv.org","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"type":"preprint","indexed_in":["arxiv","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2505.22096","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5013449404","display_name":"Jinheon Baek","orcid":"https://orcid.org/0000-0002-9367-560X"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Baek, Jinheon","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5035277014","display_name":"Horst Samulowitz","orcid":"https://orcid.org/0000-0002-6780-3217"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Samulowitz, Horst","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5068065546","display_name":"Oktie Hassanzadeh","orcid":"https://orcid.org/0000-0001-5307-9857"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Hassanzadeh, Oktie","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5052501780","display_name":"Dharmashankar Subramanian","orcid":"https://orcid.org/0000-0002-1990-7740"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Subramanian, Dharmashankar","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073655930","display_name":"Sola Shirai","orcid":"https://orcid.org/0000-0001-6913-3598"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Shirai, Sola","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087419620","display_name":"Alfio Gliozzo","orcid":"https://orcid.org/0000-0002-8044-2911"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Gliozzo, Alfio","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5057827968","display_name":"Debarun Bhattacharjya","orcid":"https://orcid.org/0000-0002-9125-1336"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Bhattacharjya, Debarun","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5013449404"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":null,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.4634999930858612,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.4634999930858612,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.07890000194311142,"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/T10028","display_name":"Topic Modeling","score":0.0471000000834465,"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/knowledge-base","display_name":"Knowledge base","score":0.7434999942779541},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.7013999819755554},{"id":"https://openalex.org/keywords/knowledge-extraction","display_name":"Knowledge extraction","score":0.4864000082015991},{"id":"https://openalex.org/keywords/natural-language","display_name":"Natural language","score":0.43479999899864197},{"id":"https://openalex.org/keywords/knowledge-based-systems","display_name":"Knowledge-based systems","score":0.41589999198913574},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.39169999957084656},{"id":"https://openalex.org/keywords/open-knowledge-base-connectivity","display_name":"Open Knowledge Base Connectivity","score":0.39160001277923584},{"id":"https://openalex.org/keywords/base","display_name":"Base (topology)","score":0.3476000130176544}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8381999731063843},{"id":"https://openalex.org/C4554734","wikidata":"https://www.wikidata.org/wiki/Q593744","display_name":"Knowledge base","level":2,"score":0.7434999942779541},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7013999819755554},{"id":"https://openalex.org/C120567893","wikidata":"https://www.wikidata.org/wiki/Q1582085","display_name":"Knowledge extraction","level":2,"score":0.4864000082015991},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.46309998631477356},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.43479999899864197},{"id":"https://openalex.org/C115925183","wikidata":"https://www.wikidata.org/wiki/Q1412694","display_name":"Knowledge-based systems","level":2,"score":0.41589999198913574},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.39169999957084656},{"id":"https://openalex.org/C29804473","wikidata":"https://www.wikidata.org/wiki/Q2025711","display_name":"Open Knowledge Base Connectivity","level":4,"score":0.39160001277923584},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3675000071525574},{"id":"https://openalex.org/C42058472","wikidata":"https://www.wikidata.org/wiki/Q810214","display_name":"Base (topology)","level":2,"score":0.3476000130176544},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.34040001034736633},{"id":"https://openalex.org/C84685590","wikidata":"https://www.wikidata.org/wiki/Q1540472","display_name":"Knowledge engineering","level":2,"score":0.3260999917984009},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.3174000084400177},{"id":"https://openalex.org/C44291984","wikidata":"https://www.wikidata.org/wiki/Q1074173","display_name":"Question answering","level":2,"score":0.30219998955726624},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2924000024795532},{"id":"https://openalex.org/C161301231","wikidata":"https://www.wikidata.org/wiki/Q3478658","display_name":"Knowledge representation and reasoning","level":2,"score":0.2915000021457672},{"id":"https://openalex.org/C195807954","wikidata":"https://www.wikidata.org/wiki/Q1662562","display_name":"Information extraction","level":2,"score":0.29120001196861267},{"id":"https://openalex.org/C2989070954","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database query","level":2,"score":0.2660999894142151},{"id":"https://openalex.org/C207685749","wikidata":"https://www.wikidata.org/wiki/Q2088941","display_name":"Domain knowledge","level":2,"score":0.2624000012874603},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.25589999556541443}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:arXiv.org:2505.22096","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2505.22096","pdf_url":"https://arxiv.org/pdf/2505.22096","source":{"id":"https://openalex.org/S4393918464","display_name":"ArXiv.org","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"doi:10.48550/arxiv.2505.22096","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2505.22096","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2505.22096","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2505.22096","pdf_url":"https://arxiv.org/pdf/2505.22096","source":{"id":"https://openalex.org/S4393918464","display_name":"ArXiv.org","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4416047834.pdf","grobid_xml":"https://content.openalex.org/works/W4416047834.grobid-xml"},"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Text-to-SQL":[0],"aims":[1],"to":[2,17,59],"translate":[3],"natural":[4],"language":[5],"queries":[6,44,66],"into":[7],"SQL":[8,48],"statements,":[9],"which":[10,74,98,135],"is":[11,133,136],"practical":[12],"as":[13],"it":[14,186],"enables":[15],"anyone":[16],"easily":[18],"retrieve":[19,100],"the":[20,51,62,87,103,144,179],"desired":[21],"information":[22],"from":[23,97,164],"databases.":[24],"Recently,":[25],"many":[26],"existing":[27,112],"approaches":[28,113],"tackle":[29,82],"this":[30],"problem":[31],"with":[32,153],"Large":[33],"Language":[34],"Models":[35],"(LLMs),":[36],"leveraging":[37],"their":[38,148,154],"strong":[39],"capability":[40],"in":[41,54,70],"understanding":[42],"user":[43],"and":[45,64,101,147,157,167,181],"generating":[46],"corresponding":[47],"code.":[49],"Yet,":[50],"parametric":[52],"knowledge":[53,88,105,118,126,131],"LLMs":[55],"might":[56],"be":[57,159],"limited":[58],"covering":[60],"all":[61,143],"diverse":[63],"domain-specific":[65],"that":[67,114],"require":[68],"grounding":[69],"various":[71],"database":[72,150,183],"schemas,":[73],"makes":[75],"generated":[76],"SQLs":[77],"less":[78],"accurate":[79],"oftentimes.":[80],"To":[81],"this,":[83],"we":[84,99],"propose":[85],"constructing":[86],"base":[89,132],"for":[90,106,127,161],"text-to-SQL,":[91],"a":[92,122,140],"foundational":[93],"source":[94],"of":[95,125,142],"knowledge,":[96,156],"generate":[102,120],"necessary":[104],"given":[107],"queries.":[108],"In":[109],"particular,":[110],"unlike":[111],"either":[115],"manually":[116],"annotate":[117],"or":[119],"only":[121],"few":[123],"pieces":[124],"each":[128],"query,":[129],"our":[130,171],"comprehensive,":[134],"constructed":[137],"based":[138],"on":[139,173],"combination":[141],"available":[145],"questions":[146],"associated":[149],"schemas":[151],"along":[152],"relevant":[155,188],"can":[158],"reused":[160],"unseen":[162],"databases":[163],"different":[165],"datasets":[166],"domains.":[168],"We":[169],"validate":[170],"approach":[172],"multiple":[174],"text-to-SQL":[175],"datasets,":[176],"considering":[177],"both":[178],"overlapping":[180],"non-overlapping":[182],"scenarios,":[184],"where":[185],"outperforms":[187],"baselines":[189],"substantially.":[190]},"counts_by_year":[],"updated_date":"2026-03-10T16:38:18.471706","created_date":"2025-10-10T00:00:00"}