Results 231 to 240 of about 82,951 (280)

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

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   +3 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

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

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

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

arXiv.org
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.
Zijin Hong, Zheng Yuan, Qinggang Zhang, Hao Chen, Junnan Dong, Feiran Huang, Xiao Huang   +6 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.
Kwast, K.L., van Denneheuvel, S.J.
openaire   +4 more sources

MCS-SQL: Leveraging Multiple Prompts and Multiple-Choice Selection For Text-to-SQL Generation

International Conference on Computational Linguistics
Recent advancements in large language models (LLMs) have enabled in-context learning (ICL)-based methods that significantly outperform fine-tuning approaches for text-to-SQL tasks. However, their performance is still considerably lower than that of human
Dongjun Lee, Choongwon Park, Jaehyuk Kim, Heesoo Park   +3 more
semanticscholar   +1 more source

CHASE-SQL: Multi-Path Reasoning and Preference Optimized Candidate Selection in Text-to-SQL

International Conference on Learning Representations
In tackling the challenges of large language model (LLM) performance for Text-to-SQL tasks, we introduce CHASE-SQL, a new framework that employs innovative strategies, using test-time compute in multi-agent modeling to improve candidate generation and ...
Mohammadreza Pourreza, Hailong Li, Ruoxi Sun, Yeounoh Chung, Shayan Talaei, Gaurav Tarlok Kakkar, Yu Gan, Amin Saberi, Fatma Ozcan, Sercan Ö. Arik   +9 more
semanticscholar   +1 more source

Spider 2.0: Evaluating Language Models on Real-World Enterprise Text-to-SQL Workflows

International Conference on Learning Representations
Real-world enterprise text-to-SQL workflows often involve complex cloud or local data across various database systems, multiple SQL queries in various dialects, and diverse operations from data transformation to analytics.
Fangyu Lei, Fangyu Lei, Jixuan Chen, Yuxiao Ye, Ruisheng Cao, Dongchan Shin, Hongjin Su, Zhaoqing Suo, Hongcheng Gao, Hongcheng Gao, Pengcheng Yin, Victor Zhong, Caiming Xiong, Ruoxi Sun, Qian Liu, Sida Wang, Tao Yu   +16 more
semanticscholar   +1 more source