Research Article Open Access

Retrieval Optimization Technique for Tuple Timestamp Historical Relation Temporal Data Model

Sami M. Halawani1, Ibrahim AlBidewi1, Ab Rahman Ahmad2 and Nashwan A. Al-Romema1
  • 1 ,
  • 2 , Afganistan
Journal of Computer Science
Volume 8 No. 2, 2012, 243-250

DOI: https://doi.org/10.3844/jcssp.2012.243.250

Submitted On: 2 October 2011 Published On: 9 December 2011

How to Cite: Halawani, S. M., AlBidewi, I., Ahmad, A. R. & Al-Romema, N. A. (2012). Retrieval Optimization Technique for Tuple Timestamp Historical Relation Temporal Data Model. Journal of Computer Science, 8(2), 243-250. https://doi.org/10.3844/jcssp.2012.243.250

Abstract

Problem statement: In the field of database technology, Recoding time related data are referred to as temporal databases. Conventional relational databases are queried using the underlying constructs of SQL which are translated into Relational Algebra (RA). Relational Algebra (RA) is the writing of logical expressions that uses a set of relational operators to perform operations on specific relation(s) and returns results as relation. RA operations are not applied on querying temporal database, because temporal database holds a sequence of snapshot relations. Approach: This study focuses on the retrieval of temporal database, by extending RA to TRA. TRA is involved to help querying temporal database that is modeled using Tuple Timestamp Historical Relation (TTHR) Model. Results: A technique for querying temporal database modeled by TTHR is the topic of this study. We examine the current issues and problems in temporal database and propose data retrieval optimization technique for temporal database. Conclusion: We proposed a data retrieval optimization technique for querying temporal database; this technique applies for the temporal database applications that are modeled by TTHR.

  • 1,368 Views
  • 1,561 Downloads
  • 1 Citations

Download

Keywords

  • Relational Algebra (RA)
  • Tuple Timestamp Historical Relation (TTHR)
  • Temporal Relational Algebra (TRA)
  • Temporal Normal Form (TNF)