Towards a Streaming SQL Standard

被引：49

作者：

Jain, Namit ^{[1
]}

Mishra, Shailendra ^{[1
]}

Srinivasan, Anand ^{[1
]}

Gehrke, Johannes ^{[2
]}

Widom, Jennifer ^{[3
]}

Balakrishnan, Hari ^{[4
]}

Cetintemel, Ugur ^{[4
]}

Cherniack, Mitch ^{[4
]}

Tibbetts, Richard ^{[4
]}

Zdonik, Stan ^{[4
]}

机构：

[1] Oracle Corp, Redwood Shores, CA 94065 USA

[2] Cornell Univ, Ithaca, NY 14853 USA

[3] Stanford Univ, Stanford, CA 94305 USA

[4] StreamBase Inc, Lexington, MA USA

来源：

PROCEEDINGS OF THE VLDB ENDOWMENT | 2008年 / 1卷 / 02期

关键词：

Computer architecture;

D O I：

10.14778/1454159.1454179

中图分类号：

TP [自动化技术、计算机技术];

学科分类号：

0812 ;

摘要：

This paper describes a unification of two different SQL extensions for streams and its associated semantics. We use the data models from Oracle and StreamBase as our examples. Oracle uses a time-based execution model while StreamBase uses a tuple-based execution model. Time-based execution provides a way to model simultaneity while tuple-based execution provides a way to react to primitive events as soon as they are seen by the system. The result is a new model that gives the user control over the granularity at which one can express simultaneity. Of course, it is possible to ignore simultaneity altogether. The proposed model captures ordering and simultaneity through partial orders on batches of tuples. The batching and the ordering are encapsulated in and can be modified by means of a powerful new operator that we call SPREAD. This paper describes the semantics of SPREAD and gives several examples of its use.

引用

页码：1379 / 1390

页数：12

共 23 条

[1] Aurora: a new model and architecture for data stream management [J].

Abadi, DJ ;

Carney, D ;

Cetintemel, U ;

Cherniack, M ;

Convey, C ;

Lee, S ;

Stonebraker, M ;

Tatbul, N ;

Zdonik, S .

VLDB JOURNAL, 2003, 12 (02) :120-139

[2] The CQL continuous query language: semantic foundations and query execution [J].

Arasu, A ;

Babu, S ;

Widom, J .

VLDB JOURNAL, 2006, 15 (02) :121-142

[3]

Arasu A., VLDB 2004, P480

[4]

Babcock B., SIGMOD 2003, P253

[5]

Bai Y., CIKM 2006

[6]

Barga R. S., 2007, CIDR 2007, P363

[7]

Carney D., VLDB 2003

[8]

Chandrasekaran Sirish, 2002, VLDB 2002

[9]

Cherniack M., 2003, TECHNICAL REPORT

[10]

Codehaus.org, 2007, ESP ONL DOC SET

← 1 2 3 →