Logical errors in database SQL retrieval queries |
| |
Authors: | R. B. Buitendijk |
| |
Affiliation: | (1) Faculteit Economie en Econometrie, Vrije Universiteit, De Boelelaan 1105, NL 1081 HV Amsterdam, The Netherlands |
| |
Abstract: | SQL is often used to express questions imposed by users. It is well known that this process is not error-free in that it may result in syntactically or semantically incorrect SQL queries. This article is meant to probe deeper into SQL queries that are incorrect, due to delusion errors. A classification of natural language questions will be introduced. The purpose of this classification is two-fold. Firstly, it gives insight into possible errors and enables us to distinguish between types of errors. Secondly, it is a means of determining the influence of measures (for instance, SQL training) that can be taken to reduce the number of aforementioned errors. For discussion, several of these measures will be presented and related to the classification.Abbreviations RA Relational algebra - SQL structured query language |
| |
Keywords: | Queries relational algebra relational model SQL |
本文献已被 SpringerLink 等数据库收录! |
|