.png){kind=icon}
返回
Modification semantics in now-relative databases
.png){kind=icon}
PRE
AI
DOI：10.1016/S0306-4379(03)00047-4.png)
.png){kind=icon}
原文求助.png){kind=icon}
分享.png){kind=icon}
收藏
摘要
En 中文
Most real-world databases record time-varying information. In such databases, the notion of the current time, or NOW, occurs naturally and prominently. For example, when capturing the past states of a relation using begin and end time columns, tuples that are part of the current state have some past time as their begin time and NOW as their end time. While the semantics of such variable databases has been described in detail and is well understood, the modification of variable databases remains unexplored. This paper defines the semantics of modifications involving the variable NOW. More specifically, the problems with modifications in the presence of NOW are explored, illustrating that the main problems are with modifications of tuples that reach into the future. The paper defines the semantics of modifications-including insertions, deletions, and updates-of databases without NOW, with NOW, and with values of the type NOW + Delta, where Delta is a non-variable time duration. To accommodate these semantics, three new time-stamp values are introduced. Finally, implementation is explored. We show how to represent the variable NOW with columns of standard SQL data types and give a mapping from SQL on NOW-relative data to standard SQL on these columns. The paper thereby completes the semantics, the querying, and the modification of now-relative databases. (C) 2003 Elsevier Ltd. All rights reserved.
Keyword:
temporal data
temporal query language
SQL
now
now-relative information
updates
AI总结
对已上传原文的论文进行重点信息的提取，主要内容包括：简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。
期刊
IF:
3.9
论文数:
2.8K
被引数:
1.8K
机构
暂无机构信息
引用论文
分享收藏分享收藏
分享收藏High-Mg carbonatitic microinclusions in some Yakutian diamonds—a new type of diamond-forming fluid.png)
Lithos
LithosIF0
PREAI
分享收藏
分享收藏
查看更多内容