1
Return

EMLC: An extensible multi-level correction framework for text-to-SQL

delete2025-12-18
delete0
PRE
AI
雷建军 (Jianjun Lei)
Y
Yijie Tan
Y
Ying Wang
DOI:10.1016/j.ipm.2025.104560delete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
To address three key challenges of Text-to-SQL self-correction, including schema mismatch, structural incompleteness, and semantic validation weakness, this paper proposes EMLC, an extensible multi-level correction framework that hierarchically integrates schema, skeleton, and execution corrections. EMLC incorporates a dual-validation schema correction mechanism that combines large language model (LLM)-based prediction with token-level mapping for precise schema alignment. Moreover, it employs supervised fine-tuning skeleton generation to detect and correct keyword-level errors through abstract skeleton comparison, while the executability verification strategy is designed to further ensure both syntactic integrity and semantic fidelity of generated queries. EMLC supports plug-and-play integration with mainstream LLMs and flexible scalability. Experiments on the SPIDER and BIRD datasets show that EMLC achieves state-of-the-art execution accuracy, outperforming baseline methods by 2–4 %. Ablation studies further validate the individual contributions of each component and their synergistic effects.

Journal

I
Information Processing and Management
IF:
6.9
Papers:
5.2K
Citations:
1.4W

Organization

C
Chongqing University of Posts and Telecommunications
Scholars:
2.2K
Papers: 878
Citations: 3.8K
Cited Papers

Cited Papers

Citing Papers

Citing Papers