A Survey of SQL Language

A Survey of SQL Language

Hock Chuan Chan, Hong Jun Lu, Kwok Kee Wei
Copyright: © 1993 |Pages: 13
DOI: 10.4018/jdm.1993100101
OnDemand:
(Individual Articles)
Available
$37.50
Current Special Offers
No Current Special Offers
TOTAL SAVINGS: $37.50

Abstract

SQL is the standard (ANSI and ISO) query language for relational database systems. It is increasingly used widely on various platforms as the main language to access databases. Beside theoretical analyses and laboratory studies with students, there is little information on SQL usage in practice. A survey was executed to identify major SQL users and applications, users’ perception of SQL, utilization of SQL features, and errors and problems that users encounter. The main SQL users are analysts and database administrators, which together formed 70.6%. There are very few end-users. SQL is very widely used in various applications. Queries are quite evenly spread from the very simple to the very complex, with users wishing for more complex capabilities. A surprisingly large 82% of queries contain syntax or logical errors, and require multiple attempts by users. Notwithstanding these, users have very good perception of SQL.

Complete Article List

Search this Journal:
Reset
Volume 35: 1 Issue (2024)
Volume 34: 3 Issues (2023)
Volume 33: 5 Issues (2022): 4 Released, 1 Forthcoming
Volume 32: 4 Issues (2021)
Volume 31: 4 Issues (2020)
Volume 30: 4 Issues (2019)
Volume 29: 4 Issues (2018)
Volume 28: 4 Issues (2017)
Volume 27: 4 Issues (2016)
Volume 26: 4 Issues (2015)
Volume 25: 4 Issues (2014)
Volume 24: 4 Issues (2013)
Volume 23: 4 Issues (2012)
Volume 22: 4 Issues (2011)
Volume 21: 4 Issues (2010)
Volume 20: 4 Issues (2009)
Volume 19: 4 Issues (2008)
Volume 18: 4 Issues (2007)
Volume 17: 4 Issues (2006)
Volume 16: 4 Issues (2005)
Volume 15: 4 Issues (2004)
Volume 14: 4 Issues (2003)
Volume 13: 4 Issues (2002)
Volume 12: 4 Issues (2001)
Volume 11: 4 Issues (2000)
Volume 10: 4 Issues (1999)
Volume 9: 4 Issues (1998)
Volume 8: 4 Issues (1997)
Volume 7: 4 Issues (1996)
Volume 6: 4 Issues (1995)
Volume 5: 4 Issues (1994)
Volume 4: 4 Issues (1993)
Volume 3: 4 Issues (1992)
Volume 2: 4 Issues (1991)
Volume 1: 2 Issues (1990)
View Complete Journal Contents Listing