Converting Relational Database into Temporal Database

  • Abstract
  • Keywords
  • References
  • PDF
  • Abstract

    In this paper, perform the implementation of temporal database which take into account the historical aspects of data and how to convert relational database into temporal database. After performing the implementation, an analysis of queries is done in accessing each data that takes into account the historical aspects of data, for Data Definition Language (DDL), Data Manipulation Language (DML) and queries for retrieve data. After the analysis, it is concluded that the use of queries for temporal database can be done on the relational database with some adjustments. In addition, temporal databases have advantages in terms of storage usage and response time for DDL and DML queries, but for response time in query retrieve data takes longer than relational database.



  • Keywords

    historical data; relational database; temporal database; time dimension.

  • References

      [1] Andreas, B., Dieter, G., Sahar, V., & Hua, L. Z. (2018, January). Reasoning Under Situation Awareness in a Temporal Database. In 2018 Second IEEE International Conference on Robotic Computing (IRC) (pp. 387-391). IEEE.

      [2] Böhlen, M. H., Dignös, A., Gamper, J., & Jensen, C. S. (2017, July). Temporal Data Management–An Overview. In Europe-an Business Intelligence and Big Data Summer School (pp. 51-83). Springer, Cham.

      [3] Bowman, J. S., Emerson, S. L., & Darnovsky, M. (1996). The practical SQL handbook: using structured query language. Addison-Wesley Longman Publishing Co., Inc..

      [4] Kurniawan, Y. I., Soviana, E., & Yuliana, I. (2018, June). Merging Pearson Correlation and TAN-ELR algorithm in rec-ommender system. In AIP Conference Proceedings (Vol. 1977, No. 1, p. 040028). AIP Publishing.

      [5] Kvet, M., & Kvet, M. (2017, July). Temporal database management: Temporal registration. In Information and Digital Technologies (IDT), 2017 International Conference on (pp. 227-233). IEEE.

      [6] Orru, M., Paolillo, R., Detti, A., Rossi, G., & Melazzi, N. B. (2017, June). Demonstration of OpenGeoBase: the ICN NoSQL spatio-temporal database. In Local and Metropolitan Area Networks (LANMAN), 2017 IEEE International Symposium on (pp. 1-2). IEEE.

      [7] Pant, N., Fouladgar, M., Elmasri, R., & Jitkajornwanich, K. (2018, March). A Survey of Spatio-Temporal Database Re-search. In Asian Conference on Intelligent Information and Database Systems (pp. 115-126). Springer, Cham.

      [8] Poscic, P., Babic, I., & Jaksic, D. (2018, May). Temporal functionalities in modern database management systems and data warehouses. In 2018 41st International Convention on Information and Communication Technology, Electronics and Microelectronics (MIPRO). IEEE.

      [9] Snodgrass, R. T. (Ed.). (2012). The TSQL2 temporal query language (Vol. 330). Springer Science & Business Media.




Article ID: 24651
DOI: 10.14419/ijet.v8i1.1.24651

Copyright © 2012-2015 Science Publishing Corporation Inc. All rights reserved.