We apologize for a recent technical issue with our email system, which temporarily affected account activations. Accounts have now been activated. Authors may proceed with paper submissions. PhDFocusTM
CFP last date
20 December 2024
Call for Paper
January Edition
IJCA solicits high quality original research papers for the upcoming January edition of the journal. The last date of research paper submission is 20 December 2024

Submit your paper
Know more
The week's pick
Responsive image
Improved Shuffled Frog Leaping Algorithm with Self-Adaptive Shuffling for Fuzzy Logic PD+G Controller Optimization in Robotic Manipulators

Duc Hoang Nguyen
Random Articles
Reseach Article

Support of Temporal Data in Database Systems

by Dušan Petković
journal cover thumbnail

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

Powered by PhDFocusTM