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.
Highlights
Haraty and Bekaii, (2006)
Developing a technique that extends non-temporal data model to temporal data model on top of conventional DBMS that acts as stratum
A Tuple Timestamp Historical Relation (TTHR) is a temporal database model that is proposed by Halawani and Romema (2010), where the relation that needs to capture temporal time aspects decomposed in to two relations, one represents the current state relation and the other recodes the changes in all the time varying
Summary
Temporal database is defined as “a database which supports some aspect of time, not counting user-defined time” or the database system that stores time-varying data (Kostenko, 2007). Several terminologies can be used to define temporal database like time-varying, time-oriented and historical database systems. Traditional database systems are designed to store and process the state of the reality at a sigle point of time, whearas temporal database have the capability to record and process time-varying aspects of the real in past present and feature world Haraty and Bekaii, (2006). Build a complete TDBMS from scratch that provides a primitive data type and handles the different states/time instances of data being stored (integrated approach). Developing a technique that extends non-temporal data model to temporal data model on top of conventional DBMS that acts as stratum (stratum approach)
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Free) 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call
