AutoLink让大模型自主探索数据库结构,高效精准链接关键字段。
AutoLink: Autonomous Schema Exploration and Expansion for Scalable Schema Linking in Text-to-SQL at Scale
- 用智能代理迭代式探索并扩展相关表字段,不依赖完整模式输入。
- 在Bird-Dev上达97.4%召回率,大型数据库(超3000列)仍保持高精度。
- 适合工业级文本转SQL系统,尤其处理超大规模数据库场景。
工业级文本转SQL任务中,将完整数据库模式输入大语言模型(LLMs)因上下文窗口限制和无关噪声而不切实际。模式链接通过筛选出相关子集成为关键。然而,现有方法成本高昂,难以平衡召回率与噪声,且难以扩展至大型数据库。我们提出 extbf{AutoLink},一个自主代理框架,将模式链接重构为由大模型驱动的迭代式、代理主导过程。在大模型引导下,AutoLink动态探索并扩展已链接的模式子集,逐步识别必要模式组件,无需输入全量数据库模式。实验表明,AutoLink性能优异,在Bird-Dev上达到97.4%的严格模式链接召回率,在Spider-2.0-Lite上达91.2%,执行准确率分别为68.7% EX(优于CHESS)和34.9% EX(官方排行榜第二)。关键优势在于卓越可扩展性:在超大规模模式(如超过3,000列)上仍保持高召回率、低令牌消耗和稳健执行准确率,是工业级文本转SQL系统的高召回、高可扩展模式链接解决方案。
原文摘要 · Abstract (English)
For industrial-scale text-to-SQL, supplying the entire database schema to Large Language Models (LLMs) is impractical due to context window limits and irrelevant noise. Schema linking, which filters the schema to a relevant subset, is therefore critical. However, existing methods incur prohibitive costs, struggle to trade off recall and noise, and scale poorly to large databases. We present \textbf{AutoLink}, an autonomous agent framework that reformulates schema linking as an iterative, agent-driven process. Guided by an LLM, AutoLink dynamically explores and expands the linked schema subset, progressively identifying necessary schema components without inputting the full database schema. Our experiments demonstrate AutoLink's superior performance, achieving state-of-the-art strict schema linking recall of \textbf{97.4\%} on Bird-Dev and \textbf{91.2\%} on Spider-2.0-Lite, with competitive execution accuracy, i.e., \textbf{68.7\%} EX on Bird-Dev (better than CHESS) and \textbf{34.9\%} EX on Spider-2.0-Lite (ranking 2nd on the official leaderboard). Crucially, AutoLink exhibits \textbf{exceptional scalability}, \textbf{maintaining high recall}, \textbf{efficient token consumption}, and \textbf{robust execution accuracy} on large schemas (e.g., over 3,000 columns) where existing methods severely degrade-making it a highly scalable, high-recall schema-linking solution for industrial text-to-SQL systems.
Thank you to arXiv for use of its open access interoperability. PaperDance 不是 arXiv 官方产品;中文卡片由大模型生成,请以原文为准。