Temporal databases: model design and commercialization prospects

This article presents a Temporal Enhanced Entity-Relationship (TEER) model, which shows how temporal information can be captured within a conceptual data model and extended to the relational data model. The time elements proposed for the TEER model include both transaction time and valid time. In or...

Full description

Saved in:
Bibliographic Details
Published in:ACM SIGMIS Database: the DATABASE for Advances in Information Systems 1994-08, Vol.25 (3), p.6-18
Main Authors: Lai, Vincent S., Kuilboer, Jean-Pierre, Guynes, Jan L.
Format: Article
Language:English
Citations: Items that this one cites
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:This article presents a Temporal Enhanced Entity-Relationship (TEER) model, which shows how temporal information can be captured within a conceptual data model and extended to the relational data model. The time elements proposed for the TEER model include both transaction time and valid time. In order to support time-related queries, the query language SQL has been extended for definition, retrieval, and control of historical relations. For the commercialization of temporal databases, several technical and non-technical issues need to be resolved. This article provides a discussion of these issues and evaluates its progress toward commercialization.
ISSN:0095-0033
1532-0936
DOI:10.1145/190675.190676