A snapshot differential refresh algorithm
SIGMOD '86 Proceedings of the 1986 ACM SIGMOD international conference on Management of data
SIGMOD '86 Proceedings of the 1986 ACM SIGMOD international conference on Management of data
Computer
The temporal query language TQuel
ACM Transactions on Database Systems (TODS)
Logical modeling of temporal data
SIGMOD '87 Proceedings of the 1987 ACM SIGMOD international conference on Management of data
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
Access methods for multiversion data
SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
A temporal relational model and a query language
Information Sciences: an International Journal
Information Sciences: an International Journal
An introduction to database systems: vol. 1 (5th ed.)
An introduction to database systems: vol. 1 (5th ed.)
Event-join optimization in temporal relational databases
VLDB '89 Proceedings of the 15th international conference on Very large data bases
A framework for vacuuming temporal databases
A framework for vacuuming temporal databases
The time index—an access structure for temporal data
Proceedings of the sixteenth international conference on Very large databases
Federated database systems for managing distributed, heterogeneous, and autonomous databases
ACM Computing Surveys (CSUR) - Special issue on heterogeneous databases
Heterogeneous distributed database systems for production use
ACM Computing Surveys (CSUR) - Special issue on heterogeneous databases
Interoperability of multiple autonomous databases
ACM Computing Surveys (CSUR) - Special issue on heterogeneous databases
The performance of a multiversion access method
SIGMOD '90 Proceedings of the 1990 ACM SIGMOD international conference on Management of data
Segment indexes: dynamic indexing techniques for multi-dimensional interval data
SIGMOD '91 Proceedings of the 1991 ACM SIGMOD international conference on Management of data
Scheduling real-time transactions: a performance evaluation
ACM Transactions on Database Systems (TODS)
Timestamp semantics and representation
Information Systems
A temporal data model based on accounting principles
A temporal data model based on accounting principles
Selectivity estimation of temporal data manipulations
Information Sciences: an International Journal
Distributed and Parallel Databases - Special issue: Research topics in distributed and parallel databases
SIGMOD '85 Proceedings of the 1985 ACM SIGMOD international conference on Management of data
Database description with SDM: a semantic database model
ACM Transactions on Database Systems (TODS)
Time concept in generalized data bases: TIGRE project
ACM '85 Proceedings of the 1985 ACM annual conference on The range of computing : mid-80's perspective: mid-80's perspective
Database abstractions: aggregation and generalization
ACM Transactions on Database Systems (TODS)
Maintaining knowledge about temporal intervals
Communications of the ACM
A relational model of data for large shared data banks
Communications of the ACM
Using differential techniques to efficiently support transaction time
The VLDB Journal — The International Journal on Very Large Data Bases
The Implementation of POSTGRES
IEEE Transactions on Knowledge and Data Engineering
Extensions to SQL for Historical Databases
IEEE Transactions on Knowledge and Data Engineering
Incremental Implementation Model for Relational Databases with Transaction Time
IEEE Transactions on Knowledge and Data Engineering
Queries on Change in an Extended Relational Model
IEEE Transactions on Knowledge and Data Engineering
Physical Organization of Temporal Data
Proceedings of the Third International Conference on Data Engineering
Indexing Techniques for Historical Databases
Proceedings of the Fifth International Conference on Data Engineering
Efficient Implementation Techniques For the Time Index
Proceedings of the Seventh International Conference on Data Engineering
Proceedings of the Eighth International Conference on Data Engineering
Historical Multi-Media Databases
VLDB '86 Proceedings of the 12th International Conference on Very Large Data Bases
VLDB '86 Proceedings of the 12th International Conference on Very Large Data Bases
The Design of the POSTGRES Storage System
VLDB '87 Proceedings of the 13th International Conference on Very Large Data Bases
The Representation of a Temporal Data Model in the Relational Environment
Proceedings of the 4th International Working Conference SSDBM on Statistical and Scientific Database Management
A Framework for Query Optimization in Temporal Databases
Proceedings of the 5th International Conference SSDBM on Statistical and Scientific Database Management
Query Processing for Temporal Databases
Proceedings of the Sixth International Conference on Data Engineering
The POSTGRES Papers
The time relational model
On the semantics of “now” in databases
ACM Transactions on Database Systems (TODS)
Spatio-temporal database support for legacy applications
SAC '98 Proceedings of the 1998 ACM symposium on Applied Computing
Temporal and Real-Time Databases: A Survey
IEEE Transactions on Knowledge and Data Engineering
Aggregates in the Temporal Query Language TQuel
IEEE Transactions on Knowledge and Data Engineering
Data Models with Multiple Temporal Dimensions: Completing the Picture
CAiSE '01 Proceedings of the 13th International Conference on Advanced Information Systems Engineering
Specification and Implementation of Temporal Databases in a Bitemporal Event Calculus
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
Indexing of now-relative spatio-bitemporal data
The VLDB Journal — The International Journal on Very Large Data Bases
Modification semantics in now-relative databases
Information Systems
Forensic analysis of database tampering
Proceedings of the 2006 ACM SIGMOD international conference on Management of data
Weaving temporal and reliability aspects into a schema tapestry
Data & Knowledge Engineering
The t4sql temporal query language
Proceedings of the sixteenth ACM conference on Conference on information and knowledge management
Forensic analysis of database tampering
ACM Transactions on Database Systems (TODS)
Schema-mediated exchange of temporal XML data
ER'06 Proceedings of the 25th international conference on Conceptual Modeling
Extending temporal query languages to handle imprecise time intervals
Computer Languages
| Hi-index | 0.00 |
A standard relation has two dimensions: attributes and tuples. A temporal relation contains two additional orthogonal time dimensions: valid time records when facts are true in the modeled reality, and transaction time records when facts are stored in the temporal relation. Although there are no restrictions between the valid time and transaction time associated with each fact, in many practical applications the valid and transaction times exhibit restricted interrelationships that define several types of specialized temporal relations. This paper examines areas where different specialized temporal relations are present. In application systems with multiple, interconnected temporal relations, multiple time dimensions may be associated with facts as they flow from one temporal relation to another. The paper investigates several aspects of the resulting generalized temporal relations, including the ability to query a predecessor relation from a successor relation. The presented framework for generalization and specialization allows one to precisely characterize and compare temporal relations and the application systems in which they are embedded. The framework's comprehensiveness and its use in understanding temporal relations are demonstrated by placing previously proposed temporal data models within the framework. The practical relevance of the defined specializations and generalizations is illustrated by sample realistic applications in which they occur. The additional semantics of specialized relations are especially useful for improving the performance of query processing.