A Comparative Study of Tuple Timestamped Data Models

Article Sidebar

PDF
Published: Jun 20, 2017
DOI: https://doi.org/10.26483/ijarcs.v8i5.3204
Keywords:
database, temporal database, attribute timestamping, tuple timestamping, transaction time, valid time, data models

Main Article Content

Disha Aggarwal
Ambedkar Institute of Advanced Communication Technologies & Research, Geeta Colony, Delhi-110031
Shailender Kumar
Ambedkar Institute of Advanced Communication Technologies & Research, Geeta Colony, Delhi-110031

Abstract

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.

Downloads

Download data is not yet available.

Article Details

Issue
Vol. 8 No. 5 (2017): May-June 2017
Section
Articles

COPYRIGHT

Submission of a manuscript implies: that the work described has not been published before, that it is not under consideration for publication elsewhere; that if and when the manuscript is accepted for publication, the authors agree to automatic transfer of the copyright to the publisher.

Authors who publish with this journal agree to the following terms:

  • Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
  • Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
  • Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work
  • The journal allows the author(s) to retain publishing rights without restrictions.
  • The journal allows the author(s) to hold the copyright without restrictions.
Author Biographies

Disha Aggarwal, Ambedkar Institute of Advanced Communication Technologies & Research, Geeta Colony, Delhi-110031

Department of Computer Science and Engineering

Shailender Kumar, Ambedkar Institute of Advanced Communication Technologies & Research, Geeta Colony, Delhi-110031

Associate Professor, Department of Computer Science and Engineering

References

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.