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.

Nashwan Alromema and Fahad Alotaibi, “A 1NF Data Model for Representing Time-Varying Data in Relational Framework” International Journal of Advanced Computer Science and Applications(IJACSA), 9(2), 2018. http://dx.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},
doi = {10.14569/IJACSA.2018.090225},
url = {http://dx.doi.org/10.14569/IJACSA.2018.090225},
year = {2018},
publisher = {The Science and Information Organization},
volume = {9},
number = {2},
author = {Nashwan Alromema and Fahad Alotaibi}
}