Modern data-intensive applications have to manage huge quantities of streaming/relational data and need advanced query capabilities involving combinations of continuous queries (CQs) and one-time queries (OTQs) also requiring the verification of complex temporal conditions.

In this paper, we go beyond the disjointed panorama of current approaches and adopt a new holistic approach to the integration of stream processing capabilities into the temporal database world based on the streaming table concept. To this end, we propose a full-fledged query interface composed of a TSQL2-like query language with an underlying algebraic framework. The algebraic framework, which is aimed at implementing the query interface on top of a working DBMS, is made up of: (a) the extended temporal algebra ${\mathcal{TA}}^{\star }$ supporting OTQs with an hybrid temporal semantics (sequenced and non-sequenced); (b) the continuous temporal algebra $\mathcal{CTA}$ that extends ${\mathcal{TA}}^{\star }$ with window expressions for CQ specification; (c) the translation of $\mathcal{CTA}$ expressions into ${\mathcal{TA}}^{\star }$ ones that can be executed by a traditional DBMS with an extended kernel.

现代数据密集型应用程序必须管理大量流/关系数据，并且需要高级查询功能，包括连续查询 (CQ) 和一次性查询 (OTQ) 的组合，还需要验证复杂的时间条件。

在本文中，我们超越了当前方法的脱节全景，采用新的整体方法将流处理能力集成到基于流表概念的时态数据库世界中。为此，我们提出了一个成熟的查询接口，由具有底层代数框架的类似 TSQL2 的查询语言组成。代数框架旨在在工作 DBMS 之上实现查询接口，由以下部分组成：(a) 扩展时间代数${\mathcal{助教}}^{\star }$支持具有混合时间语义（顺序和非顺序）的 OTQ；(b) 连续时间代数$\mathcal{CTA}$ 延伸 ${\mathcal{助教}}^{\star }$带有用于 CQ 规范的窗口表达式；(c) 翻译$\mathcal{CTA}$ 表达成 ${\mathcal{助教}}^{\star }$ 可以由具有扩展内核的传统 DBMS 执行的那些。