column

Temporal features in SQL:2011

Authors:

Krishna Kulkarni,

Jan-Eike MichelsAuthors Info & Claims

ACM SIGMOD Record, Volume 41, Issue 3

Pages 34 - 43

https://doi.org/10.1145/2380776.2380786

Published: 05 October 2012 Publication History

Get Access

Abstract

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.

References

[1]

Fred Zemke, "What's new in SQL:2011", SIGMOD Record, Vol. 41, No. 1, March 2012, pp. 67--73, http://www.sigmod.org/publications/sigmod-record/1203/pdfs/10.industry.zemke.pdf/

Digital Library

Google Scholar

[2]

Yu Wu, Sushil Jajodia, X. Sean Wang, "Temporal Database Bibliography Update", In Temporal Databases: Research and Practice, O. Etzion, S. Jajodia, and S.Sripada, eds., Springer, 1998

Google Scholar

[3]

Richard Snodgrass, "Developing Time-Oriented Database Applications in SQL", Morgan Kaufmann, 1999

Digital Library

Google Scholar

[4]

C. J. Date, Hugh Darwen, Nikos A. Lorentzos, "Temporal Data and the Relational Model", Morgan Kaufman, 2003

Digital Library

Google Scholar

[5]

Cynthia Saracco, Matthias Nicola, Lenisha Gandhi, "A matter of time: Temporal data management in DB2 10", April 2012, http://www.ibm.com/developerworks/data/library/techarticle/dm-1204db2temporaldata/

Google Scholar

[6]

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

Google Scholar

[7]

Gregory Sannik, Fred Daniels, "Enabling the Temporal Data Warehouse", September 2010, http://www.teradata.com/white-papers/

Google Scholar

[8]

Richard Snodgrass (Ed.), "The TSQL2 Temporal Query Language", Kluwer Academic Publishers, 1995

Digital Library

Google Scholar

[9]

Hugh Darwen, C.J. Date, "An overview and Analysis of Proposals Based on the TSQL2 Approach", In Date on Database: Writings 2000-2006, C.J. Date, Apress, 2006, also avaliable in http://www.dcs.warwick.ac.uk/~hugh/TTM/OnTSQL2.pdf

Google Scholar

[10]

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

Google Scholar

[11]

James F. Allen, "Maintaining knowledge about temporal intervals", Communications of ACM, Vol. 26, No. 11, November 1983

Digital Library

Google Scholar

[12]

Michael Bohlen, Christian Jensen, Richard Snodgrass, "Temporal Statement Modifiers", ACM Trans. on Database Systems, Vol. 25, No. 4, December 2000

Digital Library

Google Scholar

Cited By

View all

Baumstark AJibril MSattler K(2025)Temporal graph processing in modern memory hierarchiesInformation Systems10.1016/j.is.2024.102462127(102462)Online publication date: Jan-2025
https://doi.org/10.1016/j.is.2024.102462
Tseng FChou A(2024)Temporal Data Processing: Problems, Realities and Perspectives—A Practical LookProceedings of the 2024 8th International Conference on Medical and Health Informatics10.1145/3673971.3673987(281-285)Online publication date: 17-May-2024
https://dl.acm.org/doi/10.1145/3673971.3673987
Dyreson CShatnawi ABhowmick SSharma V(2024)Temporal JSON Keyword SearchProceedings of the ACM on Management of Data10.1145/36549802:3(1-27)Online publication date: 30-May-2024
https://dl.acm.org/doi/10.1145/3654980
Show More Cited By

Index Terms

Temporal features in SQL:2011
1. Information systems
  1. Data management systems
    1. Query languages
2. Theory of computation
  1. Theory and algorithms for application domains
    1. Database theory
      1. Database query languages (principles)

Recommendations

Comments

Information & Contributors

Information

Published In

ACM SIGMOD Record Volume 41, Issue 3

September 2012

49 pages

ISSN:0163-5808

DOI:10.1145/2380776

Issue’s Table of Contents

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 05 October 2012

Published in SIGMOD Volume 41, Issue 3

Check for updates

Qualifiers

Column

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

135
Total Citations
View Citations
720
Total Downloads

Downloads (Last 12 months)49
Downloads (Last 6 weeks)12

Reflects downloads up to 09 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Baumstark AJibril MSattler K(2025)Temporal graph processing in modern memory hierarchiesInformation Systems10.1016/j.is.2024.102462127(102462)Online publication date: Jan-2025
https://doi.org/10.1016/j.is.2024.102462
Tseng FChou A(2024)Temporal Data Processing: Problems, Realities and Perspectives—A Practical LookProceedings of the 2024 8th International Conference on Medical and Health Informatics10.1145/3673971.3673987(281-285)Online publication date: 17-May-2024
https://dl.acm.org/doi/10.1145/3673971.3673987
Dyreson CShatnawi ABhowmick SSharma V(2024)Temporal JSON Keyword SearchProceedings of the ACM on Management of Data10.1145/36549802:3(1-27)Online publication date: 30-May-2024
https://dl.acm.org/doi/10.1145/3654980
de la Rúa Martínez JBuso FKouzoupis AOrmenisan ANiazi SBzhalava DMak KJouffrey VRonström MCunningham RZangis RMukhedkar DKhazanchi AVlassov VDowling JBarcelo PSanchez-Pi NMeliou ASudarshan S(2024)The Hopsworks Feature Store for Machine LearningCompanion of the 2024 International Conference on Management of Data10.1145/3626246.3653389(135-147)Online publication date: 9-Jun-2024
https://dl.acm.org/doi/10.1145/3626246.3653389
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
Tansel A(2024)Temporal data modelling and integrity constraints in relational databases*International Journal of Computer Mathematics: Computer Systems Theory10.1080/23799927.2023.23000839:1(1-20)Online publication date: 31-Jan-2024
https://doi.org/10.1080/23799927.2023.2300083
Marini GGoncalves JVelloso EJurdak RKostakos V(2024)A toolkit for localisation queriesPervasive and Mobile Computing10.1016/j.pmcj.2024.101946103:COnline publication date: 1-Oct-2024
https://dl.acm.org/doi/10.1016/j.pmcj.2024.101946
Zhang CLi JJiang S(2024)Durable reverse top-k queries on time-varying preferenceWorld Wide Web10.1007/s11280-024-01293-027:5Online publication date: 2-Aug-2024
https://dl.acm.org/doi/10.1007/s11280-024-01293-0
Khnaisser CHamrouni HBlumenthal DDignös AGamper J(2024)Efficiently Labeling and Retrieving Temporal Anomalies in Relational DatabasesInformation Systems Frontiers10.1007/s10796-024-10495-wOnline publication date: 31-May-2024
https://doi.org/10.1007/s10796-024-10495-w
Orlando DOrmachea JSoliani VVaisman A(2024)TGV: A Visualization Tool for Temporal Property Graph DatabasesInformation Systems Frontiers10.1007/s10796-023-10426-126:4(1543-1564)Online publication date: 1-Aug-2024
https://dl.acm.org/doi/10.1007/s10796-023-10426-1
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

Index Terms

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

Index Terms

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