TUPLE-BASED WINDOW EXPERIMENT 4

Tuple-based Window Experiment 4

 Input: 

InStream(Time, Val) = {(10,10),(10,20),(11,30),(12,40),(12,50),(12,60),
                       (12,70),(13,80),(14,90),(15,100), ...} 

Query:

Continuously compute the sum of the values over a tuple-based window of size 3, slide 2 tuples.

Oracle CEP:

Query in Oracle CEP is as follows:

ISTREAM(SELECT sum(Val) AS AggrValue
FROM InStream [ROWS 3 SLIDE 2])

Result of the query in Oracle CEP is as follows:

Oracle CEP = {(30),(150),(210), ...}

Project and input files of the experiment can be found here.

StreamBase: 

Query in StreamBase is as follows:

CREATE OUTPUT STREAM tupleR4 AS
SELECT sum(Val) AS SumVal
FROM InStream[SIZE 3 ADVANCE 2 TUPLES];
 
Result of the query in StreamBase is as follows:
 
StreamBase = {(60),(120),(180),(240), ...}
 
Project files of the experiment can be found here.
 
Explanation of the results given by the engines can be found in Section 6.3.4 of our journal paper.