A temporally oriented data model
ACM Transactions on Database Systems (TODS)
A guide to the SQL standard
Computer
The temporal query language TQuel
ACM Transactions on Database Systems (TODS)
Reasoning about change: time and causation from the standpoint of artificial intelligence
Reasoning about change: time and causation from the standpoint of artificial intelligence
Defining data types in a database language
ACM SIGMOD Record
Algebra and query language for a historical data model
The Computer Journal - Special issue on databases
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 determination of efficient record segmentations and blocking factors for shared data files
ACM Transactions on Database Systems (TODS)
Principles of Database Systems
Principles of Database Systems
The role of time in information processing: a survey
ACM SIGMOD Record
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
Temporal FDs on complex objects
ACM Transactions on Database Systems (TODS)
Querying ATSQL databases with temporal logic
ACM Transactions on Database Systems (TODS)
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
Temporal Specialization and Generalization
IEEE Transactions on Knowledge and Data Engineering
Temporal and Real-Time Databases: A Survey
IEEE Transactions on Knowledge and Data Engineering
Extending Existing Dependency Theory to Temporal Databases
IEEE Transactions on Knowledge and Data Engineering
The Expressive Power of Temporal Relational Query Languages
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
Relational Database Systems with Zero Information Loss
IEEE Transactions on Knowledge and Data Engineering
Aggregates in the Temporal Query Language TQuel
IEEE Transactions on Knowledge and Data Engineering
The VLDB Journal — The International Journal on Very Large Data Bases
A temporal paraconsistent relational algebra for incomplete and inconsistent information
ACM-SE 33 Proceedings of the 33rd annual on Southeast regional conference
Joins on interval data type columns in relational databases
Journal of Computing Sciences in Colleges
A Fuzzy Set-Based Approach to Temporal Databases
SUM '07 Proceedings of the 1st international conference on Scalable Uncertainty Management
Nested bitemporal relational algebra
ISCIS'06 Proceedings of the 21st international conference on Computer and Information Sciences
Bipolar fuzzy querying of temporal databases
FQAS'11 Proceedings of the 9th international conference on Flexible Query Answering Systems
Time-based operators for relational algebra query languages
Computer Languages
Auditing a database under retention policies
The VLDB Journal — The International Journal on Very Large Data Bases
Hi-index | 0.00 |
A historical management system (HDBMS) is described which uses an extended relational data model with state-oriented, instead of 'cubic', conceptualization. Two types of historical relations, called state and event relations, are provided for modeling real-world objects. The query language SQL has been extended for definition, retrieval, and update of historical relations. The extended SQL, called HSQL, is a superset of SQL. The author defines a few primitive algebra operations for historical relations, and uses them as a basis for extensions to SQL. In this way, HSQL retains the elegant structural and algebraic framework of SQL. HSQL contains a few new clauses, many operations and built-in functions on time domain, and facilities for retrospective updates and time-rollback.