解决表格问答中结构复杂导致的准确率难题
SQuARE: Structured Query & Adaptive Retrieval Engine For Tabular Formats
- 根据表头深度和合并单元格密度动态路由查询路径
- 在多个真实数据集上准确率超越ChatGPT-4o与单一方法
- 适合需要高精度表格理解的金融、统计等专业场景
由于多行表头、合并单元格和单位标注破坏了简单分块,真实电子表格的精准问答仍具挑战性;而传统SQL视图在缺乏一致模式的文件上表现不佳。我们提出SQuARE,一种基于表级复杂度感知的混合检索框架。它通过计算表头深度与合并密度的连续得分,将查询路由至保留结构的分块检索或自动构建的关系表示上的SQL查询。轻量级代理在置信度低时监督跨路径的结果检索、精炼或融合。该设计保持表头层级、时间标签与单位信息,确保返回值忠实于原始单元格且易于验证。在包含多表头企业资产负债表、高度合并的世界银行工作簿及多样化公开数据集上的评估显示,SQuARE在检索精度与端到端回答准确率上持续超越单策略基线与ChatGPT-4o,同时保持可预测延迟。系统解耦检索与模型选择,兼容新兴表格基础模型,为更鲁棒的表格理解提供实用桥梁。
原文摘要 · Abstract (English)
Accurate question answering over real spreadsheets remains difficult due to multirow headers, merged cells, and unit annotations that disrupt naive chunking, while rigid SQL views fail on files lacking consistent schemas. We present SQuARE, a hybrid retrieval framework with sheet-level, complexity-aware routing. It computes a continuous score based on header depth and merge density, then routes queries either through structure-preserving chunk retrieval or SQL over an automatically constructed relational representation. A lightweight agent supervises retrieval, refinement, or combination of results across both paths when confidence is low. This design maintains header hierarchies, time labels, and units, ensuring that returned values are faithful to the original cells and straightforward to verify. Evaluated on multi-header corporate balance sheets, a heavily merged World Bank workbook, and diverse public datasets, SQuARE consistently surpasses single-strategy baselines and ChatGPT-4o on both retrieval precision and end-to-end answer accuracy while keeping latency predictable. By decoupling retrieval from model choice, the system is compatible with emerging tabular foundation models and offers a practical bridge toward a more robust table understanding.
Thank you to arXiv for use of its open access interoperability. PaperDance 不是 arXiv 官方产品;中文卡片由大模型生成,请以原文为准。