Research Article
Support of Temporal Data in Database Systems
|
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
|
| Volume 152 - Issue 4 |
| Published: Oct 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 },
year = { 2016 },
volume = { 152 },
number = { 4 },
pages = { 26-33 },
doi = { 10.5120/ijca2016911786 },
publisher = { Foundation of Computer Science (FCS), NY, USA }
}
%0 Journal Article
%D 2016
%A Dušan Petković
%T Support of Temporal Data in Database Systems%T
%J International Journal of Computer Applications
%V 152
%N 4
%P 26-33
%R 10.5120/ijca2016911786
%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
- 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.
- Allen, J. F. 1983. Maintaining knowledge about temporal intervals, CACM, 832–843
- Böhlen, M.; Snodgrass, R.T. and Soo, M. 1996. Coalescing in Temporal Databases, Proc. of 22th Int. Conf. on VLDB
- ISO/IEC 9075-2:2011, 2011.Information technology–DB languages–SQL:Part 2.
- Nicola, M.; Sommerlandt, M., 2012. Managing time in DB2 with temporal consistency,http://www.ibm.com/developerworks/data/library/techarticle/dm-1207db2temporalintegrity/index.html
- Oracle, 2014. Multi-temporal Features in Oracle 12c, http://www.salvis.com/blog/2014/01/04/multi-temporal-database-features-in-oracle-12c/
- Petković, D., 2013. Was lange währt, wird endlich gut: Temporale Daten im SQL-Standard,DB-Spektrum,13, 131-8.
- Petković, D. 2016. SQL Server 2016: A Beginner’s Guide, Mc-Graw Hill.
- 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.
- Sannik, G. and Daniels, F. 2012. Enabling the Temporal Data Warehouse, http://www.teradata.com/white-papers/Enabling-the-Temporal-Data-Warehouse.
- Snodgrass, R. 1995. TSQL2 Temporal Query Language, Springer Verlag.
- Snodgrass, R. 2008. A Case Study of Temporal Data, http://www.teradata.com/white-papers/A-Case-Study-of-Temporal-Data-eb6237/?type=WP
- Teradata, 2013. Teradata: SQL Functions, Operators and Predicates,http://tunweb.teradata.ws/tunstudent /TeradataUserManuals/SQL_Reference__Functions..pdf.
- Wijsen, J. 2006. Temporal Integrity Constraints, http://informatique.umons.ac.be/ssi/jef/tic.pdf
- Zhou, X., Wang, F. and Zaniolo, C. 2005. Efficient Temporal Coalescing Query Support in RDBMSs, LNCS 4080.
Index Terms
Keywords