Perkembangan Model Data Temporal serta Implementasinya pada Database Management Systems


  • Supria Supria Bina Nusantara University



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


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.


Plum Analytics

Author Biography

Supria Supria, Bina Nusantara University

Computer Science Department, School of Computer Science


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.






Abstract 171  .
PDF downloaded 203  .