Database system concepts
Dynamic functional dependencies and database aging
Journal of the ACM (JACM)
A new normal form for nested relations
ACM Transactions on Database Systems (TODS)
Computer
The temporal query language TQuel
ACM Transactions on Database Systems (TODS)
Adding time dimension to relational model and extending relational algebra
Information Systems
Logical modeling of temporal data
SIGMOD '87 Proceedings of the 1987 ACM SIGMOD international conference on Management of data
Principles of database and knowledge-base systems, Vol. I
Principles of database and knowledge-base systems, Vol. I
A homogeneous relational model and query languages for temporal databases
ACM Transactions on Database Systems (TODS)
Extending relational algebra to manipulate temporal data
Information Systems
SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
The handling of depth and time intervals in soil-information systems
Computers & Geosciences
A temporal relational model and a query language
Information Sciences: an International Journal
Algebra and query language for a historical data model
The Computer Journal - Special issue on databases
Bibliography on spatiotemporal databases
ACM SIGMOD Record
A consensus glossary of temporal database concepts
ACM SIGMOD Record
Unifying temporal data models via a conceptual model
Information Systems
Logical design for temporal databases with multiple granularities
ACM Transactions on Database Systems (TODS)
A normal form for relational databases that is based on domains and keys
ACM Transactions on Database Systems (TODS)
Formal semantics for time in databases
ACM Transactions on Database Systems (TODS)
Multivalued dependencies and a new normal form for relational databases
ACM Transactions on Database Systems (TODS)
Independent components of relations
ACM Transactions on Database Systems (TODS)
The TSQL2 Temporal Query Language
The TSQL2 Temporal Query Language
Normal forms and relational database operators
SIGMOD '79 Proceedings of the 1979 ACM SIGMOD international conference on Management of data
Using differential techniques to efficiently support transaction time
The VLDB Journal — The International Journal on Very Large Data Bases
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
The Historical Relational Data Model (HRDM) and Algebra Based on Lifespans
Proceedings of the Third International Conference on Data Engineering
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
Design of Temporal Relational Databases Based on Dynamic and Temporal Functional Dependencies
Proceedings of the International Workshop on Temporal Databases: Recent Advances in Temporal Databases
Functional Dependencies Generalized for Temporal Databases that Include Object-Identity
ER '93 Proceedings of the 12th International Conference on the Entity-Relationship Approach: Entity-Relationship Approach
Proceedings of the International Conference GIS - From Space to Territory: Theories and Methods of Spatio-Temporal Reasoning on Theories and Methods of Spatio-Temporal Reasoning in Geographic Space
Analysis and design of relational schemata for database systems.
Analysis and design of relational schemata for database systems.
Data dependencies in the relational model of databases: a generalization
Data dependencies in the relational model of databases: a generalization
The time relational model
A database query language for operations on historical data
A database query language for operations on historical data
An algebraic language for query and update of temporal databases
An algebraic language for query and update of temporal databases
Logical design for temporal databases with multiple granularities
ACM Transactions on Database Systems (TODS)
Temporal FDs on complex objects
ACM Transactions on Database Systems (TODS)
Trends in Databases: Reasoning and Mining
IEEE Transactions on Knowledge and Data Engineering
Temporal Dependencies Generalized for Spatial and Other Dimensions
STDBM '99 Proceedings of the International Workshop on Spatio-Temporal Database Management
Join operations in temporal databases
The VLDB Journal — The International Journal on Very Large Data Bases
Optimizing away joins on data streams
SSPS '08 Proceedings of the 2nd international workshop on Scalable stream processing system
Efficient reasoning about a robust XML key fragment
ACM Transactions on Database Systems (TODS)
A uniform framework for temporal functional dependencies with multiple granularities
SSTD'11 Proceedings of the 12th international conference on Advances in spatial and temporal databases
Design by example for SQL table definitions with functional dependencies
The VLDB Journal — The International Journal on Very Large Data Bases
Characterisations of multivalued dependency implication over undetermined universes
Journal of Computer and System Sciences
ACM Transactions on Database Systems (TODS)
Reasoning about functional and full hierarchical dependencies over partial relations
Information Sciences: an International Journal
Hi-index | 0.00 |
Normal forms play a central role in the design of relational databases. Several normal forms for temporal relational databases have been proposed. These definitions are particular to specific temporal data models, which are numerous and incompatible. This paper attempts to rectify this situation. We define a consistent framework of temporal equivalents of the important conventional database design concepts: functional dependencies, primary keys, and third and Boyce-Codd normal forms. This framework is enabled by making a clear distinction between the logical concept of a temporal relation and its physical representation. As a result, the role played by temporal normal forms during temporal database design closely parallels that of normal forms during conventional database design. These new normal forms apply equally well to all temporal data models that have timeslice operators, including those employing tuple timestamping, backlogs, and attribute value timestamping. As a basis for our research, we conduct a thorough examination of existing proposals for temporal dependencies, keys, and normal forms. To demonstrate the generality of our approach, we outline how normal forms and dependency theory can also be applied to spatial and spatiotemporal databases.