On the semantics of “now” in databases
- 1 June 1997
- journal article
- Published by Association for Computing Machinery (ACM) in ACM Transactions on Database Systems
- Vol. 22 (2) , 171-214
- https://doi.org/10.1145/249978.249980
Abstract
Although “ now ” is expressed in SQL and CURRENT_TIMESTAMP within queries, this value cannot be stored in the database. How ever, this notion of an ever-increasing current-time value has been reflected in some temporal data models by inclusion of database-resident variables, such as “ now ” “ until-changed, ” “**,” “@,” and “-”. Time variables are very desirable, but their used also leads to a new type of database, consisting of tuples with variables, termed a variable database.Keywords
This publication has 26 references indexed in Scilit:
- Semantics of time-varying informationInformation Systems, 1996
- Unifying temporal data models via a conceptual modelInformation Systems, 1994
- On completeness of historical relational query languagesACM Transactions on Database Systems, 1994
- Timestamp semantics and representationInformation Systems, 1993
- Schema evolution in database systemsACM SIGMOD Record, 1992
- A temporal relational model and a query languageInformation Sciences, 1989
- Extending relational algebra to manipulate temporal dataInformation Systems, 1988
- A homogeneous relational model and query languages for temporal databasesACM Transactions on Database Systems, 1988
- The temporal query language TQuelACM Transactions on Database Systems, 1987
- Formal semantics for time in databasesACM Transactions on Database Systems, 1983