{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,11]],"date-time":"2026-03-11T00:47:07Z","timestamp":1773190027081,"version":"3.50.1"},"reference-count":12,"publisher":"Association for Computing Machinery (ACM)","issue":"3","license":[{"start":{"date-parts":[[2012,10,5]],"date-time":"2012-10-05T00:00:00Z","timestamp":1349395200000},"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":[[2012,10,5]]},"abstract":"<jats:p>SQL:2011 was published in December of 2011, replacing SQL:2008 as the most recent revision of the SQL standard. This paper covers the most important new functionality that is part of SQL:2011: the ability to create and manipulate temporal tables.<\/jats:p>","DOI":"10.1145\/2380776.2380786","type":"journal-article","created":{"date-parts":[[2012,10,5]],"date-time":"2012-10-05T18:23:12Z","timestamp":1349461392000},"page":"34-43","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":143,"title":["Temporal features in SQL:2011"],"prefix":"10.1145","volume":"41","author":[{"given":"Krishna","family":"Kulkarni","sequence":"first","affiliation":[{"name":"IBM Corporation"}]},{"given":"Jan-Eike","family":"Michels","sequence":"additional","affiliation":[{"name":"IBM Corporation"}]}],"member":"320","published-online":{"date-parts":[[2012,10,5]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1145\/2206869.2206883"},{"key":"e_1_2_1_2_1","volume-title":"Temporal Databases: Research and Practice","author":"Wu Yu","year":"1998"},{"key":"e_1_2_1_3_1","unstructured":"Richard Snodgrass \"Developing Time-Oriented Database Applications in SQL\" Morgan Kaufmann 1999   Richard Snodgrass \"Developing Time-Oriented Database Applications in SQL\" Morgan Kaufmann 1999"},{"key":"e_1_2_1_4_1","volume-title":"Morgan Kaufman","author":"Date C. J.","year":"2003"},{"key":"e_1_2_1_5_1","volume-title":"April","author":"Saracco Cynthia","year":"2012"},{"key":"e_1_2_1_6_1","unstructured":"Kevin Jerrigan \"Oracle Total Recall with Oracle Database 11g Release 2\" September 2009 http:\/\/www.oracle.com\/us\/products\/database\/security\/total-recall-whitepaper-171749.pdf  Kevin Jerrigan \"Oracle Total Recall with Oracle Database 11g Release 2\" September 2009 http:\/\/www.oracle.com\/us\/products\/database\/security\/total-recall-whitepaper-171749.pdf"},{"key":"e_1_2_1_7_1","unstructured":"Gregory Sannik Fred Daniels \"Enabling the Temporal Data Warehouse\" September 2010 http:\/\/www.teradata.com\/white-papers\/  Gregory Sannik Fred Daniels \"Enabling the Temporal Data Warehouse\" September 2010 http:\/\/www.teradata.com\/white-papers\/"},{"key":"e_1_2_1_8_1","doi-asserted-by":"crossref","DOI":"10.1007\/978-1-4615-2289-8","volume-title":"The TSQL2 Temporal Query Language","author":"Snodgrass Richard","year":"1995"},{"key":"e_1_2_1_9_1","volume-title":"Date","author":"Darwen Hugh","year":"2006"},{"key":"e_1_2_1_10_1","volume-title":"Information technology-Database languages--SQL--Part 2: Foundation","author":"IEC","year":"2011"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/182.358434"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1145\/377674.377665"}],"container-title":["ACM SIGMOD Record"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2380776.2380786","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/2380776.2380786","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T20:00:39Z","timestamp":1750276839000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2380776.2380786"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2012,10,5]]},"references-count":12,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2012,10,5]]}},"alternative-id":["10.1145\/2380776.2380786"],"URL":"https:\/\/doi.org\/10.1145\/2380776.2380786","relation":{},"ISSN":["0163-5808"],"issn-type":[{"value":"0163-5808","type":"print"}],"subject":[],"published":{"date-parts":[[2012,10,5]]},"assertion":[{"value":"2012-10-05","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}