Results 1 to 10 of about 83,370 (327)

HIE-SQL: History Information Enhanced Network for Context-Dependent Text-to-SQL Semantic Parsing [PDF]

arXiv, 2022
Recently, context-dependent text-to-SQL semantic parsing which translates natural language into SQL in an interaction process has attracted a lot of attention. Previous works leverage context-dependence information either from interaction history utterances or the previous predicted SQL queries but fail in taking advantage of both since of the mismatch
Yanzhao Zheng, Haibin Wang, B. Dong, Xingjun Wang, Changshan Li   +4 more
arxiv   +3 more sources

Natural SQL: Making SQL Easier to Infer from Natural Language Specifications [PDF]

arXiv, 2021
Addressing the mismatch between natural language descriptions and the corresponding SQL queries is a key challenge for text-to-SQL translation. To bridge this gap, we propose an SQL intermediate representation (IR) called Natural SQL (NatSQL). Specifically, NatSQL preserves the core functionalities of SQL, while it simplifies the queries as follows: (1)
Yujian Gan, Xinyun Chen, Jinxia Xie, Matthew Purver, J. Woodward, J. Drake, Qiaofu Zhang   +6 more
arxiv   +3 more sources

Next-Generation Database Interfaces: A Survey of LLM-based Text-to-SQL [PDF]

arXiv
Generating accurate SQL from users' natural language questions (text-to-SQL) remains a long-standing challenge due to the complexities involved in user question understanding, database schema comprehension, and SQL generation. Traditional text-to-SQL systems, which combine human engineering and deep neural networks, have made significant progress ...
Zijin Hong, Zheng Yuan, Qinggang Zhang, Hao Chen, Junnan Dong, Feiran Huang, Xiao Huang   +6 more
arxiv   +2 more sources

Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation [PDF]

Proceedings of the VLDB Endowment, 2023
Large language models (LLMs) have emerged as a new paradigm for Text-to-SQL task. However, the absence of a systematical benchmark inhibits the development of designing effective, efficient and economic LLM-based Text-to-SQL solutions.
Dawei Gao, Haibin Wang, Yaliang Li, Xiuyu Sun, Yichen Qian, Bolin Ding, Jingren Zhou   +6 more
semanticscholar   +1 more source

DIN-SQL: Decomposed In-Context Learning of Text-to-SQL with Self-Correction [PDF]

Neural Information Processing Systems, 2023
We study the problem of decomposing a complex text-to-sql task into smaller sub-tasks and how such a decomposition can significantly improve the performance of Large Language Models (LLMs) in the reasoning process.
M. Pourreza, Davood Rafiei
semanticscholar   +1 more source

RESDSQL: Decoupling Schema Linking and Skeleton Parsing for Text-to-SQL [PDF]

AAAI Conference on Artificial Intelligence, 2023
One of the recent best attempts at Text-to-SQL is the pre-trained language model. Due to the structural property of the SQL queries, the seq2seq model takes the responsibility of parsing both the schema items (i.e., tables and columns) and the skeleton ...
Haoyang Li, Jing Zhang, Cuiping Li, Hong Chen   +3 more
semanticscholar   +1 more source

C3: Zero-shot Text-to-SQL with ChatGPT [PDF]

arXiv.org, 2023
This paper proposes a ChatGPT-based zero-shot Text-to-SQL method, dubbed C3, which achieves 82.3\% in terms of execution accuracy on the holdout test set of Spider and becomes the state-of-the-art zero-shot Text-to-SQL method on the Spider Challenge.
Xuemei Dong, C. Zhang, Yuhang Ge, Yuren Mao, Yunjun Gao, Lu Chen, Jinshu Lin, Dongfang Lou   +7 more
semanticscholar   +1 more source

A comprehensive evaluation of ChatGPT's zero-shot Text-to-SQL capability [PDF]

arXiv.org, 2023
This paper presents the first comprehensive analysis of ChatGPT's Text-to-SQL ability. Given the recent emergence of large-scale conversational language model ChatGPT and its impressive capabilities in both conversational abilities and code generation ...
Aiwei Liu, Xuming Hu, Lijie Wen, Philip S. Yu   +3 more
semanticscholar   +1 more source

Graphix-T5: Mixing Pre-Trained Transformers with Graph-Aware Layers for Text-to-SQL Parsing [PDF]

AAAI Conference on Artificial Intelligence, 2023
The task of text-to-SQL parsing, which aims at converting natural language questions into executable SQL queries, has garnered increasing attention in recent years. One of the major challenges in text-to-SQL parsing is domain generalization, i.e., how to
Jinyang Li, Binyuan Hui, Reynold Cheng, Bowen Qin, Chenhao Ma, Nan Huo, Fei Huang, Wenyu Du, Luo Si, Yongbin Li   +9 more
semanticscholar   +1 more source

JSON Data and Relational Data Integration in Oracle [PDF]

Annals of Dunarea de Jos University. Fascicle I : Economics and Applied Informatics, 2021
Data is of major importance in the IT industry nowadays. The need to work with a wide variety of existing data is becoming more and more pressing. IT professionals need to transfer data structures from any language into formats that are recognized by ...
Gianina MIHAI
doaj   +1 more source