A Comparative Study of Tuple Timestamped Data Models

Disha Aggarwal, Shailender Kumar


Time is one of the most challenging facet to handle in real world applications. Most applications access or manipulate temporal data so such applications rely on temporal databases which records the time varying data. The objective of this paper is to provide a concise overview on concepts of temporal database and review the work in the field of tuple timestamping data models. The paper introduces the basic of conventional database and then compares it with the temporal database. The paper evaluates different time dimensions and query languages along with them. A comparative analysis of different temporal models is done based on some parameters. Finally, all the temporal models are summarized and a conclusion is given with the future work in the field of temporal database.


database; temporal database; attribute timestamping; tuple timestamping; transaction time; valid time; data models

Full Text:



S. Jensen, J. Clifford, R. Elmasri, S.K. Gadia, P. Hayes, and S. Jajodia “A consensus glossary of temporal database concepts”, eds., Technical Report R 93-2035, Dept. of Mathematics and Computer Science, Inst. for Electronic Systems, Denmark, Nov. 1993.

R. Elmasri and S. Navathe, "Fundamentals of Database Systems", Benjamin/Cummings 1994.

Gultekin Ozsoyoglu, Richard T. Snodgrass, “Temporal and Real-Time Databases: A Survey”, IEEE Transactions on Knowledge and Data Engineering, Vol. 7, No. 4, August 1995.

S.K. Gadia, “A homogeneous relational model and query languages for temporal databases,” ACM Trans. Database Systems, vol. 13, no. 4, pp. 418-448, Dec. 1988.

Nina Edelweiss, Patricia N. Hubler , Mirella M, Moro, and Giovani Demartini, “A Temporal Database Management System Implemented on Top of a Conventional Database”, IEEE International Conference of the Chilean, pp. 58-67, November 2000.

C.S. Jenson and R. T. Snodgrass, “Temporal Data Management”, IEEE Transactions on Knowledge and Data Engineering, 11(1):36-44, January/ February 1999.

Debabrata Dey, Terence M. Barron, and Veda C. Storey, “A conceptual model for the logical design of temporal databases”, Decision Support Systems 15 (1995), pp. 305-321, Elsevier Science B.V 1995.

H. Gregersen and C. S. Jensen, “Temporal Entity-Relationship Models-A Survey”, IEEE Transactions on Knowledge and Data Engineering, Vol. II, Issue 3, pp. 464-497, 1999.

J’an M'at'e and Ji’r’i ' Safa'r'lk, “Transformation of Relational Databases to Transaction-Time Temporal Databases”, IEEE Second Eastern European Regional Conference on the Engineering of Computer Based Systems, 2011.

S.B. Navathe and R. Ahmed, “A temporal relational model and a query language;’ Information Sciences, vol. 49, pp. 147-175, 1989.

Avi Silberschatz, Henry F. Korth, and S. Sudarshan, “Database System Concepts, Sixth Edition”, January 2010.

Vincent S. Lai, Jean-Pierre Kuilboer and Jan L. Guynes, “Temporal Databases: Model Design and Commercialization Prospects”, DATABASE, Vol. 25, No. 3, August 1994.

G. Ariav, “A temporally oriented data model,” ACM Trans. Database Systems, vol. 11, no. 4, pp. 499-527, Dec. 1986.

Shailender Kumar, Rahul Rishi, “Retrieval of Meteorological Data using Temporal Data Modeling”, Indian Journal of Science and Technology, Vol 9(37), October 2016.

J. Ben-Zvi, “The Time Relational Model,” PhD thesis, Computer Science Dept., UCLA, 1982.

Christian S. Jensen, Richard T. Snodgrass, Michael D. Soo, “The TSQL2 Data Model”, IEEE Transaction on Knowledge and Data Engineering, 1994.

A. Segev and A. Shoshani, “Logical modeling of temporal data,” U. Dayal and I. Traiger, eds., Proc. ACM SIGMOD International Conf. Management Data, pp. 454-466, San Francisco, May 1987.

Canan Atay, “An attribute or tuple timestamping in bitemporal relational databases”, Turk J Elec Eng & Comp Sci (2016) 24: 4305 – 4321.

Shailender Kumar, Rahul Rishi, “A relative analysis of modern temporal data models”, 3rd International Conference on Computing for Sustainable Global Development, pp. 2851-2855, March 2016.

DOI: https://doi.org/10.26483/ijarcs.v8i5.3204


  • There are currently no refbacks.

Copyright (c) 2017 International Journal of Advanced Research in Computer Science