Retrieval Optimization Technique for Tuple Timestamp Historical Relation Temporal Data Model
- 1 ,
- 2 , Afganistan
Copyright: © 2020 Sami M. Halawani, Ibrahim AlBidewi, Ab Rahman Ahmad and Nashwan A. Al-Romema. This is an open access article distributed under the terms of the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are credited.
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
- Relational Algebra (RA)
- Tuple Timestamp Historical Relation (TTHR)
- Temporal Relational Algebra (TRA)
- Temporal Normal Form (TNF)