对持续数据库的查询结果,随着时间的推移仍然有效(扩展版)
Query Results over Ongoing Databases that Remain Valid as Time Passes By (Extended Version)
摘要:
持续时间点现在用于声明一个元组从开始点开始是有效的。对于数据库系统,持续时间点具有深远的影响,因为它们随着时间的推移而不断变化。最先进的方法通过将正在进行的时间点实例化到参考时间来处理它们。实例化产生的查询结果仅在所选时间有效,并随着时间的推移而失效。我们提出了一个解决方案,保持正在进行的时间点在查询处理过程中未实例化。我们通过在所有可能的引用时间评估谓词和函数来做到这一点。这使得查询结果独立于特定的引用时间,并产生随着时间的推移仍然有效的结果。作为查询结果,我们提出了正在进行的关系,包括一个参考时间属性。reference time属性的值受到正在进行的属性上的谓词和函数的限制。我们描述和评估一个有效的实现正在进行的数据类型和操作在PostgreSQL。
英文摘要:
Ongoing time point now is used to state that a tuple is valid from the start point onward. For database systems ongoing time points have far-reaching implications since they change continuously as time passes by. State-of-the-art approaches deal with ongoing time points by instantiating them to the reference time. The instantiation yields query results that are only valid at the chosen time and get invalidated as time passes by. We propose a solution that keeps ongoing time points uninstantiated during query processing. We do so by evaluating predicates and functions at all possible reference times. This renders query results independent of a specific reference time and yields results that remain valid as time passes by. As query results, we propose ongoing relations that include a reference time attribute. The value of the reference time attribute is restricted by predicates and functions on ongoing attributes. We describe and evaluate an efficient implementation of ongoing data types and operations in PostgreSQL.
机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。