Results 281 to 290 of about 83,370 (327)

Few-shot Text-to-SQL Translation using Structure and Content Prompt Learning

Proc. ACM Manag. Data, 2023
A common problem with adopting Text-to-SQL translation in database systems is poor generalization. Specifically, when there is limited training data on new datasets, existing few-shot Text-to-SQL techniques, even with carefully designed textual prompts ...
Zihui Gu, Ju Fan, Nan Tang, Lei Cao, Bowen Jia, Samuel Madden, Xiaoyong Du   +6 more
semanticscholar   +1 more source

SQL/AA

Proceedings of the VLDB Endowment, 2014
Current applications, from complex sensor systems (e.g. quantified self) to online e-markets acquire vast quantities of personal information which usually end-up on central servers. This information represents an unprecedented potential for user customized applications and business (e.g., car insurance billing, carbon tax, traffic decongestion ...
To, Cuong Quoc, Nguyen, Benjamin, Pucheral, Philippe   +2 more
openaire   +4 more sources

Die SQL-Norm (The SQL Standard)

it - Information Technology, 2003
Zusammenfassung In diesem Artikel geben die Autoren einen Überblick über die neuesten Funktionen der nächsten Version der SQL-Norm (SQL:2003) sowie eine kurze Zusammenfassung der vorhandenen Funktionalität in der aktuell gültigen Norm (SQL:1999) und den früheren Versionen. Zusätzlich wird auf ausgewählte Teile des Standards ausführlicher
Andrew Eisenberg, C. M. Farrar, Nelson Mendonça Mattos, H. Darwen, Krishna Kulkarni, Jan-Eike Michels   +5 more
openaire   +2 more sources

Introduction to SQL, SQL*Plus, and SQL Developer

2009
This chapter provides an introduction to the SQL language and two tools for working with it. The first section presents a high-level overview of the SQL language, which will give you an idea of the capabilities of this language. Then some important basic concepts of the SQL language are introduced in the second section, such as constants, literals ...
Lex de Haan, Inger Jørgensen, Daniel Fink, Karen Morton, Tim Gorman   +4 more
openaire   +2 more sources

CodeS: Towards Building Open-source Language Models for Text-to-SQL

Proc. ACM Manag. Data
Language models have shown promising performance on the task of translating natural language questions into SQL queries (Text-to-SQL). However, most of the state-of-the-art (SOTA) approaches rely on powerful yet closed-source large language models (LLMs),
Haoyang Li, Jing Zhang, Hanbing Liu, Ju Fan, Xiaokang Zhang, Jun Zhu, Renjie Wei, Hongyan Pan, Cuiping Li, Hong Chen   +9 more
semanticscholar   +1 more source

Duplicates in SQL

Data & Knowledge Engineering, 1994
Abstract The relational database model is defined in terms of sets, whereas SQL needs the DISTINCT option for explicit duplicate removal. We define the underlying concept of duplicate tuples, generalize the operators of the relational algebra and study the connection with logic. It is shown that ‘baggy’ operators violate classical equivalences.
S. J. van Denneheuvel, Karen L. Kwast
openaire   +3 more sources

CHESS: Contextual Harnessing for Efficient SQL Synthesis

arXiv.org
Translating natural language questions into SQL queries, known as text-to-SQL, is a long-standing research problem. Effective text-to-SQL synthesis can become very challenging due to (i) the extensive size of database catalogs (descriptions of tables and
Shayan Talaei, Mohammadreza Pourreza, Yu-Chen Chang, Azalia Mirhoseini, Amin Saberi   +4 more
semanticscholar   +1 more source

Deep Neural Network-Based SQL Injection Detection Method

Security and Communication Networks, 2022
Among the network security problems, SQL injection is a common and challenging network attack means, which can cause inestimable loop-breaking and loss to the database, and how to detect SQL injection statements is one of the current research hotspots ...
Wei Zhang, Yueqin Li, Xiaofeng Li, Minggang Shao, Yajie Mi, Hongli Zhang, Guoqing Zhi   +6 more
semanticscholar   +1 more source

SQL-Middleware: Enabling the Blockchain with SQL

2021
With the development of blockchain, blockchain has a broad prospect as a new type of data management system. However, limited to the data modeling method of blockchain, the usability of blockchain is restricted; In addition, every blockchain system has its own native but naive interfaces, when developing based on the different blockchain systems, which
Haibo Tang, Nan Jiang, Yingjie Yang, Zhao Zhang, Cheqing Jin, Wei Fan, Tong Xing, Gang Qin, Gao Yichen, Sijia Deng   +9 more
openaire   +2 more sources

PET-SQL: A Prompt-enhanced Two-stage Text-to-SQL Framework with Cross-consistency

arXiv.org
Recent advancements in Text-to-SQL (Text2SQL) emphasize stimulating the large language models (LLM) on in-context learning, achieving significant results.
Zhishuai Li, Xiang Wang, Jingjing Zhao, Sun Yang, Guoqing Du, Xiaoru Hu, Bin Zhang, Yuxiao Ye, Ziyue Li, Rui Zhao, Hangyu Mao   +10 more
semanticscholar   +1 more source