Period-Stamped Temporal Models
Interval-based temporal models
A period-stamped temporal model is a temporal data model for the management of data in which time has the form of a time period.
There are applications that require the recording and management not only of data but also of the time during which this data is valid (valid time). A typical example is the data maintained by pension and life insurance organizations in order to determine the benefits for which a person qualifies. Similarly, such organizations have to record their financial obligations at various times in the future.
There are also sensitive applications, in which it is important to record not only the data but also the time at which this data was either recorded in the database or deleted or updated (transaction time). This time is recorded automatically by the database management system (DBMS) and it cannot be modified by the user.
Finally, there are applications in which data, valid time, and...
- 1.Date CJ, Darwen H, Lorentzos NA. Time and relational theory, temporal databases in the relational model and SQL. Morgan Kaufmann Publishers; 2013.Google Scholar
- 2.International Organization for Standardization (ISO). Database language SQL. Document ISO/IEC 9075:2011. 2011.Google Scholar
- 3.Jones S, Mason PS. Handling the time dimension in a database. In: Proceedings of the International Conference Data Bases; 1980. p. 65–83.Google Scholar
- 6.Lorentzos NA, Johnson RG. TRA a model for a temporal relational algebra. In: Rolland C, Bodart F, Leonard M, editors. Temporal aspects in information systems. North-Holland; 1988. p. 203–15.Google Scholar
- 8.Navathe SB, Ahmed R. TSQL: a language interface for history databases. In: Rolland C, Bodart F, Leonard M, editors. Temporal aspects in information systems. North-Holland; 1988. p. 109–22.Google Scholar
- 17.Tansel A, Clifford J, Gadia J, Segev A, Snodgrass R, editors. Temporal databases: theory, design and implementation. Benjamin/Cummings; 1993.Google Scholar