Memory Storage Issues of Temporal Database Applications on Relational Database Management Systems

Abstract

<b>Problem statement:</b> Many existing database applications manage time-varying data. These database applications are referred to as temporal databases or time-oriented database applications that are considered as repositories of time-dependent data. Many proposals have been introduced for developing time-oriented database applications, some of which suggest building support for Temporal Database Management Systems (TDBMS) on top of existing non-temporal DBMSs, while others suggest modifying the models of exiting DBMSs or building TDBMS from scratch. <b>Approach:</b> This study addressed several issues concerning developing a technique that enables database designers to understand the way in which time-varying behavior can be modeled and mapped into tabular form. <b>Results:</b> Conventional DBMSs do not have the capability to record and process time-varying aspects of the real world. With growing sophistication of DBMS applications, the lack of temporal support in conventional DBMS raises serious problems when used to develop temporal database. The technique of understanding how to think about time and represent it in formal systems is the topic of this study. We examined how to implement time-varying application in the SQL structured query language by introducing temporal data concepts that need to be simulated in DBMSs which lack temporal supports. We proposed a temporal data model that combines the features of previous temporal models and that reduces the cost of memory storage. <b>Conclusion:</b> We proposed a technique for implementing temporal database on top of exiting non-temporal DBMS. This technique includes five main areas. These areas are temporal database conceptual design, temporal database logical design, integrity constraints preventions in temporal database, modifying and querying temporal database. We proposed a data model for the temporal database based on the data models which are discussed in literature

A Mathematical Model for Comparing Memory Storage of Three Interval-Based Parametric Temporal Database Models

“…To measure the storage costs, we have established a mathematical model (formulas) for the three approaches. The measurement of the performance is represented by the size of the whole stored temporal data as stated in [22], [29], [31]. It has been proved that TTHR has achieved significant saving in memory storage that ranges between 68%-81% over TTSR approach, and 10%-32% over TTMR.…”

“…It has been proved that TTHR has achieved significant saving in memory storage that ranges between 68%-81% over TTSR approach, and 10%-32% over TTMR. The memory storage save is based on the average change of the time varying attributes [29], [30], [31]. A validation and verification study of the correctness and the expressiveness of TTHR model has been depicted in [32].…”

Relational model of temporal data based on 6th normal form

“…The technique proposed by Halawani and AlRomema [10] suggests the implementation of a temporal database on top of an existing non-temporal database. Their data model is based on tuple time stamping with two relations: one relation is the current snapshot of data and the other is the auxiliary relation that holds the temporal aspects of the whole of the time-varying attributes.…”

“…Different approaches have been proposed [7], [10], [17], but guidance or exact definitions are unavailable, as there are too many unclear scenarios when trying such approach in design. This section describes considerations and propositions, presenting foundations for our model.…”

Robust Memory Management Using Real Time Concepts

“…The temporal data model should be designed in a way to reduce the cost of memory storage (Halawani and Al-Romema, 2010)". Anbumozhi and Manoharan (2014) proposed a method of fuzzy based image fusion in that the author highlighted the need for limited memory buffers with low computational complexity in order to reduce the hardware cost.…”