CFP last date
20 January 2025
Call for Paper
February Edition
IJCA solicits high quality original research papers for the upcoming February edition of the journal. The last date of research paper submission is 20 January 2025

Submit your paper
Know more
The week's pick
Responsive image
SFLA-Based Line Balancing and Task Optimization in Master-Slave Controlled Hanger Transportation Systems for Garment Production

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