column

What.s new in SQL:2011

Author:

Fred ZemkeAuthors Info & Claims

ACM SIGMOD Record, Volume 41, Issue 1

Pages 67 - 73

https://doi.org/10.1145/2206869.2206883

Published: 25 April 2012 Publication History

Get Access

Abstract

SQL:2011 was published in December 2011, replacing the former version (SQL:2008) as the most recent update to the SQL standard for relational databases. This paper surveys the new non-temporal features of SQL:2011.

References

[1]

ISO/IEe 9075-1:2011, Information technology-Database languages-SQL-Part 1: Framework (SQLlFramework), 2011

Google Scholar

[2]

ISO/IEe 9075-2:2011, Information technology-Database languages-SQL-Part 2: Foundation (SQLlFoundation), 2011

Google Scholar

[3]

ISO/IEe 9075-3:2008, Information technology-Database languages-SQL-Part 3: Call-Level Interface (SQLlCLI), 2008

Google Scholar

[4]

ISO/IEe 9075-4:2011, Information technology-Database languages-SQL-Part 4: Persistent Stored Modules (SQLlPSM), 2011

Google Scholar

[5]

ISO/IEe 9075-9:2008, Information technology-Database languages-SQL-Part 9: Management of External Data (SQLlMED), 2008

Google Scholar

[6]

ISO/IEe 9075-10:2008, Information technology-Database languages-SQL-Part 10: Object Language Bindings (SQLlOLB), 2008

Google Scholar

[7]

ISO/IEe 9075-11:2011, Information technology-Database languages-SQL-Part 11: Information and Definition Schemas (SQLlSchemata), 2011

Google Scholar

[8]

ISO/IEe 9075-13:2008, Information technology-Database languages-SQL-Part 13: SQL Routines and Types Using the Java™ Programming Language (SQLlJRT), 2008

Google Scholar

[9]

ISO/IEe 9075-14:2011, Information technology-Database languages-SQL-Part 14: XML-Related Specifications (SQLlXML), 2011

Google Scholar

[10]

Andrew Eisenberg and Jim Melton, "SQL:1999, formerly known as SQL3" SIGMOD Record Vol. 28 No. 1 March 1999, zip available at http://www.sigmod.org/publications/sigmod-record/9903/ index.html

Digital Library

Google Scholar

[11]

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 pp. 119-126 http://www.sigmod.org/ publications/sigmod-record/0403/E.JimAndrew-standard.pdf

Digital Library

Google Scholar

[12]

Andrew Eisenberg and Jim Melton, "Advances in SQL/XML", SIGMOD Record Vol. 33 No. 3 Sept. 2004, http://www.sigmod.org/publications/sigmodrecord/0409/11.JimMelton.pdf

Digital Library

Google Scholar

Cited By

View all

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
Spinellis D(2023)Open reproducible scientometric research with Alexandria3kPLOS ONE10.1371/journal.pone.029494618:11(e0294946)Online publication date: 30-Nov-2023
https://doi.org/10.1371/journal.pone.0294946
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
Show More Cited By

Recommendations

Comments

Information & Contributors

Information

Published In

ACM SIGMOD Record Volume 41, Issue 1

March 2012

73 pages

ISSN:0163-5808

DOI:10.1145/2206869

Issue’s Table of Contents

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 25 April 2012

Published in SIGMOD Volume 41, Issue 1

Check for updates

Qualifiers

Column

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

25
Total Citations
View Citations
449
Total Downloads

Downloads (Last 12 months)19
Downloads (Last 6 weeks)0

Reflects downloads up to 30 Aug 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

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
Spinellis D(2023)Open reproducible scientometric research with Alexandria3kPLOS ONE10.1371/journal.pone.029494618:11(e0294946)Online publication date: 30-Nov-2023
https://doi.org/10.1371/journal.pone.0294946
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
Grandi FMandreoli FMartoglia RPenzo W(2022)Unleashing the power of querying streaming data in a temporal database worldInformation Systems10.1016/j.is.2021.101872103:COnline publication date: 22-Apr-2022
https://dl.acm.org/doi/10.1016/j.is.2021.101872
Sutra PShapiro M(2022)Database Consistency ModelsEncyclopedia of Big Data Technologies10.1007/978-3-319-63962-8_203-2(1-12)Online publication date: 24-May-2022
https://doi.org/10.1007/978-3-319-63962-8_203-2
Jung WKwon SShim K(2021)TIDY: Publishing a Time Interval Dataset With Differential PrivacyIEEE Transactions on Knowledge and Data Engineering10.1109/TKDE.2019.295235133:5(2280-2294)Online publication date: 1-May-2021
https://doi.org/10.1109/TKDE.2019.2952351
Hayat S(2020)Modeling and Transformation from Temporal Object Relational Database into Mongodb: RulesAdvances in Science, Technology and Engineering Systems Journal10.25046/aj0504735:4(618-625)Online publication date: 2020
https://doi.org/10.25046/aj050473
Taipalus TSeppänen V(2020)SQL EducationACM Transactions on Computing Education10.1145/339837720:3(1-33)Online publication date: 7-Aug-2020
https://dl.acm.org/doi/10.1145/3398377
Muñoz-Velasco EPelegrín MSala PSciavicco GStan I(2019)On coarser interval temporal logicsArtificial Intelligence10.1016/j.artint.2018.09.001266(1-26)Online publication date: Jan-2019
https://doi.org/10.1016/j.artint.2018.09.001
Shapiro MSutra P(2019)Database Consistency ModelsEncyclopedia of Big Data Technologies10.1007/978-3-319-77525-8_203(591-601)Online publication date: 20-Feb-2019
https://doi.org/10.1007/978-3-319-77525-8_203
Show More Cited By

View Options

Get Access

Login options

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

Cited By

Recommendations

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)

SQL: The Complete Reference, Second Edition

Oracle High-Performance SQL Tuning

Comments

Published In

Publisher

Publication History

Check for updates

Qualifiers

Other Metrics

Article Metrics

Other Metrics

Cited By

Login options

Full Access

PDF

eReader

Abstract

References

Cited By

Recommendations

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)

SQL: The Complete Reference, Second Edition

Oracle High-Performance SQL Tuning

Comments

Information

Published In

Publisher

Publication History

Check for updates

Qualifiers

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

Get Access

Login options

Full Access

View options

PDF

eReader

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations