Facebook pixel tracking

The Science and Information (SAI) Organization publishes open-access peer-reviewed journals in computer science and artificial intelligence.

Contact Info
Email info@thesai.org
Website thesai.org
Follow Us
Contact Info
Email info@thesai.org
Follow Us
Research Article | Open Access |

A 1NF Data Model for Representing Time-Varying Data in Relational Framework

Author 1: Nashwan Alromema Author 2: Fahad Alotaibi
International Journal of Advanced Computer Science and Applications (IJACSA) · Vol. 9, No. 2 · Published 2018

DOI: https://doi.org/10.14569/IJACSA.2018.090225

Download PDF Cite Call for Papers

Abstract

Attaching Date and Time to varying data plays a definite role in representing a dynamic domain and resources on the database systems. The conventional database stores current data and can only represent the knowledge in static sense, whereas Time-varying database represents the knowledge in dynamic sense. This paper focuses on incorporating interval-based timestamping in First Normal Form (1NF) data model. 1NF approach has been chosen for the easily implementation in relational framework as well as to provide the temporal data representation with the modeling and querying power of relational data model. Simulation results revealed that the proposed approach substantially improved the performance of temporal data representation in terms of required memory storage and queries processing time.

Keywords

Time-oriented data model time-varying data valid-time data transaction time data bitemporal data data model N1NF 1NF

How to Cite this Article

Alromema, N., & Alotaibi, F. (2018). A 1NF Data Model for Representing Time-Varying Data in Relational Framework. International Journal of Advanced Computer Science and Applications, 9(2). https://doi.org/10.14569/IJACSA.2018.090225

Alromema, Nashwan, and Fahad Alotaibi. "A 1NF Data Model for Representing Time-Varying Data in Relational Framework." International Journal of Advanced Computer Science and Applications, vol. 9, no. 2, 2018, https://doi.org/10.14569/IJACSA.2018.090225.

@article{Alromema2018,
  title     = {A 1NF Data Model for Representing Time-Varying Data in Relational Framework},
  journal   = {International Journal of Advanced Computer Science and Applications},
  volume    = {9},
  number    = {2},
  year      = {2018},
  publisher = {The Science and Information Organization},
  author    = {Nashwan Alromema and Fahad Alotaibi},
  doi       = {10.14569/IJACSA.2018.090225},
  url       = {https://doi.org/10.14569/IJACSA.2018.090225}
}

Open Access — licensed under a Creative Commons Attribution 4.0 International License. Unrestricted use, distribution, and reproduction in any medium, even commercially, as long as the original work is properly cited.

Back to Issue
IJACSA Journal Cover

IJACSA