CFP last date
22 April 2024
Reseach Article

Support of Temporal Data in Database Systems

by Dušan Petković
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 152 - Number 4
Year of Publication: 2016
Authors: Dušan Petković
10.5120/ijca2016911786

Dušan Petković . Support of Temporal Data in Database Systems. International Journal of Computer Applications. 152, 4 ( Oct 2016), 26-33. DOI=10.5120/ijca2016911786

@article{ 10.5120/ijca2016911786,
author = { Dušan Petković },
title = { Support of Temporal Data in Database Systems },
journal = { International Journal of Computer Applications },
issue_date = { Oct 2016 },
volume = { 152 },
number = { 4 },
month = { Oct },
year = { 2016 },
issn = { 0975-8887 },
pages = { 26-33 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume152/number4/26308-2016911786/ },
doi = { 10.5120/ijca2016911786 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T23:57:16.995357+05:30
%A Dušan Petković
%T Support of Temporal Data in Database Systems
%J International Journal of Computer Applications
%@ 0975-8887
%V 152
%N 4
%P 26-33
%D 2016
%I Foundation of Computer Science (FCS), NY, USA
Abstract

The time is generally a challenging task. All issues in relation to time can be better supported using temporal data models. Almost all enterprise database systems have implemented temporal data, partly according to the model specified in the SQL:2011 standard and partly according to other, older temporal models. In this article five temporal concepts will be used to investigate their implementations in enterprise database systems. Also, strengths and weaknesses of these implementations will be discussed.

References
  1. Al-Kateb, M.; Ghazal, A.; CROLOTTE, A. 2012. An Efficient SQL Rewrite Approach for Temporal Coalescing in Teradata, Database and Expert Systems Appl., LNCS 7447.
  2. Allen, J. F. 1983. Maintaining knowledge about temporal intervals, CACM, 832–843
  3. Böhlen, M.; Snodgrass, R.T. and Soo, M. 1996. Coalescing in Temporal Databases, Proc. of 22th Int. Conf. on VLDB
  4. ISO/IEC 9075-2:2011, 2011.Information technology–DB languages–SQL:Part 2.
  5. Nicola, M.; Sommerlandt, M., 2012. Managing time in DB2 with temporal consistency,http://www.ibm.com/developerworks/data/library/techarticle/dm-1207db2temporalintegrity/index.html
  6. Oracle, 2014. Multi-temporal Features in Oracle 12c, http://www.salvis.com/blog/2014/01/04/multi-temporal-database-features-in-oracle-12c/
  7. Petković, D., 2013. Was lange währt, wird endlich gut: Temporale Daten im SQL-Standard,DB-Spektrum,13, 131-8.
  8. Petković, D. 2016. SQL Server 2016: A Beginner’s Guide, Mc-Graw Hill.
  9. Saracco, C.; Nicola, M.; Gandhi, L. 2012. A matter of time:Temporal data management in DB2,www.ibm.com/developerworks/data/library/techarticle/dm-1204db2temporaldata/dm-1204db2temporaldata-pdf.pdf.
  10. Sannik, G. and Daniels, F. 2012. Enabling the Temporal Data Warehouse, http://www.teradata.com/white-papers/Enabling-the-Temporal-Data-Warehouse.
  11. Snodgrass, R. 1995. TSQL2 Temporal Query Language, Springer Verlag.
  12. Snodgrass, R. 2008. A Case Study of Temporal Data, http://www.teradata.com/white-papers/A-Case-Study-of-Temporal-Data-eb6237/?type=WP
  13. Teradata, 2013. Teradata: SQL Functions, Operators and Predicates,http://tunweb.teradata.ws/tunstudent /TeradataUserManuals/SQL_Reference__Functions..pdf.
  14. Wijsen, J. 2006. Temporal Integrity Constraints, http://informatique.umons.ac.be/ssi/jef/tic.pdf
  15. Zhou, X., Wang, F. and Zaniolo, C. 2005. Efficient Temporal Coalescing Query Support in RDBMSs, LNCS 4080.
Index Terms

Computer Science
Information Sciences

Keywords

Database systems temporal model PERIOD type