Streaming - SQL

> (Data|State) Management and Processing > (Data Processing|Data Integration) > (Stream|Pipe|Message Queue|Event Processing)

1 - About

continuous SQL query on an infinite data stream

A streaming sql can not be ANSI SQL compliant because the streaming functions are not part of those database standards.

A streaming query is a query that executes continuously over streaming data.

In real-time, streaming queries:

  • operates continuously on data
  • updates results incrementally
  • outputs a result if the condition is met

2.1 - Usage

  • real-time alerts
  • sensor data analytics (weather, temperatur..).
Advertising

3 - Windows

4 - Syntax

4.1 - MATCH_RECOGNIZE clause

  • originated in Oracle Continuous Query Language (Oracle CQL), based on SQL and used on streaming data.

5 - Language

6 - Implementation

7 - Documentation / Reference

Advertising
data/processing/stream/sql.txt · Last modified: 2019/04/12 16:33 by gerardnico