{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,5,7]],"date-time":"2026-05-07T16:30:52Z","timestamp":1778171452383,"version":"3.51.4"},"reference-count":17,"publisher":"Association for Computing Machinery (ACM)","issue":"2","license":[{"start":{"date-parts":[[2018,12,11]],"date-time":"2018-12-11T00:00:00Z","timestamp":1544486400000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["SIGMOD Rec."],"published-print":{"date-parts":[[2018,12,11]]},"abstract":"<jats:p>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.<\/jats:p>","DOI":"10.1145\/3299887.3299897","type":"journal-article","created":{"date-parts":[[2018,12,12]],"date-time":"2018-12-12T12:49:32Z","timestamp":1544618972000},"page":"51-60","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":23,"title":["The New and Improved SQL"],"prefix":"10.1145","volume":"47","author":[{"given":"Jan","family":"Michels","sequence":"first","affiliation":[{"name":"Oracle Corporation, Redwood Shores, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Keith","family":"Hare","sequence":"additional","affiliation":[{"name":"JCC Consulting, Granville, OH, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Krishna","family":"Kulkarni","sequence":"additional","affiliation":[{"name":"SQL Consultant, San Francisco, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Calisto","family":"Zuzarte","sequence":"additional","affiliation":[{"name":"IBM Corporation, Armonk, NY, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Zhen Hua","family":"Liu","sequence":"additional","affiliation":[{"name":"Oracle Corporation, Redwood Shores, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Beda","family":"Hammerschmidt","sequence":"additional","affiliation":[{"name":"Oracle Corporation, Redwood Shores, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Fred","family":"Zemke","sequence":"additional","affiliation":[{"name":"Oracle Corporation, Redwood Shores, CA, USA"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2018,12,11]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"ISO\/IEC 9075--1:2016 Information technology - Database languages - SQL - Part 1: Framework (SQL\/Framework)  ISO\/IEC 9075--1:2016 Information technology - Database languages - SQL - Part 1: Framework (SQL\/Framework)"},{"key":"e_1_2_1_2_1","volume-title":"Information technology - Database languages - SQL - Part 2: Foundation","author":"IEC","unstructured":"ISO\/ IEC 9075--2:2016 , Information technology - Database languages - SQL - Part 2: Foundation ( SQL\/Foundation) ISO\/IEC 9075--2:2016, Information technology - Database languages - SQL - Part 2: Foundation (SQL\/Foundation)"},{"key":"e_1_2_1_3_1","unstructured":"ISO\/IEC 9075--3:2016 Information technology - Database languages - SQL - Part 3: Call-Level Interface (SQL\/CLI)  ISO\/IEC 9075--3:2016 Information technology - Database languages - SQL - Part 3: Call-Level Interface (SQL\/CLI)"},{"key":"e_1_2_1_4_1","unstructured":"ISO\/IEC 9075--4:2016 Information technology - Database languages - SQL - Part 4: Persistent stored modules (SQL\/PSM)  ISO\/IEC 9075--4:2016 Information technology - Database languages - SQL - Part 4: Persistent stored modules (SQL\/PSM)"},{"key":"e_1_2_1_5_1","unstructured":"ISO\/IEC 9075--9:2016 Information technology - Database languages - SQL - Part 9: Management of External Data (SQL\/MED)  ISO\/IEC 9075--9:2016 Information technology - Database languages - SQL - Part 9: Management of External Data (SQL\/MED)"},{"key":"e_1_2_1_6_1","unstructured":"ISO\/IEC 9075--10:2016 Information technology - Database languages - SQL - Part 10: Object language bindings (SQL\/OLB)  ISO\/IEC 9075--10:2016 Information technology - Database languages - SQL - Part 10: Object language bindings (SQL\/OLB)"},{"key":"e_1_2_1_7_1","unstructured":"ISO\/IEC 9075--11:2016 Information technology - Database languages - SQL - Part 11: Information and definition schemas (SQL\/Schemata)  ISO\/IEC 9075--11:2016 Information technology - Database languages - SQL - Part 11: Information and definition schemas (SQL\/Schemata)"},{"key":"e_1_2_1_8_1","unstructured":"ISO\/IEC 9075--13:2016 Information technology - Database languages - SQL - Part 13: SQL Routines and types using the Java programming language (SQL\/JRT)  ISO\/IEC 9075--13:2016 Information technology - Database languages - SQL - Part 13: SQL Routines and types using the Java programming language (SQL\/JRT)"},{"key":"e_1_2_1_9_1","unstructured":"ISO\/IEC 9075--14:2016 Information technology - Database languages - SQL - Part 14: XML-Related Specifications (SQL\/XML)  ISO\/IEC 9075--14:2016 Information technology - Database languages - SQL - Part 14: XML-Related Specifications (SQL\/XML)"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/2380776.2380786"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1145\/2206869.2206883"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/1031570.1031588"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1145\/974121.974142"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1145\/373626.373709"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/309844.310075"},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/245882.245907"},{"key":"e_1_2_1_24_1","volume-title":"March","author":"Internet Engineering Task Force","year":"2014","unstructured":"Internet Engineering Task Force , RFC 7159 , The JavaScript Object Notation (JSON) Data Interchange Format , March 2014 , https:\/\/tools.ietf.org\/html\/rfc7159 Internet Engineering Task Force, RFC 7159, The JavaScript Object Notation (JSON) Data Interchange Format, March 2014, https:\/\/tools.ietf.org\/html\/rfc7159"}],"container-title":["ACM SIGMOD Record"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3299887.3299897","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3299887.3299897","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,17]],"date-time":"2025-06-17T23:53:38Z","timestamp":1750204418000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3299887.3299897"}},"subtitle":["2016 Standard"],"short-title":[],"issued":{"date-parts":[[2018,12,11]]},"references-count":17,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2018,12,11]]}},"alternative-id":["10.1145\/3299887.3299897"],"URL":"https:\/\/doi.org\/10.1145\/3299887.3299897","relation":{},"ISSN":["0163-5808"],"issn-type":[{"value":"0163-5808","type":"print"}],"subject":[],"published":{"date-parts":[[2018,12,11]]},"assertion":[{"value":"2018-12-11","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}