41. DBMS vs DSMS
DBMS DSMS
Query Ad Hoc Query Continuous Query
Target Stored Data Stream Data
App
? Web Application
? Batch Processing
? Operation & Maintenance
? Anomaly Event Detection
? Click Stream
? Sensor Data
Software
ISO SQL Lucene Esper S4
PL/SQL HiveQL Storm Oracle CQL
Impala Pig Spark StreamBase
42. Continuous Query
Ad Hoc Query
SELECT avg_age FROM user
WHERE SUBDATE(
NOW(), INTERVAL 5 MINUTE
) >= datetime
Continuous Query
SELECT avg_age
FROM user:time_batch(5 mins)
Stored
Data
Result
5min window
Complex Event Processing User
Stream Data
Result