A temporally oriented data model
ACM Transactions on Database Systems (TODS)
Computer
Adding time dimension to relational model and extending relational algebra
Information Systems
A homogeneous relational model and query languages for temporal databases
ACM Transactions on Database Systems (TODS)
A generalized model for a relational temporal database
SIGMOD '88 Proceedings of the 1988 ACM SIGMOD international conference on Management of data
Extending relational algebra to manipulate temporal data
Information Systems
Fundamentals of database systems
Fundamentals of database systems
A temporal relational model and a query language
Information Sciences: an International Journal
An introduction to database systems: vol. 1 (5th ed.)
An introduction to database systems: vol. 1 (5th ed.)
Temporal databases status and research directions
ACM SIGMOD Record - Directions for future database research & development
Understanding the new SQL: a complete guide
Understanding the new SQL: a complete guide
Modelling and managing time in database systems
The Computer Journal - Special issue on models and architectures
On an algebra for historical relational databases: two views
SIGMOD '85 Proceedings of the 1985 ACM SIGMOD international conference on Management of data
Formal semantics for time in databases
ACM Transactions on Database Systems (TODS)
The entity-relationship model—toward a unified view of data
ACM Transactions on Database Systems (TODS) - Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MA
A relational model of data for large shared data banks
Communications of the ACM
Database Management
Extensions to SQL for Historical Databases
IEEE Transactions on Knowledge and Data Engineering
A Temporal Model and Query Language for ER Databases
Proceedings of the Sixth International Conference on Data Engineering
TERM: An Approach to Include Time Dimension in the Entity-Relationship Model
ER '81 Proceedings of the Second International Conference on the Entity-Relationship Approach to Information Modeling and Analysis
The time relational model
Temporal Entity-Relationship Models-A Survey
IEEE Transactions on Knowledge and Data Engineering
On the Ontological Expressiveness of Temporal Extensions to the Entity-Relationship Model
ER '99 Proceedings of the Workshops on Evolution and Change in Data Management, Reverse Engineering in Information Systems, and the World Wide Web and Conceptual Modeling
CASE Tool Support for Temporal Database Design
ER '01 Proceedings of the 20th International Conference on Conceptual Modeling: Conceptual Modeling
The formal semantics of the timeER model
APCCM '06 Proceedings of the 3rd Asia-Pacific conference on Conceptual modelling - Volume 53
REERM: reenhancing the entity-relationship model
Data & Knowledge Engineering - Special issue: ER 2004
TimeERplus: a temporal EER model supporting schema changes
BNCOD'05 Proceedings of the 22nd British National conference on Databases: enterprise, Skills and Innovation
| Hi-index | 0.00 |
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.