Formal semantics for time in databases
ACM Transactions on Database Systems (TODS)
Extending the database relational model to capture more meaning
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
Laser optical disk: the coming revolution in on-line storage
Communications of the ACM
Implementation of a structured English query language
Communications of the ACM
A relational model of data for large shared data banks
Communications of the ACM
Data Models
The temporal query language TQuel
PODS '84 Proceedings of the 3rd ACM SIGACT-SIGMOD symposium on Principles of database systems
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
MECHANIZATION OF TEMPORAL KNOWLEDGE
MECHANIZATION OF TEMPORAL KNOWLEDGE
The time relational model
A logical framework for the temporal semantics and natural-language querying of historical databases
A logical framework for the temporal semantics and natural-language querying of historical databases
Preserving the time dimension in information systems (database, graphics)
Preserving the time dimension in information systems (database, graphics)
Assessing the temporal differentiation of attributes as an implementation strategy for a temporally oriented relational dbms (historical differentiation, database)
The role of time in information processing: a survey
ACM SIGMOD Record
The temporal query language TQuel
ACM Transactions on Database Systems (TODS)
Log files: an extended file service exploiting write-once storage
SOSP '87 Proceedings of the eleventh ACM Symposium on Operating systems principles
ACM Computing Surveys (CSUR)
SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
Evaluation of relational algebras incorporating the time dimension in databases
ACM Computing Surveys (CSUR)
Realizing a temporal complex-object data model
SIGMOD '92 Proceedings of the 1992 ACM SIGMOD international conference on Management of data
Automatic deduction of temporal information
ACM Transactions on Database Systems (TODS)
On completeness of historical relational query languages
ACM Transactions on Database Systems (TODS)
Temporal databases: model design and commercialization prospects
ACM SIGMIS Database
Experimenting with temporal relational databases
CIKM '95 Proceedings of the fourth international conference on Information and knowledge management
Supporting valid-time indeterminacy
ACM Transactions on Database Systems (TODS)
Handling infinite temporal data
PODS '90 Proceedings of the ninth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
ACM Transactions on Database Systems (TODS)
STCSP – structured temporal constraint satisfaction problems
Annals of Mathematics and Artificial Intelligence
Temporal Interpolation of Spatially Dynamic Object
Geoinformatica
Extensions to SQL for Historical Databases
IEEE Transactions on Knowledge and Data Engineering
Queries on Change in an Extended Relational Model
IEEE Transactions on Knowledge and Data Engineering
Spatial SQL: A Query and Presentation Language
IEEE Transactions on Knowledge and Data Engineering
DBMS Support for Nonmetric Measurement Systems
IEEE Transactions on Knowledge and Data Engineering
Temporal and Real-Time Databases: A Survey
IEEE Transactions on Knowledge and Data Engineering
Temporal Relational Data Model
IEEE Transactions on Knowledge and Data Engineering
SQL Extension for Interval Data
IEEE Transactions on Knowledge and Data Engineering
Efficient Indexing Methods for Temporal Relations
IEEE Transactions on Knowledge and Data Engineering
Aggregates in the Temporal Query Language TQuel
IEEE Transactions on Knowledge and Data Engineering
A Temporal Relational Algebra as Basis for Temporal Relational Completeness
VLDB '90 Proceedings of the 16th International Conference on Very Large Data Bases
Support for Temporal Data by Complex Objects
VLDB '90 Proceedings of the 16th International Conference on Very Large Data Bases
A Temporal Knowledge Representation Model OSAM*/T and Its Query Language OQL/T
VLDB '91 Proceedings of the 17th International Conference on Very Large Data Bases
Coalescing in Temporal Databases
VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
TOOA: A Temporal Object-Oriented Algebra
ECOOP '93 Proceedings of the 7th European Conference on Object-Oriented Programming
Proceedings of the 14th International conference on Industrial and engineering applications of artificial intelligence and expert systems: engineering of intelligent systems
Living with Database Conflicts: A Temporal Branching Technique
Distributed and Parallel Databases
GTL: a graphical language for temporal data
SSDBM'1994 Proceedings of the 7th international conference on Scientific and Statistical Database Management
Temporal summary table management and graphic interface
SSDBM'1990 Proceedings of the 5th international conference on Statistical and Scientific Database Management
A framework for query optimization in temporal databases
SSDBM'1990 Proceedings of the 5th international conference on Statistical and Scientific Database Management
The representation of a temporal data model in the relational environment
SSDBM'1988 Proceedings of the 4th international conference on Statistical and Scientific Database Management
Handling time in query languages
SSDBM'1988 Proceedings of the 4th international conference on Statistical and Scientific Database Management
SQL extension for spatio-temporal data
The VLDB Journal — The International Journal on Very Large Data Bases
Joins on interval data type columns in relational databases
Journal of Computing Sciences in Colleges
TempR-PDM: a conceptual temporal relational model for managing patient data
AIKED'10 Proceedings of the 9th WSEAS international conference on Artificial intelligence, knowledge engineering and data bases
TempoXML: Nested bitemporal relationship modeling and conversion tool for fuzzy XML
Information Sciences: an International Journal
Advances in fuzzy temporal relational databases: a review
WSEAS Transactions on Information Science and Applications
ADBIS'97 Proceedings of the First East-European conference on Advances in Databases and Information systems
Time-based operators for relational algebra query languages
Computer Languages
Hi-index | 0.00 |
The research into time and data models has so far focused on the identification of extensions to the classical relational model that would provide it with “adequate” semantic capacity to deal with time. The temporally oriented data model (TODM) presented in this paper is a result of a different approach, namely, it directly operationalizes the pervasive three-dimensional metaphor for time. One of the main results is thus the development of the notion of the data cube: a three-dimensional and inherently temporal data construct where time, objects, and attributes are the primary dimensions of stored data. TODM's cube adds historical depth to the tabular notions of data and provides a framework for storing and retrieving data within their temporal context. The basic operations in the model allow the formation of new cubic views from existing ones, or viewing data as one moves up and down in time within cubes.This paper introduces TODM, a consistent set of temporally oriented data constructs, operations, and constraints, and then presents TOSQL, a corresponding end-user's SQL-like query syntax. The model is a restricted but consistent superset of the relational model, and the query syntax incorporates temporal notions in a manner that likewise avoids penalizing users who are interested solely in the current view of data (rather than in a temporal perspective). The naturalness of the spatial reference to time and the added semantic capacity of TODM come with a price—the definitions of the cubic constructs and basic operations are relatively cumbersome. As rudimentary as it is, TODM nonetheless provides a comprehensive basis for formulating an external data model for a temporally oriented database.