A Mathematical Model for Comparing Memory Storage of Three Interval-Based Parametric Temporal Database Models
Journal Title: International Journal of Advanced Computer Science & Applications - Year 2017, Vol 8, Issue 7
Abstract
Interval-Based Parametric Temporal Database Model (IBPTDM) captures the historical changes of database object in single tuple. Such data model violates 1NF and it is difficult to be implemented on top of conventional Database Management Systems (DBMS). The reason behind that, IBPTDM cannot directly use relational storage structure or query evaluation technique that depends on atomic attribute values as well as it is unfixed attribute size. 1NF model with its features can be used to solve such challenge. Modeling time-varying data in 1NF model raise a question about memory storage efficiency and ease of use. A novel approach for representing temporal data in 1NF model and compare it with other main approaches in literature is the main goal of this research. To this end, a mathematical model for comparing a three different storage models is demonstrated to illustrate that the proposed model is more efficient than other approaches under certain conditions. The simulation results showed that the proposed model overcomes the needless redundancy of data, achieves saving in memory storage, and it is easy to be implemented in relational data model or to be adapted with a production systems that need to track temporal aspects of functioning database Systems.
Authors and Affiliations
Nashwan Alromema, Mohd Shafry Mohd Rahim, Ibrahim Albidewi
Keywords
Related Articles
- EP ID EP260350
- DOI 10.14569/IJACSA.2017.080741
- Views 120
- Downloads 0
A General Evaluation Framework for Text Based Conversational Agent
This paper details the development of a new evaluation framework for a text based Conversational Agent (CA). A CA is an intelligent system that handle spoken or/and text based conversations between machine and human. Gen...
Detection of Distributed Denial of Service Attacks Using Artificial Neural Networks
Distributed Denial of Services (DDoS) is a ruthless attack that targets a node or a medium with its false packets to decline the network performance and its resources. Neural networks is a powerful tool to defend a netwo...
A Defected Ground based Fractal Antenna for C and S Band Applications
In this paper, a modified ground based rectangular shaped fractal patch antenna will be presented. Since, the research community has witnessed a significant demand of both light weight and small sized micro-chip antenna...
A Review of Solutions for SDN-Exclusive Security Issues
Software Defined Networking is a paradigm still in its emergent stages in the realm of production-scale networks. Centralisation of network control introduces a new level of flexibility for network administrators and pro...
Applications of Data Envelopment Analysis in Development and Assessment of Sustainability Across Economic, Environmental and Social Dimensions
Recently, senior managers are paying much more attention to the environmental aspects of decision-making units. Technically, global economy is inextricably connected to the environment, as it is heavily dependent on extr...