research-article

The New and Improved SQL: 2016 Standard

Authors:

Krishna Kulkarni,

Calisto Zuzarte,

Beda Hammerschmidt,

Fred ZemkeAuthors Info & Claims

ACM SIGMOD Record, Volume 47, Issue 2

Pages 51 - 60

https://doi.org/10.1145/3299887.3299897

Published: 11 December 2018 Publication History

Abstract

SQL:2016 (officially called ISO/IEC 9075:2016, Information technology - Database languages - SQL) was published in December of 2016, replacing SQL:2011 as the most recent revision of the SQL standard. This paper gives an overview of the most important new features in SQL:2016.

References

[1]

ISO/IEC 9075--1:2016, Information technology - Database languages - SQL - Part 1: Framework (SQL/Framework)

[2]

ISO/IEC 9075--2:2016, Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation)

[3]

ISO/IEC 9075--3:2016, Information technology - Database languages - SQL - Part 3: Call-Level Interface (SQL/CLI)

[4]

ISO/IEC 9075--4:2016, Information technology - Database languages - SQL - Part 4: Persistent stored modules (SQL/PSM)

[5]

ISO/IEC 9075--9:2016, Information technology - Database languages - SQL - Part 9: Management of External Data (SQL/MED)

[6]

ISO/IEC 9075--10:2016, Information technology - Database languages - SQL - Part 10: Object language bindings (SQL/OLB)

[7]

ISO/IEC 9075--11:2016, Information technology - Database languages - SQL - Part 11: Information and definition schemas (SQL/Schemata)

[8]

ISO/IEC 9075--13:2016, Information technology - Database languages - SQL - Part 13: SQL Routines and types using the Java programming language (SQL/JRT)

[9]

ISO/IEC 9075--14:2016, Information technology - Database languages - SQL - Part 14: XML-Related Specifications (SQL/XML)

[10]

ISO/IEC TR 19075--1:2011, Information technology - Database languages - SQL Technical Reports - Part 1: XQuery Regular Expression Support in SQL, http://standards.iso.org/ittf/PubliclyAvailableStandards/

[11]

ISO/IEC TR 19075--2:2015, Information technology - Database languages - SQL Technical Reports - Part 2: SQL Support for Time-Related Information, http://standards.iso.org/ittf/PubliclyAvailableStandards/

[12]

ISO/IEC TR 19075--3:2015, Information technology - Database languages - SQL Technical Reports - Part 3: SQL Embedded in Programs using the JavaTM programming language, http://standards.iso.org/ittf/PubliclyAvailableStandards/

[13]

ISO/IEC TR 19075--4:2015, Information technology - Database languages - SQL Technical Reports - Part 4: SQL with Routines and types using the JavaTM programming language, http://standards.iso.org/ittf/PubliclyAvailableStandards/

[14]

ISO/IEC TR 19075--5:2016, Information technology - Database languages - SQL Technical Reports - Part 5: Row Pattern Recognition in SQL, http://standards.iso.org/ittf/PubliclyAvailableStandards/

[15]

ISO/IEC TR 19075--6:2017, Information technology - Database languages - SQL Technical Reports - Part 6: SQL support for JavaScript Object Notation (JSON), http://standards.iso.org/ittf/PubliclyAvailableStandards/

[16]

ISO/IEC TR 19075--7:2017, Information technology - Database languages - SQL Technical Reports - Part 7: Polymorphic table functions in SQL, http://standards.iso.org/ittf/PubliclyAvailableStandards/

[17]

Krishna Kulkarni and Jan-Eike Michels, "Temporal features in SQL:2011", SIGMOD Record Vol. 41 No. 3, September 2012, https://sigmodrecord.org/publications/sigmodRecord/12 09/pdfs/07.industry.kulkarni.pdf

Digital Library

[18]

Fred Zemke, "What's new in SQL:2011", SIGMOD Record, Vol. 41, No. 1, March 2012, https://sigmodrecord.org/publications/sigmodRecord/12 03/pdfs/10.industry.zemke.pdf

Digital Library

[19]

Andrew Eisenberg and Jim Melton, "Advancements in SQL/XML", SIGMOD Record Vol. 33 No. 3, September 2004, https://sigmodrecord.org/publications/sigmodRecord/04 09/11.JimMelton.pdf

Digital Library

[20]

Andrew Eisenberg, Jim Melton, Krishna Kulkarni, Jan- Eike Michels, and Fred Zemke, "SQL:2003 has been published", SIGMOD Record Vol. 33 No. 1, March 2004, https://sigmodrecord.org/publications/sigmodRecord/04 03/E.JimAndrew-standard.pdf

Digital Library

[21]

Jim Melton, Jan-Eike Michels, Vanja Josifovski, Krishna Kulkarni, Peter Schwarz, Kathy Zeidenstein, "SQL and Management of External Data", SIGMOD Record Vol. 30 No. 1, March 2001, https://sigmodrecord.org/publications/sigmodRecord/01 03/JM-Sta.pdf

Digital Library

[22]

Andrew Eisenberg and Jim Melton, "SQL:1999, formerly known as SQL3", SIGMOD Record Vol. 28 No. 1, March 1999, https://sigmodrecord.org/publications/sigmodRecord/99 03/standards.pdf.gz

Digital Library

[23]

Andrew Eisenberg, "New Standard for Stored Procedures in SQL", SIGMOD Record Vol 25 No. 4, Dec.1996, https://sigmodrecord.org/issues/96- 12/sqlpsm.ps

Digital Library

[24]

Internet Engineering Task Force, RFC 7159, The JavaScript Object Notation (JSON) Data Interchange Format, March 2014, https://tools.ietf.org/html/rfc7159

Cited By

Brahmia ZGrandi FOliboni B(2024)Schema Versioning in Databases: A Literature ReviewComputing Open10.1142/S297237012430002402Online publication date: 30-Nov-2024
https://doi.org/10.1142/S2972370124300024
Brahmia ZGrandi FOliboni B(2024)A Literature Review on Schema Evolution in DatabasesComputing Open10.1142/S297237012430001202Online publication date: 12-Jul-2024
https://doi.org/10.1142/S2972370124300012
Brahmia ZGrandi FBrahmia SBouaziz R(2024) JUpdate: An update language for time-varying JSON data Journal of Computer Languages10.1016/j.cola.2024.10125879(101258)Online publication date: Jun-2024
https://doi.org/10.1016/j.cola.2024.101258
Show More Cited By

Recommendations

SQL: From Traditional Databases to Big Data
SIGCSE '16: Proceedings of the 47th ACM Technical Symposium on Computing Science Education

The Structured Query Language (SQL) is the main programing language designed to manage data stored in database systems. While SQL was initially used only with relational database management systems (RDBMS), its use has been significantly extended with ...
SQL: 1999, formerly known as SQL3

For several years now, you've been hearing and reading about an emerging standard that everybody has been calling SQL3. Intended as a major enhancement of the current second generation SQL standard, commonly called SQL-92 because of the year it was ...
Sql: Learn Basics of Queries and Implement Easily (sql programming, SQL 2016, sql database programming, sql for beginners, sql beginners guide, sql ... sql workbook, sql guide, MSSQL) (Volume 1)

Comments

Information & Contributors

Information

Published In

cover image ACM SIGMOD Record

ACM SIGMOD Record Volume 47, Issue 2

June 2018

68 pages

ISSN:0163-5808

DOI:10.1145/3299887

Editors:
Yanlei Diao
University of Massachusetts Amherst
,
Vanessa Braganholo
Universidade Federal Fluminense
,
Marco Brambilla
Politecnico di Milano
,
Chee Yong Chan
National University of Singapore
,
Rada Chirkova
North Carolina State University
,
Zackary Ives
University of Pennsylvania
,
Anastasios Kementsietsidis
Google Research
,
Jeffrey Naughton
University of Wisconsin-Madison
,
Frank Neven
Hasselt University
,
Olga Papaemmanoui
Brandeis Univesity
,
Aditya Parameswaran
University of Illinois
,
Alkis Simitsis
HP Labs
,
Wang-Chiew Tan
University of California Santa Cruz
,
Pinar Tözü
IBM Almaden Research Center
,
Marianne Winslett
University of Illinois
,
Jun Yang
Duke University

Issue’s Table of Contents

Copyright © 2018 Authors.

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 11 December 2018

Published in SIGMOD Volume 47, Issue 2

Check for updates

Qualifiers

Research-article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

14
Total Citations
View Citations
474
Total Downloads

Downloads (Last 12 months)47
Downloads (Last 6 weeks)4

Reflects downloads up to 08 Mar 2025

Other Metrics

View Author Metrics

Citations

Cited By

Brahmia ZGrandi FOliboni B(2024)Schema Versioning in Databases: A Literature ReviewComputing Open10.1142/S297237012430002402Online publication date: 30-Nov-2024
https://doi.org/10.1142/S2972370124300024
Brahmia ZGrandi FOliboni B(2024)A Literature Review on Schema Evolution in DatabasesComputing Open10.1142/S297237012430001202Online publication date: 12-Jul-2024
https://doi.org/10.1142/S2972370124300012
Brahmia ZGrandi FBrahmia SBouaziz R(2024) JUpdate: An update language for time-varying JSON data Journal of Computer Languages10.1016/j.cola.2024.10125879(101258)Online publication date: Jun-2024
https://doi.org/10.1016/j.cola.2024.101258
Caglayan BWang MKelleher JFei STong GDing JZhang P(2024)BIS: NL2SQL Service Evaluation Benchmark for Business Intelligence ScenariosService-Oriented Computing10.1007/978-981-96-0808-9_27(357-372)Online publication date: 7-Dec-2024
https://doi.org/10.1007/978-981-96-0808-9_27
Ritu TNag ABairagi ARahman A(2024)Digital Twins for Healthcare in Industry 5.0: Fundamentals, Pharmaceutical Manufacturing Applications, Diagnostic Precision, Digital Patient Innovations, and Drug Discovery ImpactSoft Computing in Industry 5.0 for Sustainability10.1007/978-3-031-69336-6_16(357-376)Online publication date: 16-Nov-2024
https://doi.org/10.1007/978-3-031-69336-6_16
Hu YJiang HTang HLin XHu Z(2023)SQL#: A Language for Maintainable and Debuggable Database QueriesInternational Journal of Software Engineering and Knowledge Engineering10.1142/S021819402350010933:05(619-649)Online publication date: 13-Apr-2023
https://doi.org/10.1142/S0218194023500109
Fang JLychagin DCarey MTsotras V(2023)A new window Clause for SQL++The VLDB Journal10.1007/s00778-023-00830-z33:3(595-623)Online publication date: 19-Dec-2023
https://doi.org/10.1007/s00778-023-00830-z
Petković D(2022)Specification of Row Pattern Recognition in the SQL Standard and its ImplementationsDatenbank-Spektrum10.1007/s13222-022-00404-322:2(163-174)Online publication date: 18-Feb-2022
https://doi.org/10.1007/s13222-022-00404-3
Brahmia ZGrandi FBrahmia SBouaziz R(2022)JUpdate: A Temporal Update Language for JSON DataModel and Data Engineering10.1007/978-3-031-21595-7_18(250-263)Online publication date: 21-Nov-2022
https://dl.acm.org/doi/10.1007/978-3-031-21595-7_18
Pintor PCosta RMoreira J(2022)Why- and How-Provenance in Distributed EnvironmentsDatabase and Expert Systems Applications10.1007/978-3-031-12423-5_8(103-115)Online publication date: 22-Aug-2022
https://dl.acm.org/doi/10.1007/978-3-031-12423-5_8
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Figures

Tables

Media

View Issue’s Table of Contents