JD Tech
JD Tech
Aug 20, 2025 · Artificial Intelligence

Boosting Text-to-SQL Accuracy with J‑Schema, Iterative DPO, and Self‑Consistency

This article examines the evolution of Text-to-SQL, introduces the J‑Schema representation and chain-of-thought prompting, applies iterative DPO training and self-consistency voting, and demonstrates how these techniques raise execution accuracy on the BIRD benchmark from 56.6% to 69.2%.

BIRD BenchmarkIterative DPOJ-Schema
0 likes · 11 min read
Boosting Text-to-SQL Accuracy with J‑Schema, Iterative DPO, and Self‑Consistency
JD Tech Talk
JD Tech Talk
Aug 14, 2025 · Artificial Intelligence

Boosting Text-to-SQL Accuracy: J‑Schema, Iterative DPO, and Self‑Consistency

This paper presents a comprehensive approach to improve Text‑to‑SQL performance by introducing J‑Schema for structured database representation, leveraging chain‑of‑thought prompting, applying iterative DPO training, and employing self‑consistency voting, achieving execution accuracy gains from 56.6% to 69.2% on the BIRD benchmark.

BIRD BenchmarkIterative DPOSelf-Consistency
0 likes · 12 min read
Boosting Text-to-SQL Accuracy: J‑Schema, Iterative DPO, and Self‑Consistency
JD Cloud Developers
JD Cloud Developers
Aug 14, 2025 · Artificial Intelligence

Boosting Text-to-SQL Accuracy: J‑Schema, Iterative DPO, and Self‑Consistency

This article presents a comprehensive study on improving Text-to-SQL performance by introducing J‑Schema for structured schema representation, applying iterative Direct Preference Optimization (DPO) training, and leveraging self‑consistency voting mechanisms, achieving up to a 12% accuracy gain on the BIRD benchmark.

Database QAIterative DPOJ-Schema
0 likes · 10 min read
Boosting Text-to-SQL Accuracy: J‑Schema, Iterative DPO, and Self‑Consistency
JD Retail Technology
JD Retail Technology
Aug 14, 2025 · Artificial Intelligence

Boosting Text-to-SQL Accuracy: J‑Schema, Iterative DPO, and Self‑Consistency

This article surveys the evolution of Text-to-SQL, introduces the J‑Schema representation and chain-of-thought prompting, details an iterative DPO training pipeline with hyper‑parameter tuning, and demonstrates how self‑consistency voting boosts execution accuracy on the BIRD benchmark from 56.6% to 69.2%.

BIRD datasetIterative DPOLLM
0 likes · 14 min read
Boosting Text-to-SQL Accuracy: J‑Schema, Iterative DPO, and Self‑Consistency