Dynamic functional dependencies and database aging
Journal of the ACM (JACM)
Temporal FDs on complex objects
ACM Transactions on Database Systems (TODS)
Data Models with Multiple Temporal Dimensions: Completing the Picture
CAiSE '01 Proceedings of the 13th International Conference on Advanced Information Systems Engineering
Semantics of Time-Varying Attributes and their Use for Temporal Database Design
OOER '95 Proceedings of the 14th International Conference on Object-Oriented and Entity-Relationship Modelling
The time relational model
A Uniform Algebraic Characterization of Temporal Functional Dependencies
TIME '05 Proceedings of the 12th International Symposium on Temporal Representation and Reasoning
| Hi-index | 0.00 |
The theoretical interest and the practical relevance of a systematic treatment of multiple temporal dimensions is widely recognized in the database and information system communities. Nevertheless, most relational databases have no temporal support at all. A few of them provide a limited support, in terms of temporal data types and predicates, constructors, and functions for the management of time values (borrowed from the SQL standard). One (resp., two) temporal dimensions are supported by historical and transaction-time (resp., bitemporal) databases only. In this paper, we provide a relational encoding of a conceptual model featuring four temporal dimensions, namely, the classical valid and transaction times, plus the event and availability times. We focus our attention on the distinctive technical features of the proposed temporal extension of the relation model. In the last part of the paper, we briefly show how to implement it in a standard DBMS.