Converting Relational Database into Temporal Database

  • Authors

    • Yogiek Indra Kurniawan
    • Kusuma Ayu Laksitowening
    • Ade Romadhony
    • Muhammad Fachrie
    • Dimas Aryo Anggoro
    2019-01-24
    https://doi.org/10.14419/ijet.v8i1.1.24651
  • historical data, relational database, temporal database, time dimension.

  • 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.

     

     

  • References

    1. [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.

  • Downloads

  • How to Cite

    Indra Kurniawan, Y., Ayu Laksitowening, K., Romadhony, A., Fachrie, M., & Aryo Anggoro, D. (2019). Converting Relational Database into Temporal Database. International Journal of Engineering & Technology, 8(1.1), 143-148. https://doi.org/10.14419/ijet.v8i1.1.24651

    Received date: 2018-12-22

    Accepted date: 2018-12-22

    Published date: 2019-01-24