TUPLE-BASED WINDOW EXPERIMENT 2

Tuple-based Window Experiment 2

Input: 

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

Query:

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

Coral8: 

Query in Coral8 is as follows:

INSERT INTO R2
SELECT sum(Val)
FROM InStream
KEEP EVERY 3 ROWS;

Result of the query in Coral8 is as follows:

Coral8 = {(10),(30),(60),(40),(90),(150),(240), ...}

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

Oracle CEP:

Query in Oracle CEP is as follows:

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

Result of the query in Oracle CEP is as follows:

Oracle CEP = {(60),(150),(240),...}

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

StreamBase: 

Query in StreamBase is as follows:

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