Abstract
SQL, a data sublanguage used to access relational databases, is sometimes described as “English-like” because many of its statements read a bit like English. It is a non-procedural language since complex data operations are formulated by specifying their intended result rather than the method used to obtain that result. Both ANSI and ISO have published three generations of the de jure SQL standards. The syntax and semantics of SQL is examined and the conformance requirements are stated; a few components of the language are considered in greater detail and the future of the language is outlined.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
ANSI, ANSI X3.135–1986, American National Standard for Information Systems - Database Language SQL, American National Standards Institute, 1986
ANSI, ANSI X3.135–1989, American National Standard for Information Systems - Database Language SQL with Integrity Enhancement, American National Standards Institute, 1989
ANSI, ANSI X3.168–1989, American National Standard for Information Systems - Database Language Embedded SQL, American National Standards Institute, 1989
ANSI, ANSI X3.135–1992, American National Standard for Information Systems - Database Language SQL, American National Standards Institute, 1992
CB74] Chamberlin, D. D., Boyce, R. F., SEQUEL: A Structured English Query Language, Proceedings of the ACM SIGFIDET Workshop, 1974, 249264
Cannan, S., Otten, G., SQL - The Standard Handbook, McGraw-Hill Book Company, 1993
Codd, E. F., A Relational Model of Data for Large Shared Data Banks, Communications of the ACM (13,6), 1974, 377–387
Data Base Task Group Report to the CODASYL Programming Language Committee, ACM, New York, 1971
Date, C. J., Darwen, A Guide to the SQL Standard, Addison-Wesley Publishing Company, 1993
Gray, J., Reuter, A., Transaction Processing: Concepts and Techniques, Morgan Kaufmann Publishers, San Mateo, CA, 1993
Melton, J., Simon, A. R., Understanding the New SQL: A Complete Guide, Morgan Kauffman Publishers, 1993
ISO, ISO 9075:1987, Database languages — SQL, International Organization for Standardization, 1987
ISO, ISO/IEC 9075:1989, Information technology — Database languages — SQL, International Organization for Standardization, 1989
ISO, ISO/IEC 9075:1992, Information technology — Database languages — SQL, International Organization for Standardization, 1992
ISO, ISO/IEC 9075–3:1995, Information technology — Database languages — SQL — Part 3: Call-Level Interface (SQL/CLI ), International Organization for Standardization, 1995
ISO, ISO/IEC 9075–4, Information technology — Database languages — SQL — Part 4: Persistent Stored Modules ( SQL/PSM ), International Organization for Standardization, 1996
ISO, ISO/IEC CD 9075–2, Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation), International Organization for Standardization, 1997
ISO, ISO/IEC CD 9075–5, Information technology — Database languages — SQL — Part 5: Host language bindings ( SQL/Bindings ), International Organization for Standardization, 1997
X/Open, CAE Specification — Structured Query Language (SQL), X/Open Company Ltd., 1993
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1998 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Melton, J. (1998). Database Language SQL. In: Bernus, P., Mertins, K., Schmidt, G. (eds) Handbook on Architectures of Information Systems. International Handbooks on Information Systems. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-662-03526-9_5
Download citation
DOI: https://doi.org/10.1007/978-3-662-03526-9_5
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-662-03528-3
Online ISBN: 978-3-662-03526-9
eBook Packages: Springer Book Archive