.png){kind=icon}
返回
GRAY: Enhancing Few-Shot NL2SQL Translation Through Incremental SQL Log-Based Demonstration Expansion
.png){kind=icon}
PRE
AI
DOI：10.1007/978-981-95-5716-5_5.png)
.png){kind=icon}
原文求助.png){kind=icon}
分享.png){kind=icon}
收藏
摘要
En 中文
The Natural Language to SQL (NL2SQL) task enables non-technical users to access databases. Recently, advancements in Large Language Models (LLMs) have driven progress in NL2SQL. However, existing methods still face challenges when dealing with domain-specific data due to limited domain knowledge and database adaptability. Numerous methods leverage schema information and query data to enhance performance, yet they remain inadequate for effective domain adaptation. To address the challenge of limited domain-specific knowledge, this paper proposes GRAY, a method that employs SQL logs to provide domain-specific knowledge. SQL logs capture domain-specific knowledge by reflecting the unique structure and semantics of each database, but their limited quantity restricts this knowledge, making incremental expansion necessary. GRAY proposes a two-phase incremental expansion method, utilizing LLM-driven query generation to enrich the domain-specific knowledge in SQL logs, enabling the LLM to understand the semantics of the specific database. To provide more relevant domain knowledge in the limited context window of LLMs, GRAY designs a high-quality demonstration selection algorithm. Through experiments on multiple real-world databases, GRAY improves the performance of the NL2SQL tasks. The experimental results show that GRAY performs effectively on complex databases and has broad application potential.
Keyword:
Natural Language Interface to DataBases
Natural Language to SQL
Large Language Model
期刊
W
IF:
0
论文数:
35
被引数:
0
机构
引用论文
.png){kind=icon}
ACT-SQL: In-Context Learning for Text-to-SQL with Automatically-Generated Chain-of-ThoughtACT-SQL：用于文本到SQL的上下文学习，带有自动生成的思维链
OAAI
OAAI分享收藏
Prompting GPT-3.5 for Text-to-SQL with De-semanticization and Skeleton Retrieval通过去语义化和骨架检索引导GPT-3.5进行文本到SQL的转换
PREAI
分享收藏
查看更多内容