Authors: Jan L. Guynes, Jean-Pierre Kuilboer, Vincent S . Lai
Tags: 1994, conceptual modeling
This article presents a Temporal Enhanced EntityRelationship (TEER) model, which shows how temporal information can be captured within a conceptual data model and extended to the relational dat a 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 thes e issues and evaluates its progress toward commercialization .Read the full paper here: https://dl.acm.org/doi/pdf/10.1145/190675.190676