On the semantics of “now” in databases-Reference-Cited by-同舟云学术

On the semantics of “now” in databases

Published:1997-06 Issue:2 Volume:22 Page:171-214
ISSN:0362-5915
Container-title:ACM Transactions on Database Systems
language:en
Short-container-title:ACM Trans. Database Syst.

Author:

Clifford James¹,Dyreson Curtis²,Isakowitz Tomás¹,Jensen Christian S.³,Snodgrass Richard Thomas⁴

Affiliation:

1. New York Univ., New York, NY

2. James Cook Univ., Townsville, Australia

3. Aalborg Univ., Aalborg, Denmark

4. Univ. of Arizona, Tucson

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.

Publisher

Association for Computing Machinery (ACM)

Subject

Information Systems

Link

https://dl.acm.org/doi/pdf/10.1145/249978.249980

Reference48 articles.

1. Bibliography on spatiotemporal databases;AL-TAHA K. K.;Int. J. Geograph. Inf. Syst.,1994

2. A relational-calculus query language for historical databases

3. Workshops in Computing Series;BRUSONI V.

4. Lecture Notes in Computer Science 759;CLIFFORD J.

Cited by 93 articles. 订阅此论文施引文献订阅此论文施引文献，注册后可以免费订阅5篇论文的施引文献，订阅后可以查看论文全部施引文献

1. Temporal JSON Keyword Search;Proceedings of the ACM on Management of Data;2024-05-29

2. Multi-Source Data Repairing: A Comprehensive Survey;Mathematics;2023-05-16

3. 60 Years of Databases (part two);PROBLEMS IN PROGRAMMING;2021-12

4. A model and query language for temporal graph databases;The VLDB Journal;2021-05-12

5. XML data manipulation in conventional and temporal XML databases: A survey;Computer Science Review;2020-05