Perkembangan Model Data Temporal serta Implementasinya pada Database Management Systems

Authors

  • Supria Supria Bina Nusantara University

DOI:

https://doi.org/10.21512/emacsjournal.v5i1.9392

Keywords:

Relationship Data Model, Temporal Relationship Data Model, Historical Relationship Data Model, IBM DB2, Teradata

Abstract

This essay examines how temporal data models are created and how they are integrated into database management systems. The well-known Relational Data Model’s extension, the Temporal Relational Data Model, is discussed. The application of this temporal data model in database management systems is also researched. The Historical Relational Data Model adds timestamps to attributes, and the Temporal Relational Model adds timestamps to tuples. These two approaches make up the temporal data model. It has become apparent via the implementation of this temporal data model that not all temporal data ideas are applicable to database management systems. IBM DB2 has explicitly integrated the idea of time stamps, but not the idea of PERIOD data type. While Teradata has implemented the PERIOD data type, but has not yet implemented the concept of explicit timestamps.

Dimensions

Plum Analytics

Author Biography

Supria Supria, Bina Nusantara University

Computer Science Department, School of Computer Science

References

Navathe, S.B. & Ahmed, R. (1989). A Temporal Relation Model and A Query Language, Information Science, 49(2): 147-175.

Clifford, J. & Croker, A. (1987). The Historical Relational Data Model and Algebra Based on Lifespans in Proceedings of the Third International Conference on Data Engineering, 528-537.

Petkovic, D. (2016). Temporal Data in Relational Database Systems: A Comparison. World Conference on Information Systems and Technologies.

Downloads

Published

2023-01-31

Issue

Section

Articles
Abstract 171  .
PDF downloaded 203  .