Abstract
Among various models like TSQL2, XML and SQL:2003 for temporal databases, TSQL2 is perhaps the most comprehensive one and introduces new constructs for temporal query support. However, these constructs mask the user from the underlying conceptual model and essentially provides a “black box” flavour. Further, the temporal attributes are not directly accessible. In this paper, we propose a “chronon” based conceptual (relational) model, which works on a tuple timestamping paradigm. Here, the time attribute is treated in similar fashion as any other attribute and is available to the user for inclusion in SQL statements, making the model easy to understand and use. A corresponding efficient physical model based on the attribute versioning format akin to XML/SQL:2003 has also been proposed and the mapping between the proposed conceptual and physical models has been described. We evaluate the model by comparing with TSQL2 and SQL:2003.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Jensen, C.S., et al.: A consensus test suite of temporal database queries (1993), ftp://ftp.cs.arizona.edu/tsql/doc/testSuite.ps
Jensen, C.S., Snodgrass, R.T.: Semantics of Time Varying Information. Information Systems 19(4) (1994)
Wang, F., Zaniolo, C.: XBiT: An XML-based Bitemporal Data Model. In: Atzeni, P., Chu, W., Lu, H., Zhou, S., Ling, T.-W. (eds.) ER 2004. LNCS, vol. 3288, Springer, Heidelberg (2004)
Wang, F., Zaniolo, C., Zhou, X.: Temporal XML? SQL Strikes Back! In: 12th International Symposium on Temporal Representation and Reasoning (TIME) (June 2005)
Wang, F., Zaniolo, C.: An XML-Based Approach to Publishing and Querying the History of Databases. Internet and Web Information Systems 8(3) (September 2005)
Allen, G., Bajaj, A., Khatri, V., Ram, S., Siau, K.: Advances in Data Modeling Reasearch. Communications of the Association of Information Systems 17 (2006)
Gregerson, H., Jensen, C.S.: Temporal Entity-Relationship Models – A Survey. IEEE transactions on knowledge and Data Engineering 11(3) (1999)
Clifford, J., Dyreson, C., Isakowitz, T., Jensen, C.S., Snodgrass, R.T.: On the Semantics of now in Databases. ACM transactions on database systems 22(2) (June 1997)
Bohlen, M.H., Snodgrass, R.T., Soo, M.T.: Coalescing in Temporal Databases. In: VLDB (1996)
Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems. Pearson Education, London (2003)
Snodgrass, R.T., Ahn, I.: A Taxonomy of Time in Databases. In: ACM SIGMOD International Conference on Management of Data (1985)
Snodgrass, R.T.: The TSQL2 Temporal Query Language. Springer publication, Heidelberg (1995)
Snodgrass, R.T.: Managing temporal data – a five part series., Database programming and design, TimeCenter technical report (1998)
Snodgrass, R.T., Bohlen, M.H., Jensen, C.S., Steiner, A.: Transitioning temporal support in TSQL2 to SQL3. Temporal Databases: Research and Practice, 150–194 (1998)
Snodgrass, R.T.: Developing Time Oriented Database Applications in SQL. Morgan Kaufmann Publishers, San Fransisco, California (2000)
Snodgrass, R.T.: Official website in University of Arizona, http://www.cs.arizona.edu/~rts/sql3.html
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2008 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Anurag, D., Sen, A.K. (2008). The Chronon Based Model for Temporal Databases. In: Haritsa, J.R., Kotagiri, R., Pudi, V. (eds) Database Systems for Advanced Applications. DASFAA 2008. Lecture Notes in Computer Science, vol 4947. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-78568-2_35
Download citation
DOI: https://doi.org/10.1007/978-3-540-78568-2_35
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-78567-5
Online ISBN: 978-3-540-78568-2
eBook Packages: Computer ScienceComputer Science (R0)